[ot] where to get car data
Has anyone had to get a list of car makes and model's before ? Where did you get them from ? I need UK/Euro ones, so things like http://www.pluup.com/car-make-models.php are unfortunately not going to work. -- Helping to professionally orchestrate dot-com best-of-breed functionalities as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word âpartnerâ to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.com. ~| 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:323624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: email and encrypt
On Tuesday 16 Jun 2009, Chad Gray wrote: Someone could put ID=5 in there and validate someone else's account. Only if they knew the matching email address to that number, or you could verify that from the logged session or something. -- Helping to authoritatively exploit clicks-and-mortar 24/7 clicks-and-mortar slick content as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| 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:323625 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
On Wednesday 17 Jun 2009, Peter Boughton wrote: You can get emulators (e.g. WINE) Wine Is Not an Emulator :-) A better choice these days is a virtual machine (e.g VirtualBox, VMWare, etc) that allows you to run actual Windows on virtual hardware - this is likely to cope with most things, (although I'm not sure how they cope with demanding things like games). However, you need a Windows licence to use Windows in them, which may or may not be possible. I gave away my last XP licence when I got my new machine with Ubuntu preloaded, for instance. WINE doesn't need such a licence. You can phase in Linux easily enough by duel booting (from a LiveCD or a real install), or starting our with one or other of XP/Linux virtualised. -- Helping to biannually expedite high-yield attention-grabbing low-risk performance-oriented web-readiness as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| 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:323626 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfencode.solaris not working on our CF8-Solaris server
On Wednesday 17 Jun 2009, Ian Skinner wrote: ld.so.1: cfencode.solaris: fatal: libporting.so: open failed: No such Get your sysadmin to install that package :-) -- Helping to completely orchestrate design-patterns as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| 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:323627 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Full screen?
On Wed, Jun 17, 2009 at 10:54 PM, Don L do...@yahoo.com wrote: Hulu movie has a full screen option, I'm wondering if we could also easily implement that for a cf web app? Has anyone done something like that? Note, Flash Full Screen mode does NOT allow you to work on another monitor while it's in full screen mode. You are better off with a full screen pop up window... a href=http://www.houseoffusion.com/; onclick=window.open(this.href, 'child', 'height=' + screen.height + ',width=' + screen.width + ',fullscreen'); return falseHOF/a ~ Casey ~| 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:323628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
Has anyone else experienced this issue before with the application scope? So if I ripped this out of the application scope you think it the issue I am having would be fixed correct? Also, please explain what you mean by ensuring that the arguments parameters aren't sticky? Do you mean referencing the scope in the cfargument tag? Like... cfargument name=arguments.placeholder type=string required=yes cfargument name=arguments.language type=string required=yes Instead of... cfargument name=placeholder type=string required=yes cfargument name=language type=string required=yes Thanks! -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, June 17, 2009 3:42 PM To: cf-talk Subject: RE: Application Scope Problem Completely agree with Brad. Also wouldn't hurt to ensure that the arguments parameters aren't sticky, by referencing the scope of 'language' and 'placeholder' as appropriate. cffunction access=public name=lookup returntype=string output=no hint=Returns the text found for the given language and placeholder cfargument name=placeholder type=string required=yes cfargument name=language type=string required=yes cfset var tempText = cfset var getTranslation = / cfset var varName = / !--- Attempt to short-circuit the whole translation-in-memory thing, and just do a lookup TVR 1/19/2008 --- cfquery name=getTranslation datasource=mainDNS SELECT content FROM translations WHERE lang = cfqueryparam CFSQLType=STRING value=#arguments.language# AND placeholder = cfqueryparam CFSQLType=STRING value=#arguments.placeholder# /cfquery !--- If nothing found, and not already looking for English, check English --- cfif (getTranslation.recordCount EQ 0) AND (arguments.language NEQ 'EN') cfquery name=getTranslation datasource=mainDNS SELECT content FROM translations WHERE lang = 'EN' AND placeholder = cfqueryparam CFSQLType=STRING value=#arguments.placeholder# /cfquery /cfif cfif getTranslation.recordCount NEQ 0 !--- Replace any variables in the text, marked by % %, with values passed to the function as var1, var2, etc. --- cfset tempText = getTranslation.content cfloop collection=#arguments# item=varName cfif ucase(left(varName, 3)) eq VAR cfset tempText = replaceNoCase(tempText, % #varName#%, arguments[varName]) /cfif /cfloop /cfif cfreturn temptext /cffunction From: b...@bradwood.com Sent: Wednesday, June 17, 2009 3:38 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: Application Scope Problem Do you think this could have anything to do with the fact that this function is being stored in the application scope? === Yes, it has everything to do with that. You need to var EVERY variable used in that function. Otherwise it is shared by everyone calling your code at the exact same time getTranslation and varName need to be varred like so at the top of the function. ~Brad ~| 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:323629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
Has anyone else experienced this issue before with the application scope? So if I ripped this out of the application scope you think it the issue I am having would be fixed correct? Also, please explain what you mean by ensuring that the arguments parameters aren't sticky? Do you mean referencing the scope in the cfargument tag? Like... cfargument name=arguments.placeholder type=string required=yes cfargument name=arguments.language type=string required=yes Instead of... cfargument name=placeholder type=string required=yes cfargument name=language type=string required=yes Thanks! -Original Message- From: Jason Fisher [mailto:ja...@wanax.com] Sent: Wednesday, June 17, 2009 3:42 PM To: cf-talk Subject: RE: Application Scope Problem Completely agree with Brad. Also wouldn't hurt to ensure that the arguments parameters aren't sticky, by referencing the scope of 'language' and 'placeholder' as appropriate. From: b...@bradwood.com Sent: Wednesday, June 17, 2009 3:38 PM To: cf-talk cf-talk@houseoffusion.com Subject: RE: Application Scope Problem Do you think this could have anything to do with the fact that this function is being stored in the application scope? === Yes, it has everything to do with that. You need to var EVERY variable used in that function. Otherwise it is shared by everyone calling your code at the exact same time getTranslation and varName need to be varred like so at the top of the function. ~Brad ~| 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:323630 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
One hurdle to consider is how supported is your hardware. I really wanted to move to Ubuntu (I was upgrading drives anyway), but hit problem after problem on my Dell 1501 using the 8.10 release. It seems that the 1501 just has craptastic time of it based on the amount of reports I found over the net, most of it stemming from unreliable driver sets for the wireless card. I spent several days trying to get everything to play nicely together, but gave it up for bad in the end. This doesn't mean that linux (or Ubuntu) is bad, just that for this particular laptop it wasn't worth it. Matthew Williams Geodesic GraFX ~| 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:323631 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Application Scope Problem
We have had instances where a component, stored in the application scope, could not be found. It is weird, because it works 99% of the time. Thanks, Mike -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Thursday, June 18, 2009 7:54 AM To: cf-talk Subject: RE: Application Scope Problem Has anyone else experienced this issue before with the application scope? So if I ripped this out of the application scope you think it the issue I am having would be fixed correct? Also, please explain what you mean by ensuring that the arguments parameters aren't sticky? Do you mean referencing the scope in the cfargument tag? ~| 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:323632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Application Scope Problem
How are you setting the component in the app scope? -Original Message- From: Dawson, Michael [mailto:m...@evansville.edu] Sent: 18 June 2009 14:20 To: cf-talk Subject: RE: Application Scope Problem We have had instances where a component, stored in the application scope, could not be found. It is weird, because it works 99% of the time. Thanks, Mike ~| 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:323633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
Sticky, meaning that a variable holds the same value across multiple calls, because it's in the application scope, and therefore shared across all users of that application. The 'arguments' scope should be used within the body of the function, not the CFARGUMENT tag. So, this is fine: cfargument name=placeholder type=string required=yes cfargument name=language type=string required=yes But then in the code, as I showed in my previous post, do this: WHERE language = cfqueryparam cfsqltype=cf_sql_varchar value=#arguments.language# / Instead of ... WHERE language = cfqueryparam cfsqltype=cf_sql_varchar value=#language# / Between that and using the 'var' flag on the variables that are internal to the function, as Brad noted, you should be in much better shape. ~| 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:323634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Application Scope Problem
Code Example !--- Start set application in scope --- cfset application.translator=createObject(component,'packages.translator.transla tor') !--- End set application in scope --- !--- Start function --- cffunction access=public name=lookup returntype=string output=no hint=Returns the text found for the given language and placeholder cfargument name=placeholder type=string required=yes cfargument name=languagetype=string required=yes cfset var tempText = !--- Attempt to short-circuit the whole translation-in-memory thing, and just do a lookup TVR 1/19/2008 --- cfquery name=getTranslation datasource=mainDNS SELECT * FROM translations WHERE lang = cfqueryparam CFSQLType=STRING value=#language# AND placeholder = cfqueryparam CFSQLType=STRING value=#placeholder# /cfquery !--- If nothing found, and not already looking for English, check English --- cfif (getTranslation.recordCount EQ 0) AND (language NEQ 'EN') cfquery name=getTranslation datasource=mainDNS SELECT * FROM translations WHERE lang = 'EN' AND placeholder = cfqueryparam CFSQLType=STRING value=#placeholder# /cfquery /cfif cfif getTranslation.recordCount NEQ 0 !--- Replace any variables in the text, marked by % %, with values passed to the function as var1, var2, etc. --- cfset tempText = getTranslation.content cfloop collection=#arguments# item=varName cfif ucase(left(varName, 3)) eq VAR cfset tempText = replaceNoCase(tempText, % #varName# %, arguments[varName]) /cfif /cfloop /cfif cfreturn temptext /cffunction !--- End function --- !--- Start Usage --- cfoutput #application.translator.lookup(placeholder=testtext.69EE0E03,language=requ est.current_lang)# /cfoutput !--- End Usage --- -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Thursday, June 18, 2009 9:43 AM To: cf-talk Subject: RE: Application Scope Problem How are you setting the component in the app scope? ~| 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:323635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Application Scope Problem
Sorry Paul, I was talking to Michael. Just wanted to see how it was set because I've had similar errors but I put it down to OnApplicationStart only partially completing because of an error so some init code wasn't reached. Adrian -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: 18 June 2009 14:53 To: cf-talk Subject: RE: Application Scope Problem Code Example !--- Start set application in scope --- cfset application.translator=createObject(component,'packages.translator.tr ansla tor') !--- End set application in scope --- !--- Start function --- cffunction access=public name=lookup returntype=string output=no hint=Returns the text found for the given language and placeholder cfargument name=placeholder type=string required=yes cfargument name=language type=string required=yes cfset var tempText = !--- Attempt to short-circuit the whole translation-in-memory thing, and just do a lookup TVR 1/19/2008 --- cfquery name=getTranslation datasource=mainDNS SELECT * FROM translations WHERE lang = cfqueryparam CFSQLType=STRING value=#language# AND placeholder = cfqueryparam CFSQLType=STRING value=#placeholder# /cfquery !--- If nothing found, and not already looking for English, check English --- cfif (getTranslation.recordCount EQ 0) AND (language NEQ 'EN') cfquery name=getTranslation datasource=mainDNS SELECT * FROM translations WHERE lang = 'EN' AND placeholder = cfqueryparam CFSQLType=STRING value=#placeholder# /cfquery /cfif cfif getTranslation.recordCount NEQ 0 !--- Replace any variables in the text, marked by % %, with values passed to the function as var1, var2, etc. --- cfset tempText = getTranslation.content cfloop collection=#arguments# item=varName cfif ucase(left(varName, 3)) eq VAR cfset tempText = replaceNoCase(tempText, % #varName# %, arguments[varName]) /cfif /cfloop /cfif cfreturn temptext /cffunction !--- End function --- !--- Start Usage --- cfoutput #application.translator.lookup(placeholder=testtext.69EE0E03,language =requ est.current_lang)# /cfoutput !--- End Usage --- -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Thursday, June 18, 2009 9:43 AM To: cf-talk Subject: RE: Application Scope Problem How are you setting the component in the app scope? ~| 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:323636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Deploying to a server farm
We have 6 CF servers that span our application. Internally I can access each server on the private network by IP address. Our servers also share a single file system so the files are all ways in sync. I wrote code that can be called from any server that then lets me pick any one or more servers to reset via remote cfhttp call to a private password protected service. This then calls the application reset code. Since we also use the server scope I have a similar routine for that as well. We NEVER restart the ColdFusion servers. We have 82 days since the last restart on four of our servers and those were due to hardware upgrades the other two servers have gone 218 days since their last restart. Our Mlsfinder.com web application is used so heavily that even with 6 servers we do not ever want to shut one down midday. It would cause thousands of users to loose their sessions and bounced to another server. As I type this I see over 10,700 active user sessions spread across the servers, so that's why I wrote the code for the remote resets. Also, external URL based resets are bad since if discovered it can be exploited and essentially cause a DOS attack by continuously resetting your server. Wil Genovese Sr. Web Application Developer ~| 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:323637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Application Scope Problem
Well, it's different than I thought. I think, at one time, we had the component in the application scope, but took it out because of similar errors. Now, the component is only created on the few pages where it is required. Still, we have the intermittant errors. Here is one of the error messages: Could not find the ColdFusion Component or Interface GlobalFunctions. Ensure that the name is correct and that the component or interface exists. brThe error occurred on line 22. It is called by: cfset globalFunctions = createObject(component, GlobalFunctions) It may be an issue with component instantiation because this works 99% of the time, but fails without any explanation. Thanks, Mike -Original Message- From: Adrian Lynch [mailto:cont...@adrianlynch.co.uk] Sent: Thursday, June 18, 2009 8:43 AM To: cf-talk Subject: RE: Application Scope Problem How are you setting the component in the app scope? ~| 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:323638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC and jQuery
Just to give you another way of looking at it. JSON is just a string format, much like WDDX is (although a lot less verbose). Without parsing, it's still just a string. The manual way of converting JSON to a JS data struct is by calling eval() on it - like so: var data = eval(myJSONString); And you are good to go. Mark On Thu, Jun 18, 2009 at 9:16 AM, Josh Nathanson p...@oakcitygraphics.comwrote: Mark, You are correct in that I am getting a string back, but the eval fuction does not seem to work. I just get a copy of the same JSON formatted string. Do you know whether there is a string to JSON conversion method out there? Thanks, James ~| 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:323639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC and jQuery
1) Add dataType:'json' as an attribute of your ajax call, or use $.
getJSON
2) use Firebug / console.log to examine the response, make sure DATA
is a
valid property of the response JSON
-- Josh
I am trying to call a query from a CFC using jQuery with the
following code:
$(document).ready(
function () {
$.ajax({
type: GET,
url: SpellChecker.cfc?method=getTextMemoFieldsreturnformat=json
queryformat=column,
data: datastring,
success:
function(response) {
var resp = jQuery.trim(response);
alert(resp);
}
});
});
When I look at the data inside an alert it looks exactly like it
should.
However, when I try to get to the values inside of it (e.g. resp.
DATA) it is
always undefined. Do I need to perform an extra step? I appreciate
any
advice I can get on this.
Thanks,
JW
Josh,
1. I already am getting the results back in JSON format using the
returnformat=json parameter. I tried $.getJSON without much success
(If you know of a good CFC example using $.getJSON, I'd be happy to
review it). I cannot even get results back using it, where as with
the $.ajax I get results, I just can't seem to do much with them but
print the whole json object(i.e. document.write) to a page or display
the results in an alert box.
2. I am Firebug and I did verify that DATA is a valid parameter.
Basically I am returning a db table and putting in JSON format. The
code I have returns the following:
{ROWCOUNT:20,COLUMNS:[SAVEDVALUE],DATA:{SAVEDVALUE:[blah,
blah,blah]}}
But when I try and access for instance resp.ROWCOUNT, it's undefined.
So basically, I want to know how I can actually get to the values I
can only seem to read.
Thanks,
James
Josh,
I tried datatype: 'json' and get back the same string. I did look at it on
Firebug and got back a black URL instread of the green one like you said. I
have tried converting the string using the eval method to no avail. Do you
know if there is a string to JSON conversation method out there?
Thanks,
James
~|
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:323640
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Ubuntu - how WinXP compatible?
On Thursday 18 Jun 2009, Matthew Williams wrote: This doesn't mean that linux (or Ubuntu) is bad, just that for this particular laptop it wasn't worth it. Aye, and that's why trying with a LiveCD is a must to check things out. Pity Vista/Windows 8 don't allow that, eh. -- Helping to revolutionarily exploit designs as part of the IT team of the year, '09 and '08 This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.halliwells.co ~| 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:323641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
JS Question: How to include a parameter when assigning a function to an event.
I have this code that is assigning a JS function to the onClick events of elements. container.childNodes[i].onclick = openClose; I would like to assign parameters so that the openClose function of different elements function on specific items. I recoginize that this syntax is not going to work: container.childNodes[i].onclick = openClose(paramA,paramB); But my Google searching skills are failing me on finding how one would do this type task, but surely it has got to be possible. I just can't imagine that it is not possible to define a function for an event handler that can not use parameters. ~| 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:323642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFHTTP post modifying strings on form post? CF vs PHP
I have a CF page with this: cfhttp method=POST url=http://test.local/test.php; cfhttpparam type=formField name=msg value=I \ am /cfhttp cfoutput#cfhttp.filecontent#/cfoutput And a PHP receiving page: you said: ?php echo $_POST['msg']; ? The output of the CFML page is: you said: I \\ am So, who is responsible for the extra backslash in the output? Is it cfhttp or is it php, and why? Other characters like quotes and such are also being escaped. Note that if you post to a CFML page then there isnt any extra backslash in the output. ~| 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:323643 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Another excel file reading question
Excellent observation. I've altered the code to close the connection as well as the resultset and will respond back to confirm that change does allow another dynamic odbc connection to be opened without restarting coldfusion. I do not use dynamic odbc excel connections much. But one thing that jumps out at me is you are closing the resultset, but not the connection object. Always close both, and use error handling to make sure the objects are properly closed in the event of an error. But you might also consider using a fixed datasource instead. IIRC, you can read excel files dynamically using a single MS Access or Excel/odbc datasource. ~| 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:323644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JS Question: How to include a parameter when assigning a function to an event.
I finally found the right combination of Google Search terms and
following other links to find at least one solution:
container.childNodes[i].onclick = function() {openClose('hello world')};
I would be interesting in hearing if there are other solutions or any
difficulties I might have with this version.
TIA
Ian
~|
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:323645
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: CFC and jQuery
Well eval is essentially a string-to-json conversion. Are you sure your json is valid? Try going here and pasting in your string: http://www.jsonlint.com/ Also, in your jQuery ajax call, it has to be dataType with the capital T - javascript is case sensitive. Josh, I tried datatype: 'json' and get back the same string. I did look at it on Firebug and got back a black URL instread of the green one like you said. I have tried converting the string using the eval method to no avail. Do you know if there is a string to JSON conversation method out there? Thanks, James ~| 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:323646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFHTTP post modifying strings on form post? CF vs PHP
The wireshark dump confirmed that it WAS NOT cfhttp doing this, but rather a feature of php called magic quotes More info posted here: http://help.imified.com/faqs/building-imified-bots/backslashses-are-inserted-before-certain-characters-when-my-bot-replies I have a CF page with this: cfhttp method=POST url=http://test.local/test.php; cfhttpparam type=formField name=msg value=I \ am /cfhttp cfoutput#cfhttp.filecontent#/cfoutput And a PHP receiving page: you said: ?php echo $_POST['msg']; ? The output of the CFML page is: you said: I \\ am So, who is responsible for the extra backslash in the output? Is it cfhttp or is it php, and why? Other characters like quotes and such are also being escaped. Note that if you post to a CFML page then there isnt any extra backslash in the output. ~| 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:323647 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: JS Question: How to include a parameter when assigning a function to an event.
Other solutions? Use JQuery or Ext Core for this type of binding. Makes
it very simple, and avoids any cross browser issues.
Steve Cutter Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
Co-Author of Learning Ext JS
http://www.packtpub.com/learning-ext-js/book
_
http://blog.cutterscrossing.com
On 6/18/2009 10:51 AM, Ian Skinner wrote:
I finally found the right combination of Google Search terms and
following other links to find at least one solution:
container.childNodes[i].onclick = function() {openClose('hello world')};
I would be interesting in hearing if there are other solutions or any
difficulties I might have with this version.
TIA
Ian
~|
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:323648
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: multiple session instances
found out the reason why the onsessionend was not always getting called - i had structclear(session) in the log out code which causes the onsessionend not to fire: here is a good site that i got all the info from to get it working: http://www.daveshuck.com/blog/2008/01/16/Calling-OnSessionEnd-from-outside-the-Applicationcfc-to-log-out-users right i see, thanks do you know of any supported ways of gathering all the active sessions. i know some have suggested to copy the session into the application scope onsessionstart and remove it onsessionend, however this has caused us problems in the past and doesnt always get deleted. thanks I don't have an answer for your question, but since the coldfusion.runtime.SessionTracker class is an undocumented and unsupported feature of ColdFusion your only luck might be if an Adobe programmer steps in and offers some insight to the inner working of CF. Let us know what you find. ~Brad hi i have been using the following code to analyse sessions: var oSession = createObject(java,coldfusion.runtime. SessionTracker); var mySessions= oSession.getSessionCollection(arguments.appName); i have noticed that sometimes a session has multiple instances. for example if i log in to our application (which creates a ), then dump out the mySessions variable from above it sometimes has several structure elements: appname_encryptedCode1 appname_encryptedCode2 etc... ... and all instances have the same contents. they also do not get cleared when i use the structclear(session) function... i am using j2ee session variables this only happens sometimes and i cannot replicate it purposely does anyone have any ideas? ~| 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:323649 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: JS Question: How to include a parameter when assigning a function to an event.
Use JQuery and then check out the documentation on binding an event.
A classic example is passing the id to a function to identify that element
inside of the function:
$(#TheButton).bind(click,function(el){openClose( $(this).attr(id) )});
function openClose(el){
if($(el).is(.closed)){
$(el).show();
$(el).addClass(open);
}
if($(el).is(.open){
$(el).hide();
$(el).addClass(closed);
}
}
Make sense?
~|
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:323650
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: captcha
I started to put in this system and ran into an error.. It may be that I'm adapting it to Fusebox, but perhaps not.. On the processing page, I get.. Could not find the ColdFusion Component or Interface cfformprotect.cffpVerify. Ensure that the name is correct and that the component or interface exists. 1 : cfset Cffp = CreateObject(component,cfformprotect.cffpVerify).init() / I've verified that the form line is there and that all the pathways are pointing to the correct spots.. Anyone else having this issue or know a way around it? On Tue, Jun 2, 2009 at 7:51 AM, Jason Fisherja...@wanax.com wrote: I have also had decent luck with the hidden form field. In your form, put an input type=text in a div that is display: none, so the field isn't technically hidden, but a human won't see it, and then call the field something like name=lastName, something that a bot will always fill out. (Example works in a form that does not also have a 'real' form field called lastName, of course.) Then on submission, server-side, CFIF len(form.lastName) then bail out and don't process the results at all. CFFORMPROTECT is much more robust, of course, covering several different bot / hack angles, but I often use the non-displayed form field as a quick, lightweight filter. ~| 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:323651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
css and cfdocument...grrr
Ok, I know cfdocument is finicky about the html it tries to render into a pdf. I have a template I'm putting together and it validates xhtml transitional, it uses both @import and link to include the stylesheet (just in case), I use a standard Yahoo supplied reset css file and the resulting html renders identically in Firefox, IE 7 and Chrome. So, several things don't actually render correctly at all in the resulting pdf. Things like background colors bleeding over into other elements, background colors not showing up at all on a div whose only content are other divs, etc. Where are the best places to look for tips on making it behave? And are there good troubleshooting guides for things to pay attention to/avoid? I'm ok with a little black magic but this is getting irritating as there is no obvious place to correct these problems. Thanks, Judah ~| 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:323652 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: css and cfdocument...grrr
Also, floats don't work correctly in cfdocument. -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, June 18, 2009 1:17 PM To: cf-talk Subject: css and cfdocument...grrr Ok, I know cfdocument is finicky about the html it tries to render into a pdf. I have a template I'm putting together and it validates xhtml transitional, it uses both @import and link to include the stylesheet (just in case), I use a standard Yahoo supplied reset css file and the resulting html renders identically in Firefox, IE 7 and Chrome. So, several things don't actually render correctly at all in the resulting pdf. Things like background colors bleeding over into other elements, background colors not showing up at all on a div whose only content are other divs, etc. Where are the best places to look for tips on making it behave? And are there good troubleshooting guides for things to pay attention to/avoid? I'm ok with a little black magic but this is getting irritating as there is no obvious place to correct these problems. Thanks, Judah ~| 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:323653 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: css and cfdocument...grrr
This is pretty old but it might be helpful. http://www.coldfusionmuse.com/index.cfm/2006/2/16/cfdocument.performance The main thing to realize is that converting HTML to PDF is really a trick - going from a fluid medium to a very staticky and specific medium. Unless your HTML is already pretty lean and minimal you may need a different layout wrapper. Also check to see if your CSS is even making it into cfdocument. Remember that if you use something like: link rel=stylesheet type=text/css href=/css/mystylesheet.css media=screen / In your cfdocument, CF has to retrieve that resource to include it into the doc. Under the hood it makes a cfhttp call right? The server has to resolve the domain into the proper IP etc. So a lot of things might have to go right for that to work. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, June 18, 2009 1:17 PM To: cf-talk Subject: css and cfdocument...grrr Ok, I know cfdocument is finicky about the html it tries to render into a pdf. I have a template I'm putting together and it validates xhtml transitional, it uses both @import and link to include the stylesheet (just in case), I use a standard Yahoo supplied reset css file and the resulting html renders identically in Firefox, IE 7 and Chrome. So, several things don't actually render correctly at all in the resulting pdf. Things like background colors bleeding over into other elements, background colors not showing up at all on a div whose only content are other divs, etc. Where are the best places to look for tips on making it behave? And are there good troubleshooting guides for things to pay attention to/avoid? I'm ok with a little black magic but this is getting irritating as there is no obvious place to correct these problems. Thanks, Judah ~| 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:323654 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
The CSS file is definitely being included, so that's good. And I haven't tried to do anything with images yet, thankfully. Perhaps I need to move to a fixed-width layout using inches as units instead of percentages. Or maybe tables. Blech. Thanks for that link though, I haven't looked at that one in quite awhile. Judah On Thu, Jun 18, 2009 at 11:40 AM, Mark Kruger mkru...@cfwebtools.comwrote: This is pretty old but it might be helpful. http://www.coldfusionmuse.com/index.cfm/2006/2/16/cfdocument.performance The main thing to realize is that converting HTML to PDF is really a trick - going from a fluid medium to a very staticky and specific medium. Unless your HTML is already pretty lean and minimal you may need a different layout wrapper. Also check to see if your CSS is even making it into cfdocument. Remember that if you use something like: link rel=stylesheet type=text/css href=/css/mystylesheet.css media=screen / In your cfdocument, CF has to retrieve that resource to include it into the doc. Under the hood it makes a cfhttp call right? The server has to resolve the domain into the proper IP etc. So a lot of things might have to go right for that to work. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Judah McAuley [mailto:ju...@wiredotter.com] Sent: Thursday, June 18, 2009 1:17 PM To: cf-talk Subject: css and cfdocument...grrr Ok, I know cfdocument is finicky about the html it tries to render into a pdf. I have a template I'm putting together and it validates xhtml transitional, it uses both @import and link to include the stylesheet (just in case), I use a standard Yahoo supplied reset css file and the resulting html renders identically in Firefox, IE 7 and Chrome. So, several things don't actually render correctly at all in the resulting pdf. Things like background colors bleeding over into other elements, background colors not showing up at all on a div whose only content are other divs, etc. Where are the best places to look for tips on making it behave? And are there good troubleshooting guides for things to pay attention to/avoid? I'm ok with a little black magic but this is getting irritating as there is no obvious place to correct these problems. Thanks, Judah ~| 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:323655 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
I use an alternate style sheet that sets fonts to a point size instead of em and has a fixed width. Even then, I sometimes run into an odd scaling down effect if there is too much data. Also, if you have images that you are resizing for the web, make an alternate actual size image for the pdf. cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 11:50 AM -0700 wrote: The CSS file is definitely being included, so that's good. And I haven't tried to do anything with images yet, thankfully. Perhaps I need to move to a fixed-width layout using inches as units instead of percentages. Or maybe tables. Blech. Thanks for that link though, I haven't looked at that one in quite awhile. Judah ~| 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:323656 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: css and cfdocument...grrr
Font sizes I specified in pt instead of em and I tried to do everything in percentages with no px definitions under the theory that pdf is a vector format. No love. Thanks for all the ideas being tossed out though. Judah On Thu, Jun 18, 2009 at 12:00 PM, Randi Knutson rknut...@otan.us wrote: I use an alternate style sheet that sets fonts to a point size instead of em and has a fixed width. Even then, I sometimes run into an odd scaling down effect if there is too much data. Also, if you have images that you are resizing for the web, make an alternate actual size image for the pdf. cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 11:50 AM -0700 wrote: The CSS file is definitely being included, so that's good. And I haven't tried to do anything with images yet, thankfully. Perhaps I need to move to a fixed-width layout using inches as units instead of percentages. Or maybe tables. Blech. Thanks for that link though, I haven't looked at that one in quite awhile. Judah ~| 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:323657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: captcha
I started to put in this system and ran into an error.. It may be that I'm adapting it to Fusebox, but perhaps not.. On the processing page, I get.. Could not find the ColdFusion Component or Interface cfformprotect.cffpVerify. Ensure that the name is correct and that the component or interface exists. 1 : cfset Cffp = CreateObject(component,cfformprotect.cffpVerify).init() / I've verified that the form line is there and that all the pathways are pointing to the correct spots.. Anyone else having this issue or know a way around it? I don't think all the pathways are pointing to the correct spots. That's really the only reason I can think of that you'd have this error, so I recommend you take another look. 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:323658 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
I should have mentioned that I had to put everything in tables for layout. I also removed every non-basic CSS thing I had. I ended up with a print version and a simle print style sheet and the web version with its own nicer style sheet. My client had what is basically an accounting spreadsheet they wanted recreated in a web form, then pdf'd for an official copy. It took me almost 3 weeks to match the original's exact positioning, font, layout, etc. Good times. cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 12:07 PM -0700 wrote: Font sizes I specified in pt instead of em and I tried to do everything in percentages with no px definitions under the theory that pdf is a vector format. No love. Thanks for all the ideas being tossed out though. ~| 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:323659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Converted Application.cfm to Application.cfc and Having Problems
I have a server with several web sites on it. One site was built with legacy code and the old Application.cfm file. Because of that, I had some mappings and custom tag paths set up in the CF administrator for the entire server. I ran into some conflicts with a new site I'm building. I found that, even though I was using per-app mappings/paths on the new site, it was still using the global CF mappings/paths. So, this afternoon, I converted the Application.cfm file to Application.cfc. The code doesn't do much other than set a session variable with the result from a CF component. The first thing I noticed was that each page request took several seconds to respond. Before, with the Application.cfm file, each page came back in sub-second times. The second thing I noticed was that the main custom tag, used for the header/footer, cannot be found some of the time. I don't think it is a configuration issue because it works sometimes, too. This is the error I get: Cannot find CFML template for custom tag renderpage. I restarted the CF service and deleted all of the files in WEB-INF/cfclasses, but nothing has helped the situation. The only thing I can think of is that I have a per-app custom tag path that points to the root of the web site as well as a per-app custom tag path that points directly to the directory that contains the custom tags. (For now, the custom tag path that point to the root of the site is necessary to find the components until I can change all references to all of the components.) I also removed the global mappings and custom tag paths that were used for this site. Any help would be greatly appreciated. Michael Dawson Manager of Web Applications Office of Technology Services University of Evansville Each time you send an email message with a background pattern or loud background color, an endangered tree dies. Please help us save a tree. Just say NO to email backgrounds. ~| 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:323660 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converted Application.cfm to Application.cfc and Having Problems
BTW, this is all I have in the Application.cfc at this moment. cfcomponent output=false cfset this.name = AceLink cfset this.customTagPaths = D:\Inetpub\AceLink\custtags,D:\Inetpub\AceLink cfset this.mappings[/] = D:\Inetpub\AceLink cfset this.sessionManagement = true cfset this.sessionTimeout = createTimeSpan(0, 0, 15, 0) cfset this.clientManagment = false cfset this.setClientCookies = false cffunction name=onSessionStart access=public returntype=void output=no cfset session.objUser = CreateObject(component, cfc.User.User) !---Allow user to enter acenet\username, acenet/username or username or usern...@domain.com.--- cfset session.objuser.init(lCase(listLast(listFirst(cgi.auth_user, @), \/))) /cffunction /cfcomponent Thanks, Mike ~| 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:323661 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: captcha
Can you tell me what file sets this? On Thu, Jun 18, 2009 at 12:12 PM, Dave Wattsdwa...@figleaf.com wrote: I started to put in this system and ran into an error.. It may be that I'm adapting it to Fusebox, but perhaps not.. On the processing page, I get.. Could not find the ColdFusion Component or Interface cfformprotect.cffpVerify. Ensure that the name is correct and that the component or interface exists. 1 : cfset Cffp = CreateObject(component,cfformprotect.cffpVerify).init() / I've verified that the form line is there and that all the pathways are pointing to the correct spots.. Anyone else having this issue or know a way around it? I don't think all the pathways are pointing to the correct spots. That's really the only reason I can think of that you'd have this error, so I recommend you take another look. 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:323662 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
pagination and large recordsets (mysql)
hey guys, came across the following blog post... http://www.webveteran.com/blog/index.php/web-coding/coldfusion/mysql-and-coldfusion-pagination-version-2/ it is really great and works very fast indeed on a large amount of data. however i was wondering if anyone has seen a similar concept in cfc format eg. not having to put the WHERE clause in the url. mike ~| 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:323663 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: ajaxCFC Access Denied
Sorry for that!
Hey, I don't know why I didn't see about the mapping thing, that the dots means
the level of the folder.
Still funny, but I was able to make some pages to work after deleting and
uploading the ajax.cfc from the root to the components folder. Still a mistery,
but it's working so far.
I have been looking into my code for another page that is partially working.
The parts that are working are making ajax calls to a function and the function
has a query that executes a SQL command. No big deal. Now, other sections of
the page don't work because I am using a function that calls a SP called
sp_updateBasePKG.
Locally this work, but at the server it gives me the following error:
The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined values.
You might have seen this error before, and I believe this is what is making my
ajax calls to crash. I notice this error because I have one button that it used
to upload files to the server, well, this button calls the same function that
calls that SP.
Here is the function:
cffunction name=updatePKG returntype=any hint=Generic update
cfargument name=in_table type=any required=false default=
cfargument name=in_column type=any required=false default=
cfargument name=in_new_value type=any required=false default=
cfargument name=in_where type=any required=false default=
cfset var loc = structnew() /
cfstoredproc procedure = sp_updateBasePKG
datasource=#Application.Global.dsn# username=#Application.Global.dsnUN#
password=#Application.Global.dsnPW#
cfprocparam type = IN cfsqltype=cf_sql_varchar
value=#arguments.in_table#
cfprocparam type = IN cfsqltype=cf_sql_varchar
value=#arguments.in_column#
cfprocparam type = IN cfsqltype=cf_sql_varchar
value='#arguments.in_new_value#'
cfprocparam type = IN cfsqltype=cf_sql_varchar
value=#arguments.in_where#
!---cfprocparam type = OUT cfsqltype=cf_sql_varchar variable=results---
/cfstoredproc
!---cfset loc = {
r2 = #results#
} /---
cfreturn 1
/cffunction
I commented out the OUT parameter because that is where I was having the
problem, but now is the one above in_where that is causing the error.
Any thoughts on that?
Thanks again
~|
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:323664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: pagination and large recordsets (mysql)
There is a pagination cfc at cflib.org. As for that link...oh my gosh...sql injection anyone? -- Josh -Original Message- From: Mike Little [mailto:m...@nzsolutions.co.nz] Sent: Thursday, June 18, 2009 1:20 PM To: cf-talk Subject: pagination and large recordsets (mysql) hey guys, came across the following blog post... http://www.webveteran.com/blog/index.php/web-coding/coldfusion/mysql-and-col dfusion-pagination-version-2/ it is really great and works very fast indeed on a large amount of data. however i was wondering if anyone has seen a similar concept in cfc format eg. not having to put the WHERE clause in the url. mike ~| 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:323665 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Can you tell me what file sets this? It's controlled by mappings in the CF Administrator. 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:323666 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: pagination and large recordsets (mysql)
haha - that was my though exactly !! thanks for the link. mike There is a pagination cfc at cflib.org. As for that link...oh my gosh...sql injection anyone? -- Josh hey guys, came across the following blog post... http://www.webveteran.com/blog/index.php/web-coding/coldfusion/mysql-and-col dfusion-pagination-version-2/ it is really great and works very fast indeed on a large amount of data. however i was wondering if anyone has seen a similar concept in cfc format eg. not having to put the WHERE clause in the url. mike ~| 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:323667 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: pagination and large recordsets (mysql)
Mike, The idea is pretty good - in fact, the mysql function found_rows() is very intriguing. Now, with the code example, I would say that is really, really bad SQL, putting the entire where clause in the URL - you're right to be suspicious. I am sure you could just rig up the query to use queryparams and it would be fine. Now, having said that, I also think reinventing pagination isn't useful at this point. I have this project at riaforge - http://paginationcfc.riaforge.org/ - a well documented CFC that handles pagination. The problem between my component and using mysql like Jules, is my component uses the recordcount of the query to determine how many pages there are. You can, however, extend it to do just that. Check the docs under extending to see an example: http://www.dopefly.com/projects/pagination/pagination_cfc_documentation.cfm#Section6 It looks like, to do it, you will probably have to make setTotalNumberOfItems() a public method, then also override the private method configureInputs. Let me know if you want any help with that. nathan strutz [Blog and Family @ http://www.dopefly.com/] [AZCFUG Manager @ http://www.azcfug.org/] [Twitter @nathanstrutz] On Thu, Jun 18, 2009 at 1:19 PM, Mike Little m...@nzsolutions.co.nz wrote: hey guys, came across the following blog post... http://www.webveteran.com/blog/index.php/web-coding/coldfusion/mysql-and-coldfusion-pagination-version-2/ it is really great and works very fast indeed on a large amount of data. however i was wondering if anyone has seen a similar concept in cfc format eg. not having to put the WHERE clause in the url. mike ~| 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:323668 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: pagination and large recordsets (mysql)
As for that link...oh my gosh...sql injection anyone? +1 The estimation using LIMIT and FOUND_ROWS() seems okay. But I would re-write the where clause logic to make it safer, and definitely use cfqueryparam. ~| 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:323669 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Ah.. That would explain it. My hosting plan can't set mapping. Though, I wouldn't think it would be a mapping issue, but *shrugs* On Thu, Jun 18, 2009 at 1:49 PM, Dave Wattsdwa...@figleaf.com wrote: Can you tell me what file sets this? It's controlled by mappings in the CF Administrator. 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:323670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: pagination and large recordsets (mysql)
http://paginationcfc.riaforge.org/ Works like a charm. On Thu, Jun 18, 2009 at 4:19 PM, Mike Little m...@nzsolutions.co.nz wrote: hey guys, came across the following blog post... http://www.webveteran.com/blog/index.php/web-coding/coldfusion/mysql-and-coldfusion-pagination-version-2/ it is really great and works very fast indeed on a large amount of data. however i was wondering if anyone has seen a similar concept in cfc format eg. not having to put the WHERE clause in the url. mike ~| 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:323671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: pagination and large recordsets (mysql)
that's great thanks nathan. i too was intrigued by his code - and it really does work fast (i connect to mysql from a local development server for testing at the moment and the query works faster than anything else on the site ha!) i will check out your project for sure. cheers guys. i think i have what i need now. ~| 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:323672 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Exporting to csv. Every other row is empty.
I've spent days trying to set up a simple export to a .csv file with no luck. cffile keeps saving it in html format so I'm using another solution I found online. It seems to work a lot better than cffile, but when I open the .csv file in MS Excel, every other row is blank. When I open it with notepad, every other line is just comma's. I have no idea where these extra rows of comma's are coming from. If anyone can help, it would be greatly appreciated. Here's my code: cfquery name=qMembers datasource=#Application.Datasource# SELECT id, first_name, middle_initial, last_name, title, company, agent_team_name, company_address1, company_address2, company_city, company_state, company_zip, company_phone, company_phone_ext, company_cell, company_email, company_fax, company_website, join_date, media_center_on_site FROM vErniesExport /cfquery cfsetting enablecfoutputonly=yes cfset delim=44 cfcontent type='application/vnd.ms-excel' cfheader name=content-disposition value=filename=Ernies_Export_#today#.csv cfoutput ID#chr(delim) #First Name#chr(delim) #Middle Initial#chr(delim) #Last Name#chr(delim) #Title#chr(delim) #Company#chr(delim) #Agent/Team Name#chr(delim) #Company Address 1#chr(delim) #Company Address 2#chr(delim) #Company City#chr(delim) #Company State#chr(delim) #Company Zip#chr(delim) #Company Phone#chr(delim) #Company Phone Ext.#chr(delim) #Company Cell#chr(delim) #Company Email#chr(delim) #Company Fax#chr(delim) #Company Website#chr(delim) #Join Date#chr(delim) #Resource Center On-Site/cfoutput cfoutput query=qMembers #id##chr(delim) ##first_name##chr(delim) ##middle_initial##chr(delim) ##last_name##chr(delim) ##title##chr(delim) ##company##chr(delim) ##agent_team_name##chr(delim) ##company_address1##chr(delim) ##company_address2##chr(delim) ##company_city##chr(delim) ##company_state##chr(delim) ##company_zip##chr(delim) ##company_phone##chr(delim) ##company_phone_ext##chr(delim) ##company_cell##chr(delim) ##company_email##chr(delim) ##company_fax##chr(delim) ##company_website##chr(delim) ##DateFormat(join_date, 'm/d/')##chr(delim) ##DateFormat(media_center_on_site, 'm/d/')# /cfoutput ~| 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:323673 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
I'm getting closer to what I want with a table layout. One thing I can't seem to get so far is a solid background behind table headers. border-collapse works in a browser but isn't supported by the cfdocument. Setting border-spacing, padding and margin all to 0 doesn't seem to do it either. Any thoughts? Judah On Thu, Jun 18, 2009 at 12:15 PM, Randi Knutson rknut...@otan.us wrote: I should have mentioned that I had to put everything in tables for layout. I also removed every non-basic CSS thing I had. I ended up with a print version and a simle print style sheet and the web version with its own nicer style sheet. My client had what is basically an accounting spreadsheet they wanted recreated in a web form, then pdf'd for an official copy. It took me almost 3 weeks to match the original's exact positioning, font, layout, etc. Good times. cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 12:07 PM -0700 wrote: Font sizes I specified in pt instead of em and I tried to do everything in percentages with no px definitions under the theory that pdf is a vector format. No love. Thanks for all the ideas being tossed out though. ~| 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:323674 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
Phillip I haven't followed this whole thread, but can you really not set mappings or do you just not have access to the Administrator? In CF8, Railo and OpenBD you can set mappings in your Application.cfc file. -Ryan Phillip Vector wrote: Ah.. That would explain it. My hosting plan can't set mapping. Though, I wouldn't think it would be a mapping issue, but *shrugs* On Thu, Jun 18, 2009 at 1:49 PM, Dave Wattsdwa...@figleaf.com wrote: Can you tell me what file sets this? It's controlled by mappings in the CF Administrator. 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:323675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converted Application.cfm to Application.cfc and Having Problems
After some basic testing, I narrowed the issue down to the call of the onSessionStart method. However, it did not appear to have anything to do with the user.cfc component. Once I put everything back, the web site is faster than teflon snot on a banana peel. Unless someone has any advice on where to start looking for bottlenecks, I'm gonna start dissecting the site tomorrow. Thanks, Mike -Original Message- From: Dawson, Michael [mailto:m...@evansville.edu] Sent: Thursday, June 18, 2009 2:31 PM To: cf-talk Subject: RE: Converted Application.cfm to Application.cfc and Having Problems BTW, this is all I have in the Application.cfc at this moment. cfcomponent output=false cfset this.name = AceLink cfset this.customTagPaths = D:\Inetpub\AceLink\custtags,D:\Inetpub\AceLink cfset this.mappings[/] = D:\Inetpub\AceLink cfset this.sessionManagement = true cfset this.sessionTimeout = createTimeSpan(0, 0, 15, 0) cfset this.clientManagment = false cfset this.setClientCookies = false cffunction name=onSessionStart access=public returntype=void output=no cfset session.objUser = CreateObject(component, cfc.User.User) !---Allow user to enter acenet\username, acenet/username or username or usern...@domain.com.--- cfset session.objuser.init(lCase(listLast(listFirst(cgi.auth_user, @), \/))) /cffunction /cfcomponent Thanks, Mike ~| 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:323676 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: captcha
On the hosting I have, I can not access cf administrator. On Thu, Jun 18, 2009 at 2:24 PM, Ryan Stiller...@cfwebtools.com wrote: Phillip I haven't followed this whole thread, but can you really not set mappings or do you just not have access to the Administrator? In CF8, Railo and OpenBD you can set mappings in your Application.cfc file. -Ryan Phillip Vector wrote: Ah.. That would explain it. My hosting plan can't set mapping. Though, I wouldn't think it would be a mapping issue, but *shrugs* On Thu, Jun 18, 2009 at 1:49 PM, Dave Wattsdwa...@figleaf.com wrote: Can you tell me what file sets this? It's controlled by mappings in the CF Administrator. 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:323677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ajaxCFC Access Denied
Did you check to make sure that the stored procedure in your production environment is identical to the one on your dev environment? If I had to guess, I would say that the 5th parameter to your proc (results) is not an OUTPUT parameter. Are you using SQL Server? If so, your procedure should look something like this (Notice the OUTPUT keyword): CREATE PROCEDURE [dbo].[sp_updateBasePKG] @in_table varchar(200), @in_column varchar(200), @in_new_value varchar(200), @in_where varchar(200), @in_results varchar(200) OUTPUT AS BEGIN ... SELECT @in_results = 'Yeah, Success!' END Also, two other thoughts on this: 1) If this proc call is in a webservice which may be called by more than one person simultaneously, it is NOT thread safe. The variable name results is going to be in the variables scope by default. The fact that you are setting it into a locally scoped variable later only slightly mitigates the problem (That block is currently commented out-- for testing I assume). To eliminate concurrency issues, you need to specify a LOCALLY scoped variable for the output of the proc to be placed in like so: cfprocparam type = OUT cfsqltype=cf_sql_varchar variable=loc.results 2) I really, really, really, really, really, really, really, really hope this Generic Update proc does some scrubbing of its inputs and does NOT simply concatenate a SQL string with the table, column, value, and where clause passed in and execute it or you would have just make life really easy for some SQLi hackers. :) ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres djt...@yahoo.com Date: Thu, June 18, 2009 3:35 pm To: cf-talk cf-talk@houseoffusion.com Locally this work, but at the server it gives me the following error: The system has attempted to use an undefined value, which usually indicates a programming error, either in your code or some system code. Null Pointers are another name for undefined values. I commented out the OUT parameter because that is where I was having the problem, but now is the one above in_where that is causing the error. ~| 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:323678 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: css and cfdocument...grrr
Solid background behind table headers?.must be the pm slump because I
can't think what you mean, but maybe the stuff below will help.
I am using border-collapse and setting borders on all my table cells, like
this:
table style=border-collapse:collapse; border=0 cellpadding=2
cellspacing=0 width=100%
tr
th style=border: 2px solid black; padding:5px;
class=DatatableGrayCenteredSmall
I am setting font and background color in the class as you can see from my
obtuse css naming scheme.
I also was able to get a watermark on my pdf in this way:
body{
background-image:url(/images/draftlandscape.jpg);
}
Anyway, best of luck. If you get to be an expert at all these tricks you
too can present at CFUnited. ;)
cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 2:22 PM -0700
wrote:
I'm getting closer to what I want with a table layout. One thing I can't
seem to get so far is a solid background behind table headers.
border-collapse works in a browser but isn't supported by the cfdocument.
Setting border-spacing, padding and margin all to 0 doesn't seem to do it
either.
~|
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:323679
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: css and cfdocument...grrr
Ah, I had forgotten about border=0 on the table tag. I was setting border
properties and such via css on the table cells but had forgotten about the
old school table html tag options. Show's how much table layout I'm doing
these days. Your suggestion seems to be solving my problem. And by solid
background color, I meant setting a bgcolor on the cells in a row (or the
row itself) and that was being interrupted by spaces of white because of the
cellspacing default on the table tag.
Thanks,
Judah
On Thu, Jun 18, 2009 at 2:49 PM, Randi Knutson rknut...@otan.us wrote:
Solid background behind table headers?.must be the pm slump because I
can't think what you mean, but maybe the stuff below will help.
I am using border-collapse and setting borders on all my table cells, like
this:
table style=border-collapse:collapse; border=0 cellpadding=2
cellspacing=0 width=100%
tr
th style=border: 2px solid black; padding:5px;
class=DatatableGrayCenteredSmall
I am setting font and background color in the class as you can see from my
obtuse css naming scheme.
I also was able to get a watermark on my pdf in this way:
body{
background-image:url(/images/draftlandscape.jpg);
}
Anyway, best of luck. If you get to be an expert at all these tricks you
too can present at CFUnited. ;)
cf-talk@houseoffusion.com on Thursday, June 18, 2009 at 2:22 PM -0700
wrote:
I'm getting closer to what I want with a table layout. One thing I can't
seem to get so far is a solid background behind table headers.
border-collapse works in a browser but isn't supported by the cfdocument.
Setting border-spacing, padding and margin all to 0 doesn't seem to do it
either.
~|
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:323680
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ajaxCFC Access Denied
Hello Brad,
To your questions:
The server uses MySQL. I wish I can use SQL Server. Here is the PROC.
DELIMITER $$
DROP PROCEDURE IF EXISTS `afmcorporate`.`sp_updateBasePKG` $$
CREATE definer=`afmcorpora...@`%` PROCEDURE `sp_updateBasePKG`(
IN in_table VARCHAR(128),
IN in_columnVARCHAR(128),
IN in_new_value VARCHAR(1000),
IN in_where VARCHAR(4000))
OUT results VARCHAR(3000))
BEGIN
DECLARE l_sql VARCHAR(4000);
SET l_sql=CONCAT_ws(' ',
'UPDATE',in_table,
'SET',in_column,'=',in_new_value,
'WHERE',in_where);
select l_sql as results;
set results = l_sql;
SET @sql=l_sql;
PREPARE s1 FROM @sql;
EXECUTE s1;
DEALLOCATE PREPARE s1;
END $$
DELIMITER ;
This is not a webservice, and even if it is, I donât need to have the output
result. I was using it as a way to check my SQL.
There will no be a way for hackers to do any SQL injections because the way
this work is that users type something on a text box and that will be used as
the value to be inserted on the DB e.g.
âUpdate â + âfrom table that they can not typeâ +
âSET â + âthis field that they can not type neitherâ +
â = â + âvalue entered by userâ +
âWHERE â + âfrom this field that they can not type neitherâ + â=â +
âfrom this field that they can not type neitherâ
I am sending all the necessary values for the table, fields, except for the
value that will be updated.
So, I donât see any harm there, but if you see something let me know.
Finally I did fail to mention last time; the CFfunction is the one crashing..
It doesnât get to SP yet.
I commented the OUT cfprocparam because it was complaining there, after I
commented out that parameter, it started complaining about the one above.
Any thoughts?
Thanks
~|
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:323681
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Converted Application.cfm to Application.cfc and Having Problems
Are you using the per-app settings right? The docs are a little wonky. I have a writeup on blog of fusion but the basics are below http://www.blogoffusion.com/032508-coldfusion-8-per-app-settings--mappings.cfm This is what the docs say cfset this.mappings[MyMap]=c:\inetpub\myStuff This is what is needed cfset this.mappings[/MyMap]=c:\inetpub\myStuff Note the slash in the beginning of the mapping. Or it may be something else. :) On Thu, Jun 18, 2009 at 3:29 PM, Dawson, Michael m...@evansville.edu wrote: I have a server with several web sites on it. One site was built with legacy code and the old Application.cfm file. Because of that, I had some mappings and custom tag paths set up in the CF administrator for the entire server. I ran into some conflicts with a new site I'm building. I found that, even though I was using per-app mappings/paths on the new site, it was still using the global CF mappings/paths. So, this afternoon, I converted the Application.cfm file to Application.cfc. The code doesn't do much other than set a session variable with the result from a CF component. The first thing I noticed was that each page request took several seconds to respond. Before, with the Application.cfm file, each page came back in sub-second times. The second thing I noticed was that the main custom tag, used for the header/footer, cannot be found some of the time. I don't think it is a configuration issue because it works sometimes, too. This is the error I get: Cannot find CFML template for custom tag renderpage. I restarted the CF service and deleted all of the files in WEB-INF/cfclasses, but nothing has helped the situation. The only thing I can think of is that I have a per-app custom tag path that points to the root of the web site as well as a per-app custom tag path that points directly to the directory that contains the custom tags. (For now, the custom tag path that point to the root of the site is necessary to find the components until I can change all references to all of the components.) I also removed the global mappings and custom tag paths that were used for this site. Any help would be greatly appreciated. Michael Dawson Manager of Web Applications Office of Technology Services University of Evansville Each time you send an email message with a background pattern or loud background color, an endangered tree dies. Please help us save a tree. Just say NO to email backgrounds. ~| 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:323682 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Exporting to csv. Every other row is empty.
You've got: cfoutput query=qMembers [content] /cfoutput Which is: cfoutput query=qMembersNEWLINE[content]NEWLINE/cfoutput Hence why you're getting empty lines. You need your content to start on the same line as the opening cfoutput, or end the tag on the same line as the content. ~| 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:323683 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: ajaxCFC Access Denied
Hmmm, can you confirm for certain if the error is happening before or after the proc gets called? Can you provide us with a stack trace of where the error happened? Also, is this the null pointer error or are you still having that permissions denied one you started the thread with? As far as the SQLi, you know your app best so we'll let you decide what is safe. I guess I would ask myself two main questions: 1) Where are the table, column, and where clause inputs originating from? The client, or the server? Also, is there any way that cookie, form, url, or cgi variables could affect them? 2) What happens when you user enters a string with a single quote in it or an escaped quote? SQL concatenation can be dangerous if not cleaned properly. Since you are on MySQL, here some semi-random articles you might find interesting: http://www.codersrevolution.com/index.cfm/2008/7/13/Just-when-you-felt-safe-SQL-Injection-and-MySQL http://www.codersrevolution.com/index.cfm/2008/8/17/Disabling-MySQLs-Backslash-Escaping-Per-Data-Source ~Brad Original Message Subject: Re: ajaxCFC Access Denied From: David Torres djt...@yahoo.com Date: Thu, June 18, 2009 5:03 pm To: cf-talk cf-talk@houseoffusion.com Hello Brad, To your questions: The server uses MySQL. I wish I can use SQL Server. Here is the PROC. DELIMITER $$ This is not a webservice, and even if it is, I donât need to have the output result. I was using it as a way to check my SQL. There will no be a way for hackers to do any SQL injections because the way this work is that users type something on a text box and that will be used as the value to be inserted on the DB e.g. Finally I did fail to mention last time; the CFfunction is the one crashing.. It doesnât get to SP yet. I commented the OUT cfprocparam because it was complaining there, after I commented out that parameter, it started complaining about the one above. ~| 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:323684 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Full screen?
On Wed, Jun 17, 2009 at 10:54 PM, D Hulu movie has a full screen option, I'm wondering if we could also easily implement that for a cf web app? Has anyone done something like that? Note, Flash Full Screen mode does NOT allow you to work on another monitor while it's in full screen mode. You are better off with a full screen pop up window... a href=http://www.houseoffusion.com/; onclick=window.open(this.href, 'child', 'height=' + screen.height + ',width=' + screen.width + ',fullscreen'); return falseHOF/a ~ Casey Thanks for the tip of screen.height screen.width. Don ~| 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:323685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Converted Application.cfm to Application.cfc and Having Problems
Yes, the per-app setting is enabled and I have specified my mappings and custom tag paths in the application.cfc file. The weird thing is that it works the majority of the time, but, man, the performance certainly sucks, not to mention the intermittent I can't find the custom tag errors. I would prefer if it would have just borked every time. At least I would have something to start with. ;-) Tomorrow, I'm going in with a fresh mind and I will strip everything down to the minimum until I find the problem. I just with Adobe would not have used custom tag paths to locate components. mike _ From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Thu 6/18/2009 5:34 PM To: cf-talk Subject: Re: Converted Application.cfm to Application.cfc and Having Problems Are you using the per-app settings right? The docs are a little wonky. I have a writeup on blog of fusion but the basics are below http://www.blogoffusion.com/032508-coldfusion-8-per-app-settings--mappings.cfm This is what the docs say cfset this.mappings[MyMap]=c:\inetpub\myStuff This is what is needed cfset this.mappings[/MyMap]=c:\inetpub\myStuff Note the slash in the beginning of the mapping. Or it may be something else. :) ~| 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:323686 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Converted Application.cfm to Application.cfc and Having Problems
Maybe those per app settings are being overwritten in some other part of the app. On Thu, Jun 18, 2009 at 10:23 PM, Dawson, Michael m...@evansville.eduwrote: Yes, the per-app setting is enabled and I have specified my mappings and custom tag paths in the application.cfc file. The weird thing is that it works the majority of the time, but, man, the performance certainly sucks, not to mention the intermittent I can't find the custom tag errors. I would prefer if it would have just borked every time. At least I would have something to start with. ;-) Tomorrow, I'm going in with a fresh mind and I will strip everything down to the minimum until I find the problem. I just with Adobe would not have used custom tag paths to locate components. mike _ From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Thu 6/18/2009 5:34 PM To: cf-talk Subject: Re: Converted Application.cfm to Application.cfc and Having Problems Are you using the per-app settings right? The docs are a little wonky. I have a writeup on blog of fusion but the basics are below http://www.blogoffusion.com/032508-coldfusion-8-per-app-settings--mappings.cfm This is what the docs say cfset this.mappings[MyMap]=c:\inetpub\myStuff This is what is needed cfset this.mappings[/MyMap]=c:\inetpub\myStuff Note the slash in the beginning of the mapping. Or it may be something else. :) ~| 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:323687 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
