RE: cfinput required=yes not generating pop-up
Check your mapping to the CFIDE directory. What happens if you browse to http://www.yourdomain.com/cfide/ Will -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED] Sent: 20 June 2008 01:38 To: CF-Talk Subject: cfinput required=yes not generating pop-up I have a cfform, with several fields that are required, like below. cfinput type=text required=yes message=Please enter your name. class=mainInput name=name Leaving the field blank and submitting the form does not raise a javascript pop-up, so the form can be submitted with fields blank. The validation javascript appears to be in the generated html, so I'm not sure what's happening. Same problem in ie and firefox. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307818 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Adobe ColdFusion to be free for Acadmeic use
On Wednesday 18 Jun 2008, Gerald Guido wrote: Hibernate into the next version of CF. This is probably good too. More like amazing. Hybernate automatically creates all the objects to abstract your database. Like a code generator. Do you know how much time this will shave off development? Umm, and ? Reactor and Transfer do this *now* and won't cost money to get. Assuming Railo/OpenBD doesn't use the same syntax - anyone from the language committee commented yet ? artist = createObject(component, com.etc).init(artists); artist = hibernate.save(artist, ArgumentCollection=form); THAT would be awesome. Agreed, and if as a bonus sending an array of those to Flex Just Worked (not like current Query) *that* would rock my world. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307819 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
On Thursday 19 Jun 2008, Charlie Griefer wrote: cfinvoke component=c21-ar-sm-homesite.components.manager_authorization method=authenticate returnVariable=manager_id email=#form.email# pw=#form.password# It's a good idea not to have your CFC depend on the exact name or a form/url/session parameter anyway. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307820 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
What would be the best way to pass variables to a CFC for processing? Rick -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 6:34 AM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! On Thursday 19 Jun 2008, Charlie Griefer wrote: cfinvoke component=c21-ar-sm-homesite.components.manager_authorization method=authenticate returnVariable=manager_id email=#form.email# pw=#form.password# It's a good idea not to have your CFC depend on the exact name or a form/url/session parameter anyway. -- ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307821 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Result in cfquery
On Thursday 19 Jun 2008, Randy Johnson - CFConcepts wrote: Would putting result=qryResults in my CFQUERY tags cause any performance hits Yes, because CF will check the result type at runtime every single request. This is almost certainly such a small hit you'll not care though. Any thoughts? If you really need to do this without a step debugger, why not just use CFFILE and CFSAVECONTENT to write the CFDUMP of the query to disk ? -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307822 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
On Friday 20 Jun 2008, Rick Faircloth wrote: What would be the best way to pass variables to a CFC for processing? cfinvoke component=c21-ar-sm-homesite.components.manager_authorization method=authenticate returnVariable=manager_id email=#form.email# pw=#form.password# :-) In a more complex OO model, you might want to look into things like form (and/or session) facades. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307823 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
Rick Faircloth wrote: What would be the best way to pass variables to a CFC for processing? Rick I think Tom mistakenly read the cfinvoke... code as being part of the CFC code. I know I did when I first looked at the code snippet. You are not accessing the form/url/session scopes inside the CFC but passing them into it through the cfinvoke call. Which is the proper way to do this. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307824 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF8 Tuning Recommendations????
On Wednesday 18 Jun 2008, D Simcik wrote: that's not done by default? The help in the CF admin is fairly clear, for instance in the general settings about 'trusted cache' and 'save class files'. With regards to the JVM, there are Java 5 and Java 6 JVM tuning guides from Sun, but I'm not sure how much I *ought* to try applying to our servers. Do you currently have a performance problem ? If not, I wouldn't expand much effort on it. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307825 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
On Friday 20 Jun 2008, Ian Skinner wrote: I think Tom mistakenly read the cfinvoke... code as being part of the CFC code. Oh no, I was pointing out it was a good thing to do anyway, even if there wasn't something up with the argument name. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307826 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Waaahhhh! Why won't my CFC work!
In a more complex OO model...facades. Oh man, Tom. You're killing me. I haven't even been able to get createObject working, yet. -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 9:38 AM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! On Friday 20 Jun 2008, Rick Faircloth wrote: What would be the best way to pass variables to a CFC for processing? cfinvoke component=c21-ar-sm-homesite.components.manager_authorization method=authenticate returnVariable=manager_id email=#form.email# pw=#form.password# :-) In a more complex OO model, you might want to look into things like form (and/or session) facades. -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307827 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
On Friday 20 Jun 2008, Rick Faircloth wrote: What would be the best way to pass variables to a CFC for processing? To go back to this question, there are several methods for passing in variables. There is no really best way, it is more a matter of personal preference. Besides the use of cfinvoke, here are some ways to do it with cfset. 1) Named arguments. Here you actually specify the argument names when you call a method cfset myQuery = someObject.getMyQuery(myFirstArgument=form.criteria, mySecondArgument=form.moreData) / 2) Unnamed arguments. Here you just put in the variables in the same order in which you specify the arguments in the function. cfset myQuery = someObject.getMyQuery(form.criteria,form.moreData) / 3) Argument collection. Here you first build up a structure that holds the arguments. Structure keys match the argument names. cfset myStruct = structNew() / cfset myStruct.myFirstArgument = form.criteria / cfset myStruct.mySecondArgument = form.moreData / cfset myQuery = someObject.getMyQuery(argumentCollection=myStruct) / -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307828 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
In theory - an alternative way to sort results
Attorneys and their egos! Sheesh! I've got a search function (standard queries) on a site that looks for keywords in a number of fields/tables to return a list of attorneys associated with that keyword. Results are sort alphabetically. But, a couple of folks with big heads are going, Hey, I do more work in that area than Bob does, and I want my name first on the list when you search for that! Oh boy - so, after some head scratching, if I count the instances of the search term (keyCOUNT) in their attorney bio, and figure out how to sort by that first, and then the last name, it should do the trick as my keyCOUNT would give me a sort of weighing formula to use. So in theory, return my original results, use ListValueCount to find the number of instances, read everything back into a new query object along with my keyCOUNT, requery and sort by keyCOUNT, lastNAME. Does that sound like an idea, or can somebody think of a better way to do this? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307829 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Waaahhhh! Why won't my CFC work!
Thanks for the info, Matt. I think I've got a handle on those methods. One thing I still haven't been able to get to work is setting up an init function for my db in a cfc. Can you explain how that work and show me an example of the code I need to put in a cfc. I tried this that someone gave me: cffunction name=init cfargument name=dsn cfset variables.dsn = arguments.dsn / cfreturn this /cffunction But that doesn't make sense to me. My dsn is set in application.cfm like so: cfset application.dsn = myDB. So why, variables.dsn above? I just don't understand what the code is doing. Why is variables.dsn being set to be the value of arguments.dsn? And what exactly does cfreturn this do? I'm just lacking in my understanding, I think, of what the CFC is providing for the calling page with this type of code. Perhaps it's time to get the CF8 version of CFWACK. (Last one I got was for CF4.5... :o) Rick -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 10:33 AM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! On Friday 20 Jun 2008, Rick Faircloth wrote: What would be the best way to pass variables to a CFC for processing? To go back to this question, there are several methods for passing in variables. There is no really best way, it is more a matter of personal preference. Besides the use of cfinvoke, here are some ways to do it with cfset. 1) Named arguments. Here you actually specify the argument names when you call a method cfset myQuery = someObject.getMyQuery(myFirstArgument=form.criteria, mySecondArgument=form.moreData) / 2) Unnamed arguments. Here you just put in the variables in the same order in which you specify the arguments in the function. cfset myQuery = someObject.getMyQuery(form.criteria,form.moreData) / 3) Argument collection. Here you first build up a structure that holds the arguments. Structure keys match the argument names. cfset myStruct = structNew() / cfset myStruct.myFirstArgument = form.criteria / cfset myStruct.mySecondArgument = form.moreData / cfset myQuery = someObject.getMyQuery(argumentCollection=myStruct) / ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307830 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Pyschich Serch
The only thing missing in the functionality is to have the suggestion highlighted so I can hit enter when it's the *last* choice available. That way I don't have to click the choice with my mouse or use an arrow key to select the option. Rick -Original Message- From: Don Seibert [mailto:[EMAIL PROTECTED] Sent: Thursday, June 19, 2008 4:06 PM To: CF-Talk Subject: Re: Pyschich Serch Thank you Brad. This is exactly what I am looking for. I have over 10,000 movie titles in my database and this would be very handy. Don Here's an example: http://tutorial364.easycfm.com/ Hello All, I have been to a number of websites that have search boxes that when you start to type into it, it starts to recognise what you are looking and makes suggestion. How would you do this in ColdFusion. Is it a built in function or is there a list that gets pre-populated. I have a database that has movie titles and that would be great for someone looking for a particular movie. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
Rick Faircloth wrote: Read inline. Thanks for the info, Matt. I think I've got a handle on those methods. One thing I still haven't been able to get to work is setting up an init function for my db in a cfc. Can you explain how that work and show me an example of the code I need to put in a cfc. I tried this that someone gave me: cffunction name=init cfargument name=dsn cfset variables.dsn = arguments.dsn / cfreturn this /cffunction But that doesn't make sense to me. My dsn is set in application.cfm like so: cfset application.dsn = myDB. So why, variables.dsn above? The 'variables' scope inside of a CFC is the private, global scope of the component. Data in this scope is accessible to any function or code inside the CFC but not by anything outside the CFC, i.e. the calling page. The 'this' scope is also global, but it is also public meaning that it can be read and modified by code outside of the CFC. Many people consider this to be poor encapelization of data and recommend against using it. They also recommended that a component should not use data that is not contained with-in it. So it is considered poor practice to have a component rely on something like the application scope. So most of us would pass the data in, often with this defacto constructor function named 'init' so that it is contained within the object and does not rely on outside data. You can have trouble with things like the application scope when you move CFC to different places in the file system so that the may not be under the 'application' has ColdFusion sees it and thus does not have access to that application scope anymore. I just don't understand what the code is doing. Why is variables.dsn being set to be the value of arguments.dsn? And what exactly does cfreturn this do? Arguments is the scope of the data passed in with the function call. By transferring it to the variables scope allows for this data to pesist for the life of the component, beyond the end of this function call. The return this returns 'this' instigated component to the calling code so that it can be stored and used later. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307832 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
On Friday 20 Jun 2008, Rick Faircloth wrote: In a more complex OO model...facades. Oh man, Tom. You're killing me. I haven't even been able to get createObject working, yet. /me points at CFCDev Run dude, *ru* ! :-) -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
On Fri, Jun 20, 2008 at 10:10 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Can you explain how that work and show me an example of the code I need to put in a cfc. I tried this that someone gave me: cffunction name=init cfargument name=dsn cfset variables.dsn = arguments.dsn / cfreturn this /cffunction But that doesn't make sense to me. My dsn is set in application.cfm like so: cfset application.dsn = myDB. So why, variables.dsn above? I just don't understand what the code is doing. Why is variables.dsn being set to be the value of arguments.dsn? And what exactly does cfreturn this do? The idea here is to keep you cfc separate from the application so it is more re-usable. It is good practice to not reference application scope (or form or session, etc.) directly in your cfc (there are always exceptions to this, as Tom mentioned a facade earlier). But in keeping it simple, this init function is receiving the dsn as an argument and putting it in the variables scope so that the cfc does not have any knowledge of the application scope. When you do cfset myNewInstance = createObject('component','myObj').init(application.dsn) / that is telling the server to create a new instance. This instance will be put in the server memory. By using cfreturn this /, the instance is returned to whatever calls it. In other words, the variable myNewInstance holds a reference to that object. If you have the basic setup working, try a cfdump on myObj. cfset myObj = createObject('component','myObj').init(application.dsn) / cfdump var=#myObj# / You'll see what looks like a structure output of all the methods defined for that object. Some folks like to also add a dump method to their cfcs. cffunction name=dump cfreturn variables / /cffunction With that, you can do this: cfdump var=#myObj.dump()# / That will show you the values that are held within the variables scope (doing this you will also see each function definition). I just got Ian's post. He explains the different scopes. I think one of the main things you'll need to grasp first is that when you create this object, it exists in memory and holds data and functions with which you can interact. Because of this, you'll want to think about what scope an object should exist within. An object that holds information specific to one user makes sense to be in session scope. But an object that can be used by many users should probably be in application scope. This is one of the advantages Object Oriented programming. Otherwise you are just creating and destroying objects for every request and may as well do it inline or with cfincluded files. Hope that helps. Keep the questions coming though. There are also many blog entries on some of these basics. Adrian Moreno's blog comes to mind first. He did a whole series. http://www.iknowkungfoo.com/blog/index.cfm/2007/8/22/Object-Oriented-Coldfusion--1--Intro-to-Objectcfc -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307834 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: In theory - an alternative way to sort results
Les, unfortunately when it comes to Egos the order that you determine is normally only roughly related to the order desired. Thus, though I like the idea of looking into a bio and determine ranking by wording, it may be more advisable to let the Attorneys (or whomever) determine their own rankings by practice area and keywords among themselves and you staying safely out of the fight. Then you can establish a ranking by subject (keywords) table: Attorney Subject Ranking You should be able to easily join and display the list by Ranking (high to low) and last name. Cheers, Bilal ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
On Friday 20 Jun 2008, Ian Skinner wrote: scope. So most of us would pass the data in, often with this defacto constructor function named 'init' so that it is contained within the In CF9 this 'init' method is now a concrete constructor that CF will invoke for you. Dunno how it'll cope with legacy code yet though... maybe it only auto runs no argument constructors... -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307836 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
Tom Chiverton wrote: In CF9 this 'init' method is now a concrete constructor that CF will invoke CF9!?! What is this product you speak of? Is this just descriptions or is there code that can be played with by us mere mortals someplace? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307837 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
On Friday 20 Jun 2008, Bilal Soylu wrote: idea of looking into a bio and determine ranking by wording, it may be more advisable to let the Attorneys (or whomever) determine their own rankings by practice area and keywords among themselves and you staying safely out Yup - it sounds like there is knowledge in these guys (and gals!) heads about who is 'best' at certain things - reach in and drag it out into your application. -- Tom Chiverton, reading 'World War Z', does it show ? 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. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307838 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
On Friday 20 Jun 2008, Ian Skinner wrote: Tom Chiverton wrote: In CF9 this 'init' method is now a concrete constructor that CF will invoke CF9!?! What is this product you speak of? Is this just descriptions or is there code that can be played with by us mere mortals someplace? Various blogs on Adobe Feeds have been reporting the CFUnited keynote news... -- Tom Chiverton This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office. Any reference to a partner in relation to Halliwells LLP means a member of Halliwells LLP. Regulated by The 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. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307839 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
WSDL2Java DuplicateFileException error
Ok, here's a nice one. One of my coworkers is running into this problem when he tries to invoke a ColdFusion web service he wrote. He didn't have any problems on our dev environment, but the test environment is puking out. Unfortunately, Dev is CF7 Ent and test is CF7 standard. Not that it SHOULD make any difference... Before I start pasting in miles of indecipherable code, I wanted to see if anyone has gotten this dreaded org.apache.axis.wsdl.toJava.DuplicateFileException error before and can help. I have Googled, and there seem to be NO results related to ColdFusion out there, and the results I did find were instances where people were creating their own WSDL which is obviously not the case here. Let me know what additional information might help figure this out-- like the names of the methods in the web service, etc. Also, I have manually deleted those stub files, cleared the template cache and restarted the server to no avail. Thanks. ~Brad Could not generate stub objects for web service invocation. Name: http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl. WSDL: http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl. org.apache.axis.wsdl.toJava.DuplicateFileException: Duplicate file name: /opt/coldfusionmx7/stubs/WS-1435972790/webservices/integrations/FNC/AppraisalPort/AppraisalPort.java. Hint: you may have mapped two namespaces with elements of the same name to the same package name. It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: WSDL2Java DuplicateFileException error
I can't remember the error I was getting, but I do remember having some web service weirdness and ended up running this to fix it: cfset application.ISIwsdl = createObject(java, coldfusion.server.ServiceFactory).XmlRpcService.refreshWebService(wsdl) / I'm not sure exactly what it does and can't remember where i got it, but it may be worth a try. I'm also not sure if I was running it before or after the web service creation. Just a shot in the dark. On Fri, Jun 20, 2008 at 11:07 AM, Brad Wood [EMAIL PROTECTED] wrote: Ok, here's a nice one. One of my coworkers is running into this problem when he tries to invoke a ColdFusion web service he wrote. He didn't have any problems on our dev environment, but the test environment is puking out. Unfortunately, Dev is CF7 Ent and test is CF7 standard. Not that it SHOULD make any difference... Before I start pasting in miles of indecipherable code, I wanted to see if anyone has gotten this dreaded org.apache.axis.wsdl.toJava.DuplicateFileException error before and can help. I have Googled, and there seem to be NO results related to ColdFusion out there, and the results I did find were instances where people were creating their own WSDL which is obviously not the case here. Let me know what additional information might help figure this out-- like the names of the methods in the web service, etc. Also, I have manually deleted those stub files, cleared the template cache and restarted the server to no avail. Thanks. ~Brad Could not generate stub objects for web service invocation. Name: http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl. WSDL: http://testtempest.nationsts.com/webservices/integrations/FNC/AppraisalPort/appraisalPort.cfc?wsdl. org.apache.axis.wsdl.toJava.DuplicateFileException: Duplicate file name: /opt/coldfusionmx7/stubs/WS-1435972790/webservices/integrations/FNC/AppraisalPort/AppraisalPort.java. Hint: you may have mapped two namespaces with elements of the same name to the same package name. It is recommended that you use a web browser to retrieve and examine the requested WSDL document for correctness. If the requested WSDL document can't be retrieved or it is dynamically generated, it is likely that the target web service has programming errors. -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: WSDL2Java DuplicateFileException error
Thanks for the reply Matt. We have actually already tried that. That code provides us with the same error that trying to call the web service does. ~Brad -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 11:14 AM To: CF-Talk Subject: Re: WSDL2Java DuplicateFileException error I can't remember the error I was getting, but I do remember having some web service weirdness and ended up running this to fix it: cfset application.ISIwsdl = createObject(java, coldfusion.server.ServiceFactory).XmlRpcService.refreshWebService(wsdl ) / I'm not sure exactly what it does and can't remember where i got it, but it may be worth a try. I'm also not sure if I was running it before or after the web service creation. Just a shot in the dark. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How can I restate this without using EVALUATE?
In a calling page: cfset theObject = CreateObject(component,dynamictest).init(James) cfset theMethodToCall = myFunction cfset theObject.myMethod = theObject[theMethodToCall] cfset myResult = theObject.myMethod(hello) cfoutput#myResult#/cfoutput Does anyone know why in CF you can't do this: cfset result = theObject[methodToCall](hello) / When you return a function, you can't then call it with arguments. Is it because functions in CF are actually separate classes? I like in javascript how you can do stuff like that. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307843 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Waaahhhh! Why won't my CFC work!
Makes sense. Thanks for the explanation, Ian! Rick -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 11:25 AM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! Rick Faircloth wrote: Read inline. Thanks for the info, Matt. I think I've got a handle on those methods. One thing I still haven't been able to get to work is setting up an init function for my db in a cfc. Can you explain how that work and show me an example of the code I need to put in a cfc. I tried this that someone gave me: cffunction name=init cfargument name=dsn cfset variables.dsn = arguments.dsn / cfreturn this /cffunction But that doesn't make sense to me. My dsn is set in application.cfm like so: cfset application.dsn = myDB. So why, variables.dsn above? The 'variables' scope inside of a CFC is the private, global scope of the component. Data in this scope is accessible to any function or code inside the CFC but not by anything outside the CFC, i.e. the calling page. The 'this' scope is also global, but it is also public meaning that it can be read and modified by code outside of the CFC. Many people consider this to be poor encapelization of data and recommend against using it. They also recommended that a component should not use data that is not contained with-in it. So it is considered poor practice to have a component rely on something like the application scope. So most of us would pass the data in, often with this defacto constructor function named 'init' so that it is contained within the object and does not rely on outside data. You can have trouble with things like the application scope when you move CFC to different places in the file system so that the may not be under the 'application' has ColdFusion sees it and thus does not have access to that application scope anymore. I just don't understand what the code is doing. Why is variables.dsn being set to be the value of arguments.dsn? And what exactly does cfreturn this do? Arguments is the scope of the data passed in with the function call. By transferring it to the variables scope allows for this data to pesist for the life of the component, beyond the end of this function call. The return this returns 'this' instigated component to the calling code so that it can be stored and used later. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307844 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Waaahhhh! Why won't my CFC work!
What is CFCDev... a conference? Book? -Original Message- From: Tom Chiverton [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 11:31 AM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! On Friday 20 Jun 2008, Rick Faircloth wrote: In a more complex OO model...facades. Oh man, Tom. You're killing me. I haven't even been able to get createObject working, yet. /me points at CFCDev Run dude, *ru* ! :-) -- Tom Chiverton ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307845 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cfquery function to do this?
Hi i have a query in coldfusion and one of the columns has a list of data: for example col1 col2 - 1 0,1,2,3 2 1,6,7 i want to run a query where i pass it a list and it returns any row that has any item in that list for example i want to run a query that says select all rows where col2 has any of the values 2,6 this would return both of the rows as the first column has the number 2 and the second column has the number 6 or another example is i want to run a query that says select all rows where col2 has any of the values 6,8,9 this would return only the second row as col2 has 6 in it i hope i am making myself clear i was wondering whether there was a way i could do this in query of queries, and if not then can anyone suggest an alternative as I cannot seem to get my head around the best and most efficient way to this thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
Thanks for the info and code, Matt. I'll try out your example and see what happens. Rick -Original Message- From: Matt Williams [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 11:32 AM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! On Fri, Jun 20, 2008 at 10:10 AM, Rick Faircloth [EMAIL PROTECTED] wrote: Can you explain how that work and show me an example of the code I need to put in a cfc. I tried this that someone gave me: cffunction name=init cfargument name=dsn cfset variables.dsn = arguments.dsn / cfreturn this /cffunction But that doesn't make sense to me. My dsn is set in application.cfm like so: cfset application.dsn = myDB. So why, variables.dsn above? I just don't understand what the code is doing. Why is variables.dsn being set to be the value of arguments.dsn? And what exactly does cfreturn this do? The idea here is to keep you cfc separate from the application so it is more re-usable. It is good practice to not reference application scope (or form or session, etc.) directly in your cfc (there are always exceptions to this, as Tom mentioned a facade earlier). But in keeping it simple, this init function is receiving the dsn as an argument and putting it in the variables scope so that the cfc does not have any knowledge of the application scope. When you do cfset myNewInstance = createObject('component','myObj').init(application.dsn) / that is telling the server to create a new instance. This instance will be put in the server memory. By using cfreturn this /, the instance is returned to whatever calls it. In other words, the variable myNewInstance holds a reference to that object. If you have the basic setup working, try a cfdump on myObj. cfset myObj = createObject('component','myObj').init(application.dsn) / cfdump var=#myObj# / You'll see what looks like a structure output of all the methods defined for that object. Some folks like to also add a dump method to their cfcs. cffunction name=dump cfreturn variables / /cffunction With that, you can do this: cfdump var=#myObj.dump()# / That will show you the values that are held within the variables scope (doing this you will also see each function definition). I just got Ian's post. He explains the different scopes. I think one of the main things you'll need to grasp first is that when you create this object, it exists in memory and holds data and functions with which you can interact. Because of this, you'll want to think about what scope an object should exist within. An object that holds information specific to one user makes sense to be in session scope. But an object that can be used by many users should probably be in application scope. This is one of the advantages Object Oriented programming. Otherwise you are just creating and destroying objects for every request and may as well do it inline or with cfincluded files. Hope that helps. Keep the questions coming though. There are also many blog entries on some of these basics. Adrian Moreno's blog comes to mind first. He did a whole series. http://www.iknowkungfoo.com/blog/index.cfm/2007/8/22/Object-Oriented-Coldfusion--1--Intro-to-Objectc fc -- Matt Williams It's the question that drives us. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307847 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Model Glue - Global variables help?
I've gotten my head around my first Model Glue app, except one thing - Global variables. I googled and googled, and used some examples, but still having no luck. Model Glue 2.0.304 - Running into an error. My goal is to set a simple DSN global variable that I can use anywhere. I've used some examples from Googling, but still can't make anything work. Coldspring.xml looks like this: bean id=AppConfiguration class=ModelGlue.Bean.CommonBeans.SimpleConfig property name=Config map entry key=DSNvalueleroy/value/entry /map /property /bean bean id=Employee class=model.Employee constructor-arg name=AppConfiguration ref bean=AppConfiguration / /constructor-arg /bean I have my controller object, which does not use an init(): cffunction name=showEmployees access=public returnType=any output=false cfargument name=event type=any / cfscript var Employee = createObject(component, model.Employee).init(); var getEmployees = Employee.getEmployees(); arguments.event.setValue(employees, getEmployees); /cfscript /cffunction I built an Employee object. The Employee object uses an init(), and simply runs a query and returns all employees. cffunction name=init access=public returntype=Employee output=no cfargument name=AppConfiguration required=true / cfset variables.config = arguments.AppConfiguration / cfreturn this / /cffunction Then here's the query: cffunction name=getEmployees access=public returnType=query output=false cfscript var getEmployees = ; var myDSN = variables.config.getConfigSetting(DSN); /cfscript cfquery name=getEmployees datasource=#myDSN# select emp_id, emp_fname, emp_lname, emp_age from tblemployees /cfquery cfreturn getEmployees / /cffunction The error is coming from this line in the controller: var Employee = createObject(component, model.Employee).init(); Error: The APPCONFIGURATION parameter to the init function is required but was not passed in. The error occurred in C:\webRoot\MG-ComplexData\controller\Controller.cfc: line 77 I'm assuming Employee.cfc is automatically init()ing when the app loads, so I shouldnt need to init() it again. I'm fuzzy... If I take the init() off the controller call like this: var Employee = createObject(component, model.Employee); Then I get this error: Element CONFIG is undefined in a Java object of type class [Ljava.lang.String;. The error occurred in C:\webRoot\MG-ComplexData\model\Employee.cfc: line 82 Thanks, Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307848 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Model Glue - Global variables help?
In your controller try: var Employee = GetModelGlue().GetBean(Employee); This will then get your Employee bean through ColdSpring. HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307849 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Deviceatlas and ColdFusion
I have API.class in JVM and java settings in cf administrator. Today I tried create java object. I used following line: cfobject class=mobi.mtld.da.Api name=API type=java action=create First, I'd just put this class in WEB-INF/classes instead of some other directory. That directory is already in the classpath. Second, your class attribute indicates that the package is mobi.mtld.da, which means you need that corresponding directory structure (WEB-INF/classes/mobi/mtld/da/Api.class). I seem to recall you had a jar file, though. If so, you can put it in WEB-INF/lib. Assuming it contains the package structure listed above, that should be all you need to do. In either case, after adding your Java file to the appropriate directory, restart CF. 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! Today jar file is in WEB-INF/lib directory. But I have one more question to you. I found java code for this llibrary, but I don't konw java. Can you translae following code to cfml for my? HashMap tree = Api.getTreeFromFile(sample/DeviceAtlas.json); HashMap prps = Api.getProperties(tree, Nokia6680...); Object prop = Api.getProperty(tree, Nokia6680..., displayWidth); sample/DeviceAtlas.json - directory, where is located device database, Nokia6680... - in this part of code I have to use HTTP_USER_AGENT cgi variable. I should use array of java.util.HashMap. But I'm not sure. Can you help me again? Thanks a lot ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307850 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Deviceatlas and ColdFusion
I have API.class in JVM and java settings in cf administrator. Today I tried create java object. I used following line: cfobject class=mobi.mtld.da.Api name=API type=java action=create First, I'd just put this class in WEB-INF/classes instead of some other directory. That directory is already in the classpath. Second, your class attribute indicates that the package is mobi.mtld.da, which means you need that corresponding directory structure (WEB-INF/classes/mobi/mtld/da/Api.class). I seem to recall you had a jar file, though. If so, you can put it in WEB-INF/lib. Assuming it contains the package structure listed above, that should be all you need to do. In either case, after adding your Java file to the appropriate directory, restart CF. 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! Today jar file is in WEB-INF/lib directory. But I have one more question to you. I found java code for this llibrary, but I don't konw java. Can you translae following code to cfml for my? HashMap tree = Api.getTreeFromFile(sample/DeviceAtlas.json); HashMap prps = Api.getProperties(tree, Nokia6680...); Object prop = Api.getProperty(tree, Nokia6680..., displayWidth); sample/DeviceAtlas.json - directory, where is located device database, Nokia6680... - in this part of code I have to use HTTP_USER_AGENT cgi variable. I should use array of java.util.HashMap. But I'm not sure. Can you help me again? Thanks a lot ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307852 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Model Glue - Global variables help?
HTH Dominic Works perfectly!! Thank you Dominic! Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery function to do this?
I had something like this once upon a time. I think I had to manipulate the data so that I had leading and trailing commas in the list in table. This was so I wouldn't get false matches, such as 6 being found in this list: 1,16,8. If you can do that, this might work. cfquery ... select col1, col2 from mytable where 1=0 cfloop list=2,6 index=i OR col2 Like '%,#i#,%' /cfloop /cfquery If you can't make sure of the leading and trailing commas (which is somewhat an ugly solution), you will have to do some looping over queries. I'll defer to someone else for how this would work because the only thing I can think of is to get all records and then loop over those results and do a ListFind for each record. And for each record you'd have to loop over the list of criteria too. On Fri, Jun 20, 2008 at 12:25 PM, Richard White [EMAIL PROTECTED] wrote: Hi i have a query in coldfusion and one of the columns has a list of data: for example col1 col2 - 1 0,1,2,3 2 1,6,7 i want to run a query where i pass it a list and it returns any row that has any item in that list for example i want to run a query that says select all rows where col2 has any of the values 2,6 this would return both of the rows as the first column has the number 2 and the second column has the number 6 or another example is i want to run a query that says select all rows where col2 has any of the values 6,8,9 this would return only the second row as col2 has 6 in it i hope i am making myself clear i was wondering whether there was a way i could do this in query of queries, and if not then can anyone suggest an alternative as I cannot seem to get my head around the best and most efficient way to this thanks richard ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307853 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery function to do this?
hi matt this is a good idea, shame about the leading and trailing commas though this would prove to be a pain, until i can find another solution i will do the loop and use the list find though thanks for your help I had something like this once upon a time. I think I had to manipulate the data so that I had leading and trailing commas in the list in table. This was so I wouldn't get false matches, such as 6 being found in this list: 1,16,8. If you can do that, this might work. cfquery ... select col1, col2 from mytable where 1=0 cfloop list=2,6 index=i OR col2 Like '%,#i#,%' /cfloop /cfquery If you can't make sure of the leading and trailing commas (which is somewhat an ugly solution), you will have to do some looping over queries. I'll defer to someone else for how this would work because the only thing I can think of is to get all records and then loop over those results and do a ListFind for each record. And for each record you'd have to loop over the list of criteria too. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307854 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
Does that sound like an idea, or can somebody think of a better way to do this? Tell them you must enter their earnings in the table so you can sort the list in order of work they do, may be they will forget about their request ;-)) Not joking, I would'n take the responsibility of such a political issue. Ask them to define themselves what the rank of every one should have, enter this rank in the table, and let to them the task to maintain this ranking system up to date. Soon, they will ask you to go back to the alphabetical list. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307855 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfquery function to do this?
is normalizing the database an option? :) On Fri, Jun 20, 2008 at 11:52 AM, Richard White [EMAIL PROTECTED] wrote: hi matt this is a good idea, shame about the leading and trailing commas though this would prove to be a pain, until i can find another solution i will do the loop and use the list find though thanks for your help I had something like this once upon a time. I think I had to manipulate the data so that I had leading and trailing commas in the list in table. This was so I wouldn't get false matches, such as 6 being found in this list: 1,16,8. If you can do that, this might work. cfquery ... select col1, col2 from mytable where 1=0 cfloop list=2,6 index=i OR col2 Like '%,#i#,%' /cfloop /cfquery If you can't make sure of the leading and trailing commas (which is somewhat an ugly solution), you will have to do some looping over queries. I'll defer to someone else for how this would work because the only thing I can think of is to get all records and then loop over those results and do a ListFind for each record. And for each record you'd have to loop over the list of criteria too. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307856 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: WSDL2Java DuplicateFileException error SOlVED
Well, we figured it out. Turns out it was because we had a component display name that was the same as the file name. I'm not sure exactly what versions this affects, but I know this: Windows CF 7.0.2 Enterprise: worked Linux CF 7.0.2 Standard: didn't work We figured it out from the comment at the bottom of this livedocs page: http://livedocs.adobe.com/coldfusion/7/htmldocs/0231.htm ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307857 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfquery function to do this?
lol, yes it would be if this was a format in the database, in fact i would need to be sacked as well :) - its something built up through coldfusion and i'm storing all the data in a query so i can run various query of query select statements to filter out various information - which is much quicker than any other method i have tried (sorry i know that is an abstract answer but this is the best way i have found). thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307858 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
Rick Faircloth wrote: What is CFCDev... a conference? Book? Web Site ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
Ian Skinner wrote: Rick Faircloth wrote: What is CFCDev... a conference? Book? Web Site Hit 'Send' to fast... Website - http://www.cfczone.org/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307860 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
determine host name on CFHTTP redirect
Ok, this goes hand in hand with the CFHTTP bug I reported a few weeks ago. http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56626 I can't figure out how to find the final location returned by the cfhttp tag when it follows a redirect. In other words, cfhttp url=http://www.foo.com; May very well return you the HTML for http://www.bar.com http://www.bar.com/ if foo.com serves up a 301 redirect with a location header pointing to bar.com. However, how can I tell that? The cfhttp struct that is returned doesn't appear to let on that it redirected me. All it returns is the final http status code of the LAST server queried. The only work-around I can think of is to tell cfhttp not to follow redirects, and follow them manually by myself, and then keep track of everything. I think there should be a hostname and or finalurl key that comes back in the cfhttp struct which tells you what you actually got. Otherwise I feel kind of like I'm buying a pig in a poke. Suggestions? Work-arounds? Enhancement Request? ~Brad ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307861 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
null pointer? need your expertise!
Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery if i output the sql for this it produces the text: select * from query where T_Site like '%,ICH,%' this is the correct statement but when i actually run the query on query then it just says the following error message: 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 have checked all the variables and they are defined: query = a query with 1032 rows and does have a column named T_Site columnName = 'T_Site' queryListArray = an array with 1 element with the contents 'ICH' in that element does anyone know what null pointer it is referring to. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
Thanks, Ian... -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 3:50 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! Ian Skinner wrote: Rick Faircloth wrote: What is CFCDev... a conference? Book? Web Site Hit 'Send' to fast... Website - http://www.cfczone.org/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307863 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: query help
no luck... I do need the group by clause, my actual query is much larger than the one posted. the problem, for example is this: for five people, paid=no, for five others, paid=yes under one parent sponsor. I am now getting a result of 10, but I need the result to be 5, only counting those people under sponsor who have paid. what am I doing wrong?? =( ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307864 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: query help
Hard to say what is going on. The following works fine for me: SELECT node.userCity,count(node.userCity) FROM core.users AS node, core.users AS parent WHERE parent.userName = node.userFirstName AND node.userCity = 'Pasadena' GROUP BY node.userCity I seem to get the correct number based on the node.userCity where clause. On Fri, Jun 20, 2008 at 4:23 PM, Jessica Kennedy [EMAIL PROTECTED] wrote: no luck... I do need the group by clause, my actual query is much larger than the one posted. the problem, for example is this: for five people, paid=no, for five others, paid=yes under one parent sponsor. I am now getting a result of 10, but I need the result to be 5, only counting those people under sponsor who have paid. what am I doing wrong?? =( ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307865 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
very basic query error???
Hi i have this very simple line of code that i am trying to run in a query of query: select * from query where T_Site like '%,1,%' but i am getting the error: Encountered T_Site. Incorrect conditional expression, Incorrect conditional expression, Lexical error at line 0, column 0. Encountered: , (44), after : % can anyone guess what i am doing wrong here thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307866 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: very basic query error???
select * from query where T_Site like '%1%' On Fri, Jun 20, 2008 at 3:28 PM, Richard White [EMAIL PROTECTED] wrote: Hi i have this very simple line of code that i am trying to run in a query of query: select * from query where T_Site like '%,1,%' but i am getting the error: Encountered T_Site. Incorrect conditional expression, Incorrect conditional expression, Lexical error at line 0, column 0. Encountered: , (44), after : % can anyone guess what i am doing wrong here thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307867 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: very basic query error???
hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307868 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion 8 install question
Our server admin has set up CF8 with 4 instances. When adding data sources I have to add them to the root cfide/administrator rather than within the instance example: http:mysite.com/:portNumber/cfide/administrator. Seems like the install might be configured incorrectly, does anyone have any experience with setting up multiple instance data sources? Do they just go in the root cfide? Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
how do i get extra debugging information about the null pointers as just saying it tried to reference a null value isnt helping me find what the issue is? thanks richard Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery if i output the sql for this it produces the text: select * from query where T_Site like '%,ICH,%' this is the correct statement but when i actually run the query on query then it just says the following error message: 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 have checked all the variables and they are defined: query = a query with 1032 rows and does have a column named T_Site columnName = 'T_Site' queryListArray = an array with 1 element with the contents 'ICH' in that element does anyone know what null pointer it is referring to. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307869 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: very basic query error???
I don't think you can have them.. Perhaps you can escape them? /,? On Fri, Jun 20, 2008 at 3:36 PM, Richard White [EMAIL PROTECTED] wrote: hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307871 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery Take those commas outa there. ?? Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307872 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion 8 install question
You need to add the data sources into each instance if you plan on actually using them. Unless you have a site using the default instance, you shouldn't need any data sources set up there. I may be wrong, but I seemed to remember if you added data sources to your base instance BEFORE creating the other instances, the data sources will copy over at the time they are created. If you are looking for a magical way to have the data sources automatically add to all instances at once, try Railo. :) -Original Message- From: John P [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 5:39 PM To: CF-Talk Subject: Coldfusion 8 install question Our server admin has set up CF8 with 4 instances. When adding data sources I have to add them to the root cfide/administrator rather than within the instance example: http:mysite.com/:portNumber/cfide/administrator. Seems like the install might be configured incorrectly, does anyone have any experience with setting up multiple instance data sources? Do they just go in the root cfide? Thanks, John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh - Original Message - From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 20, 2008 3:39 PM Subject: Re: null pointer? need your expertise! how do i get extra debugging information about the null pointers as just saying it tried to reference a null value isnt helping me find what the issue is? thanks richard Hi, i am running the following query on query: cfquery name=newQuery dbtype=query select * from query cfloop index=fl2 from=1 to=#arraylen(queryListArray)# cfif fl2 eq 1 where #columnName# like '%,#queryListArray[fl2]#,%' cfelse or #columnName# like '%,#queryListArray[fl2]#,%' /cfif /cfloop /cfquery if i output the sql for this it produces the text: select * from query where T_Site like '%,ICH,%' this is the correct statement but when i actually run the query on query then it just says the following error message: 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 have checked all the variables and they are defined: query = a query with 1032 rows and does have a column named T_Site columnName = 'T_Site' queryListArray = an array with 1 element with the contents 'ICH' in that element does anyone know what null pointer it is referring to. Thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: very basic query error???
You aren't by chance storing a comma-delimited list in a single column a database are you? :) ~Brad -Original Message- From: Phillip Vector [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 5:41 PM To: CF-Talk Subject: Re: very basic query error??? I don't think you can have them.. Perhaps you can escape them? /,? On Fri, Jun 20, 2008 at 3:36 PM, Richard White [EMAIL PROTECTED] wrote: hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307875 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: In theory - an alternative way to sort results
Not joking, I would'n take the responsibility of such a political issue. Ask them to define themselves what the rank of every one should have, Well, management at the law firm has now said I don't want those egotist controlling their rank, do a count on the search term and rank by that. (Exact quote!!!) So, there ya go, the word comes down from on high. OK, so back to my original question - do a count, read that back into a new query object, and sort from there? Or is there a better way? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307876 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
Thanks for the info, Matt. I think I've got a handle on those methods. Rick, I know you just moved up to cf8 from allaire -4, but you gotta dload model glue and give it a whirl. Follow ray's blog. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: very basic query error???
You aren't by chance storing a comma-delimited list in a single column a database are you? :) hi brad, well not in the database but this particular column in the coldfusion query at this point could have comma delimited lists. this query is something i have created out of various other queries and formats and then i am just about to use the query2excel function but am trying to run some filters on it first to get rid of some of the data would a comma delimited list in a coldfusion query object cause this error? and if so how can i get around it thanks ~Brad I don't think you can have them.. Perhaps you can escape them? /,? hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: very basic query error???
i have actually used this in other queries and it does work fine and pulls out the data as required, its just that in this one i am having problems i have managed now to get rid of the error above, its becuase it was trying to change the single quotes to double quotes. so i used the preservesinglequotes function and it gets rid of that problem i am still getting a problem regarding a null pointer though and cannot work out what it is referring to thanks I don't think you can have them.. Perhaps you can escape them? /,? hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307879 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
oh i see, thanks very much josh i will give this a go :) good find! thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307880 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: null pointer? need your expertise!
that did it! thanks again Josh, good find, i have been tearing my hair out over that all night thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: very basic query error???
josh managed to find the solution in this post: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56796 it was down to some cells in that column being null when using the like clause - i had to include where T_Site is not null and now it is working fine You aren't by chance storing a comma-delimited list in a single column a database are you? :) hi brad, well not in the database but this particular column in the coldfusion query at this point could have comma delimited lists. this query is something i have created out of various other queries and formats and then i am just about to use the query2excel function but am trying to run some filters on it first to get rid of some of the data would a comma delimited list in a coldfusion query object cause this error? and if so how can i get around it thanks ~Brad I don't think you can have them.. Perhaps you can escape them? /,? hi, i need the commas in the like clause though, how can i get these in there? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307882 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
Take those commas outa there. ?? hi will, i would actually like too, this scenario came up in a previous post i made about the best way to run a query on a particular scenario, the post is: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56792 even though this issue is now working i would appreciate it if you have any other suggestions as although it works it doesn't seem as if it is the most efficient way of doing it thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307883 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: null pointer? need your expertise!
Yeah, I think I ran across that one time and had to dig deep to find that. Query of queries is an odd beast, there are a lot of little gotchas to be dealt with. Also check out the case sensitivity issue, that got me one time too. -- Josh - Original Message - From: Richard White [EMAIL PROTECTED] To: CF-Talk cf-talk@houseoffusion.com Sent: Friday, June 20, 2008 4:42 PM Subject: Re: null pointer? need your expertise! that did it! thanks again Josh, good find, i have been tearing my hair out over that all night thanks again Richard, I found this on the CF7 livedocs comments: == Null Pointers are another name for undefined values. If this error is returned when trying to use the LIKE operator it is likely because there are NULL values in the column in question. Try the following variation: CFQUERY name=aQuery dbtype=query SELECT * FROM aQuery WHERE aField IS NOT NULL AND aField LIKE 'right_string_exp' /CFQUERY The IS NOT NULL clause causes a NULL row to be discounted before the LIKE clause is executed. = -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307884 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfinput required=yes not generating pop-up
is this issue arising on your testing server or on the live site? i have had this error occur almost everytime we have changed our hosting company or they have changed our vps over to a new server. we inform them of it and they tell us that they forget to set something on the server i know this is not the solution but just to inform you that it isnt a firefox or ie issue. also hopefully someone else can tell you, and me, what this setting is that makes this happen ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307885 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
OK, first steps to getting this to work are going well. I can run the search, set a query object, and do a CFDUMP and my expected results are there. The only problem I'm having is setting my keyCOUNT variable. cfset req.keyCOUNT = ListValueCountNoCase(results.narrative,req.srch, ) The above always returns zero, regardless of what I do. OK, results.narrative isn't really a list, but a SQL text cell. But, I figured I could treat it as a large list with spaces as delimiters. Guess not. So, what do I need to do to count the number of times req.srch appears in #results.narrative# cfset q_atty = queryNew(atty_id, first_name, last_name, keyCOUNT) cfset n = #results.recordcount# cfloop query=results startrow=1 endrow=#n# cfset req.keyCOUNT = ListValueCountNoCase(results.narrative,req.srch, ) cfset queryAddRow(q_atty) cfset querySetCell(q_atty, atty_id, results.atty_id, results.currentROW) cfset querySetCell(q_atty, first_name, results.first_name, results.currentROW) cfset querySetCell(q_atty, last_name, results.last_name, results.currentROW) cfset querySetCell(q_atty, keycount, req.keyCOUNT, results.currentROW) /cfloop ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In theory - an alternative way to sort results
OK, results.narrative isn't really a list, but a SQL text cell. Whoops - I lied. It's an nTEXT field. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307887 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: In theory - an alternative way to sort results
Les Mizzell wrote: OK, results.narrative isn't really a list, but a SQL text cell. Whoops - I lied. It's an nTEXT field. Found the problem - for some reason, n type fields won't display locally (? - ideas anyboyd - ?), but they will out on the production server. Once I moved a test file to the production server, it worked. So, now everybody gets sorted by the number of time a keyword appears in their bio first, then last/first names. Query Object to the rescue! Yeppers! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307888 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
Oh, I don't know... I'm a little leery of getting involved with a product and becoming dependent on it. I'll have a look, but... Thoughts? Rick -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 7:10 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! Thanks for the info, Matt. I think I've got a handle on those methods. Rick, I know you just moved up to cf8 from allaire -4, but you gotta dload model glue and give it a whirl. Follow ray's blog. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307889 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
you mean a product like ColdFusion? or a product like Dreamweaver or Eclipse? or a product like Subversion. Yeah, i can't imagine anyone wanting to use and become dependent on any of those products. (and yes, I know that you use all of those, and yes, I'm trying to make a point). On Fri, Jun 20, 2008 at 6:36 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Oh, I don't know... I'm a little leery of getting involved with a product and becoming dependent on it. I'll have a look, but... Thoughts? Rick -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 7:10 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! Thanks for the info, Matt. I think I've got a handle on those methods. Rick, I know you just moved up to cf8 from allaire -4, but you gotta dload model glue and give it a whirl. Follow ray's blog. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307890 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
Your point is well-taken, Charlie. And yes, I do use CF, but I need some language to program in and CF is so easy to program. However, I don't depend on any IDE for coding. I stay away from wizards, etc. I hand-code everything, except for what I borrow from others. I just like to understand my code and not get stuck if a program should become unavailable. Now, depending on a foundation program, such as CF is a little different than what I'm talking about. But no, I have never used Dreamweaver, and, after using Eclipse for a few months, I gave it up. Not because Eclipse wasn't suitable... it didn't generate any code for me...but because I couldn't get it to function with CFE, SVN, and FTP the way I wanted. It was my fault, but I just needed to put it aside for the time being to get some work done. And yes, Subversion, like Windows, is a tool I use in my work, but it doesn't do the work for me. Subversion just watches my back as I work. But the whole point about Model Glue or any other framework is that it probably does a lot of stuff I wouldn't understand, and if something went wrong, then I might not be able to fix it. Now, I'm just expressing a view from a perspective of ignorance, not having used any frameworks. That's why I said I'd take a look...I would just do it with some trepidation. I just like to avoid dependence unless it's necessary or there's a great benefit from the risk. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 9:54 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! you mean a product like ColdFusion? or a product like Dreamweaver or Eclipse? or a product like Subversion. Yeah, i can't imagine anyone wanting to use and become dependent on any of those products. (and yes, I know that you use all of those, and yes, I'm trying to make a point). On Fri, Jun 20, 2008 at 6:36 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Oh, I don't know... I'm a little leery of getting involved with a product and becoming dependent on it. I'll have a look, but... Thoughts? Rick -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 7:10 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! Thanks for the info, Matt. I think I've got a handle on those methods. Rick, I know you just moved up to cf8 from allaire -4, but you gotta dload model glue and give it a whirl. Follow ray's blog. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307891 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
On Fri, Jun 20, 2008 at 7:23 PM, Rick Faircloth [EMAIL PROTECTED] wrote: if a program should become unavailable. Now, depending on a foundation program, such as CF is a little different than what I'm talking about. if Model-Glue (or Fusebox or Mach-ii or ColdBox or... ) were to cease all development today, your existing code would still work fine, no different than if ColdFusion were to stop being produced. But no, I have never used Dreamweaver, and, after using Eclipse for a few months, I gave it up. Not because Eclipse wasn't suitable... it didn't generate any code for me...but because I couldn't get it to function with CFE, SVN, and FTP the way I wanted. It was my fault, but I just needed to put it aside for the time being to get some work done. And yes, Subversion, like Windows, is a tool I use in my work, but it doesn't do the work for me. Subversion just watches my back as I work. Ah, I thought you had gone from DW to Eclipse and back. Either way, I wasn't trying to single out a particular IDE. Just whatever IDE you were using :) A framework doesn't do your work for you either. Just like a hammer doesn't build a house... it's just a tool that you use to make your life easier. Is there a learning curve? Sure. Just like any tool, you need to invest time to learn how to use it properly. a hammer might not be the best example here... i'm fairly certain even will tomlinson can use a hammer. But you get my point. It's a consistent way of doing what you do now. You just need to learn that way. But the whole point about Model Glue or any other framework is that it probably does a lot of stuff I wouldn't understand, and if something went wrong, then I might not be able to fix it. Now, I'm just expressing a view from a perspective of ignorance, not having used any frameworks. That's why I said I'd take a look...I would just do it with some trepidation. Again, learning curve. Sure, it'll do stuff you don't understand. At first. The first time I saw Model-Glue code I was pretty overwhelmed. Not sure what you mean by if something went wrong. If something goes wrong, it throws an error (and you can output debug info to the screen), and you debug it just like any non-frameworked code. most of the frameworks have a mailing list as well. I just like to avoid dependence unless it's necessary or there's a great benefit from the risk. I still don't really view it as a dependency as much as a tool. Either way, I'm not trying to ruffle feathers or rile the non-framework crowd. I just wanted you to look at it in the proper perspective, whichever route you choose to go. -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 9:54 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! you mean a product like ColdFusion? or a product like Dreamweaver or Eclipse? or a product like Subversion. Yeah, i can't imagine anyone wanting to use and become dependent on any of those products. (and yes, I know that you use all of those, and yes, I'm trying to make a point). On Fri, Jun 20, 2008 at 6:36 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Oh, I don't know... I'm a little leery of getting involved with a product and becoming dependent on it. I'll have a look, but... Thoughts? Rick -Original Message- From: Will Tomlinson [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 7:10 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! Thanks for the info, Matt. I think I've got a handle on those methods. Rick, I know you just moved up to cf8 from allaire -4, but you gotta dload model glue and give it a whirl. Follow ray's blog. Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307892 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Waaahhhh! Why won't my CFC work!
Rick, you're showing the signs of the frustration I felt when i was starting to learn this stuff.Dont worry - it all comes clear in the end. There is a problem for the newbie into OO coldfusion in that there is a whole host of other OO languages around that are supplying concepts and terminology to this.As soon as you learn what one word means, another pops up.As soon as you think you're getting the hang of it, someone uses a new term you havent heard before, and you get all depressed because there's yet another concept to learn about. Often, there are concepts in one technology that also exist in other techologies but they have different names. Or there's these things called design patterns. (which simply means the style of structuring you code components to do the job) and when someone develops a design pattern they often invent terminology to describe the concepts behind it. But dont let it steer you off. I struggled to understand all these new terms at first, then i suddenly realised - i dont need to care about all those terms, as long as i get the basic concepts and techniques right. I can learn the terminology later.Once i got that, everything went simpler. I didnt have to know what 'encapsulation' was or what a facade was, or why the init function had to have all the values in the 'variable' scope, as long as i did it. And later on, i came to see why i needed to use the variables scope, and i came to see that i had been encapsulating my code without knowing what it meant. There are some on this list who are immensely helpful. They must surely be helping us at the cost of their own productivity. There are others, (who i wont name) who I think go out of their way to strut their own superior knowledge to impress all the others on this list - 'look how clever I am' without helping you at all.I guess you'll figure out who is in which group, pay attention to the advice of the one group and ignore the other. There are some things I suggest you just accept for now, on the understanding that you'll eventually see the wisdom. I suggest you adopt these as rules to follow, for the mean time, which will help you get things rolling, and you can decide whether to continue using them or not later on as you get your head around all the concepts: [A] encapsulate - in other words, never require a CFC to know about anything outside it. If a CFC needs to know something, pass it in as an argument to the method, or in the init method [B] Never put any display code in a CFC. Treat all your CFCs as though they are new functions in ColdFusion (which they are really) and call the method, get a result, then use the code on your calling page to format the result into display. [C] any time you catch yourself writing code you've done before, consider whether thats time to put that code into a cfc where the one bit of code can be used in both places as a cfc. [D] never put a query in your page code. Always put it into a CFC. Preferably all your queries on a table in the same CFC. (this is commonly called a gateway or a DAO cfc, but dont let the terminology bamboozle you). So if you have 5 tables in your app, you would have 5 CFCs handling database access. If you follow that procedure, you'll see the benefit when you have to make a change to your database!! [E] inside a function, ALWAYS var your variables. (Sorry, there's some jargon - I was trying to avoid using jargon).In other words, if you are using a variable inside the function called 'dateadded', then at the top of the function, the first few lines after the arguments, put something like the following: cfset var dateadded = / What that does is make sure that the value of 'dateadded' will only be available inside this function. IF there is any other variable called 'dateadded' somewhere else in your app, it wont overwrite the value of dateadded here. This keeps your cfcs thread safe. Imagine if you have 30 people all accessing a page at once. Then you could have one person's value of 'dateadded' overwrite another 'dateadded', in use by someone else somewhere else in the application.. [F] an init function looks like this: cffunction name=init access=Public returntype=componentname output=false hint=Initialises the controller cfargument name=dsn required=true type=string / cfset variables.dsn = config.getDatasource() / cfreturn this / /cffunction (dont 'var' your variables in the init() function or they wont be available elsewhere in the CFC). And when you want to use a dsn name elsewhere in this component, in other functions, you do it like this; cfquery name=qQueryname datasource=#variables.dsn# SELECT * from tablename /cfquery That way, you pass in the datasource name (also other configuration variables like passwords, usernames, local time, ) when you instantiate the CFC and any other method in the CFC can use them without needing them passed in. For now, just
page self refresh whenever database gets new input
Hi, I'm having a system that has two different consoles one for people input data, and other for people view data. One isn't connected to the other. Meaning, they work separatedly but at the same time. If there is a new input, then the new input will show on the diplay console right away, no need to hit any key nor button to refresh the page. The idea similar to MS Outlook. Whenever a new mail comes, it just shows up by itself. Or just like a stock reports with live feeding. Is there any way to do this in cold fusion ? Database is MS Access. Thanks Anthony ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307894 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
Thanks for the perspective, Charlie. Rick -Original Message- From: Charlie Griefer [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 10:47 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! On Fri, Jun 20, 2008 at 7:23 PM, Rick Faircloth [EMAIL PROTECTED] wrote: if a program should become unavailable. Now, depending on a foundation program, such as CF is a little different than what I'm talking about. if Model-Glue (or Fusebox or Mach-ii or ColdBox or... ) were to cease all development today, your existing code would still work fine, no different than if ColdFusion were to stop being produced. But no, I have never used Dreamweaver, and, after using Eclipse for a few months, I gave it up. Not because Eclipse wasn't suitable... it didn't generate any code for me...but because I couldn't get it to function with CFE, SVN, and FTP the way I wanted. It was my fault, but I just needed to put it aside for the time being to get some work done. And yes, Subversion, like Windows, is a tool I use in my work, but it doesn't do the work for me. Subversion just watches my back as I work. Ah, I thought you had gone from DW to Eclipse and back. Either way, I wasn't trying to single out a particular IDE. Just whatever IDE you were using :) A framework doesn't do your work for you either. Just like a hammer doesn't build a house... it's just a tool that you use to make your life easier. Is there a learning curve? Sure. Just like any tool, you need to invest time to learn how to use it properly. a hammer might not be the best example here... i'm fairly certain even will tomlinson can use a hammer. But you get my point. It's a consistent way of doing what you do now. You just need to learn that way. But the whole point about Model Glue or any other framework is that it probably does a lot of stuff I wouldn't understand, and if something went wrong, then I might not be able to fix it. Now, I'm just expressing a view from a perspective of ignorance, not having used any frameworks. That's why I said I'd take a look...I would just do it with some trepidation. Again, learning curve. Sure, it'll do stuff you don't understand. At first. The first time I saw Model-Glue code I was pretty overwhelmed. Not sure what you mean by if something went wrong. If something goes wrong, it throws an error (and you can output debug info to the screen), and you debug it just like any non-frameworked code. most of the frameworks have a mailing list as well. I just like to avoid dependence unless it's necessary or there's a great benefit from the risk. I still don't really view it as a dependency as much as a tool. Either way, I'm not trying to ruffle feathers or rile the non-framework crowd. I just wanted you to look at it in the proper perspective, whichever route you choose to go. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Waaahhhh! Why won't my CFC work!
Wow, Mike! Thanks for the great intro primer! I'd be happy to look at your CFC's. Perhaps they would clarify my understanding. I really just need to see an example from start to finish of a situation where there's a db, say myDatabase, see how that is initialized with the init function, see how createObject is used in relation to functions within a CFC, and how the data is output. Some of that I'm grasping. But I haven't been able to put together functioning, start-to-finish, code yet. I'm using CFC's, but so far I can only make them work with cfinvoke... I seem to understand the code more intuitively. But the idea of putting objects into memory using createObject is fascinating and I hope I can get that working. I'm having to do this on-the-fly however...trying to learn this on a current, should-have-been-done-yesterday project, so I have little time for trial and error. (A frustrating way to work and, especially, to learn!) Anyway, whatever you care to share is appreciated! And thanks again for taking the time to type up the primer! Rick -Original Message- From: Mike Kear [mailto:[EMAIL PROTECTED] Sent: Friday, June 20, 2008 10:49 PM To: CF-Talk Subject: Re: Waaa! Why won't my CFC work! Rick, you're showing the signs of the frustration I felt when i was starting to learn this stuff.Dont worry - it all comes clear in the end. There is a problem for the newbie into OO coldfusion in that there is a whole host of other OO languages around that are supplying concepts and terminology to this.As soon as you learn what one word means, another pops up.As soon as you think you're getting the hang of it, someone uses a new term you havent heard before, and you get all depressed because there's yet another concept to learn about. Often, there are concepts in one technology that also exist in other techologies but they have different names. Or there's these things called design patterns. (which simply means the style of structuring you code components to do the job) and when someone develops a design pattern they often invent terminology to describe the concepts behind it. But dont let it steer you off. I struggled to understand all these new terms at first, then i suddenly realised - i dont need to care about all those terms, as long as i get the basic concepts and techniques right. I can learn the terminology later.Once i got that, everything went simpler. I didnt have to know what 'encapsulation' was or what a facade was, or why the init function had to have all the values in the 'variable' scope, as long as i did it. And later on, i came to see why i needed to use the variables scope, and i came to see that i had been encapsulating my code without knowing what it meant. There are some on this list who are immensely helpful. They must surely be helping us at the cost of their own productivity. There are others, (who i wont name) who I think go out of their way to strut their own superior knowledge to impress all the others on this list - 'look how clever I am' without helping you at all.I guess you'll figure out who is in which group, pay attention to the advice of the one group and ignore the other. There are some things I suggest you just accept for now, on the understanding that you'll eventually see the wisdom. I suggest you adopt these as rules to follow, for the mean time, which will help you get things rolling, and you can decide whether to continue using them or not later on as you get your head around all the concepts: [A] encapsulate - in other words, never require a CFC to know about anything outside it. If a CFC needs to know something, pass it in as an argument to the method, or in the init method [B] Never put any display code in a CFC. Treat all your CFCs as though they are new functions in ColdFusion (which they are really) and call the method, get a result, then use the code on your calling page to format the result into display. [C] any time you catch yourself writing code you've done before, consider whether thats time to put that code into a cfc where the one bit of code can be used in both places as a cfc. [D] never put a query in your page code. Always put it into a CFC. Preferably all your queries on a table in the same CFC. (this is commonly called a gateway or a DAO cfc, but dont let the terminology bamboozle you). So if you have 5 tables in your app, you would have 5 CFCs handling database access. If you follow that procedure, you'll see the benefit when you have to make a change to your database!! [E] inside a function, ALWAYS var your variables. (Sorry, there's some jargon - I was trying to avoid using jargon).In other words, if you are using a variable inside the function called 'dateadded', then at the top of the function, the first few lines after the arguments, put something like the following: cfset var
Re: Waaahhhh! Why won't my CFC work!
Ok i'll write up a little treatise on CFCs in a real estate app for you - a simple one that just manages inserts, edits, deletes and queries on a table of property listings. I'll take one that i use for my client (the one i think is the same as yours) and fictionalise it a bit to protect the IP of my client. You'll see how it works, and how you can integrate it with your user interface code. Also it will mean i can share it with others if they want. (I'd blog it but i'm too lazy to maintain a blog - i dont have one. I know what they're like to keep going - i had one years ago before they were called blogs.). There's a WHOLE LOT more you can learn but i'll keep it to the basics for you and try to keep jargon out of it. Another nice thing about having a defined pattern to your code, is that you can have other stuff write a lot of the code for you.I have a little application I wrote to examine a database table, and write all the queries to add/delete/edit/read from it and produce the CFCs for me - that's too advanced for you just yet but if you see that at work, you can see one of the benefits of using patterns to your code. That's what some of these frameworks do - things lke Transfer and Reactor for example recognise when you add a field to your database table and re-write your CFCs to match. Without ever seeing that at work, I am sure you can see how that would be of benefit to you as a developer where time represents dollars. Coldspring is another tool - it knows how to instantiate your CFCs and whenever you call for a CFC, Coldspring knows what to do and just creates it for you, guaranteeing it feeds the CFC everything it needs to know. And it knows which CFCs to cache in memory and which to destroy after each use. It's a marvel! But for now lets leave all that stuff aside, with the understanding you'll want to know about that a bit down the track. I'll write some stuff tonight for you and hopefully have it for you tomorrow.It's Saturday night and i dont have anything to do. (jeez i'm OLD already!!) Man you've come a long way in a short time - from being in the ColdFusion stone age (i.e. CF4 wasn't it?) only a few months ago, now you're moving up to the cutting edge.Believe me, when i jumped into this OO pool, it revolutionised the way i write applications, and made possible - even easy - things i'd have scratched my head about in the old days, thinking that was beyond my capabilities. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Sat, Jun 21, 2008 at 2:17 PM, Rick Faircloth [EMAIL PROTECTED] wrote: Wow, Mike! Thanks for the great intro primer! I'd be happy to look at your CFC's. Perhaps they would clarify my understanding. I really just need to see an example from start to finish of a situation where there's a db, say myDatabase, see how that is initialized with the init function, see how createObject is used in relation to functions within a CFC, and how the data is output. Some of that I'm grasping. But I haven't been able to put together functioning, start-to-finish, code yet. I'm using CFC's, but so far I can only make them work with cfinvoke... I seem to understand the code more intuitively. But the idea of putting objects into memory using createObject is fascinating and I hope I can get that working. I'm having to do this on-the-fly however...trying to learn this on a current, should-have-been-done-yesterday project, so I have little time for trial and error. (A frustrating way to work and, especially, to learn!) Anyway, whatever you care to share is appreciated! And thanks again for taking the time to type up the primer! Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307897 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: page self refresh whenever database gets new input
he idea similar to MS Outlook. Whenever a new mail comes, it just shows up by itself. Or just like a stock reports with live feeding. Is there any way to do this in cold fusion ? Database is MS Access. Thanks Sounds like you just need some SQL to show the newest items first. ORDER BY someIDField DESC Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Waaahhhh! Why won't my CFC work!
Oh, I don't know... I'm a little leery of getting involved with a product and becoming dependent on it. I'll have a look, but... Thoughts? Like jQuery?? :) Will ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307899 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: very basic query error???
No, there shouldn't he any problems storing a comma delimited list-- it's just bad normalization since a list isn't an atomic value. If you are searching for 1 make sure you account for the following lists: 1,2,3 3,2,1 2,1,3 %,1,% is only work for one of those. ~Brad would a comma delimited list in a coldfusion query object cause this error? and if so how can i get around it ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:307900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4