[cfaussie] CRM Integration
I'm looking for ideas on solid stable CRM's to integrate with a coldfusion app... needs to be enterprise level, can be any platform and any language with API. Any Ideas? Dawesi -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] CRM Integration
SugarCRM is probably the best I have seen. http://www.sugarcrm.com/crm/ Regards, Andrew Scott -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Dawesi Sent: Tuesday, 13 July 2010 4:48 PM To: cfaussie Subject: [cfaussie] CRM Integration I'm looking for ideas on solid stable CRM's to integrate with a coldfusion app... needs to be enterprise level, can be any platform and any language with API. Any Ideas? Dawesi -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel)
Hi Melbourne CFers (and visitors)! Who can make it Thursday night? PLEASE RSVP so that we can cater. The previously-posted details repeated below Mark's presentation will focus on taking Object Oriented Programming from theory to practice, providing a clear path to the implementation details for ColdFusion Developers. Mark Mandel is a full time consultant and lead developer on several open source projects, most notably Transfer ORM, ColdSpring, JavaLoader and ColdDoc and has been has been working with ColdFusion for a number of years, including at his very own dot com back in the late 90's. Mark can often be found blogging at www.compoundtheory.com, which has housed his thoughts on ColdFusion, Java and various aspects of software development for several years. He can also be found as a regular poster on ColdFusion mailing lists as well as generally causing havoc in the #coldfusion channel on Dalnet irc network. When he's not too busy writing open source software and consulting he enjoys spending his extra time training martial arts in a wide variety of disciplines and reading way too much fantasy literature. Date: Thursday 15 July 2010 Time: 6:30 PM Location: CogState Level 2 255 Bourke Street Melbourne, VIC, 3000 A note on the door will provide a number to ring for access. RSVP: Please reply to this post if you are planning to attend so we know how many pizzas to order. As always, many thanks to Dale Fraser and CogState for their hospitality. We look forward to seeing you all there. Peter Robertson Co-Manager Melbourne CFUG Steve Onnis Manager Melbourne CFUG -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel)
If you're lucky, I may be there ;o) Mark On Tue, Jul 13, 2010 at 9:13 PM, Peter Robertson pe...@p-robertson.comwrote: Hi Melbourne CFers (and visitors)! Who can make it Thursday night? PLEASE RSVP so that we can cater. The previously-posted details repeated below Mark's presentation will focus on taking Object Oriented Programming from theory to practice, providing a clear path to the implementation details for ColdFusion Developers. Mark Mandel is a full time consultant and lead developer on several open source projects, most notably Transfer ORM, ColdSpring, JavaLoader and ColdDoc and has been has been working with ColdFusion for a number of years, including at his very own dot com back in the late 90's. Mark can often be found blogging at www.compoundtheory.com, which has housed his thoughts on ColdFusion, Java and various aspects of software development for several years. He can also be found as a regular poster on ColdFusion mailing lists as well as generally causing havoc in the #coldfusion channel on Dalnet irc network. When he's not too busy writing open source software and consulting he enjoys spending his extra time training martial arts in a wide variety of disciplines and reading way too much fantasy literature. Date: Thursday 15 July 2010 Time: 6:30 PM Location: CogState Level 2 255 Bourke Street Melbourne, VIC, 3000 A note on the door will provide a number to ring for access. RSVP: Please reply to this post if you are planning to attend so we know how many pizzas to order. As always, many thanks to Dale Fraser and CogState for their hospitality. We look forward to seeing you all there. Peter Robertson Co-Manager Melbourne CFUG Steve Onnis Manager Melbourne CFUG -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel)
You'd better! On 13 July 2010 21:19, Mark Mandel mark.man...@gmail.com wrote: If you're lucky, I may be there ;o) Mark On Tue, Jul 13, 2010 at 9:13 PM, Peter Robertson pe...@p-robertson.com wrote: Hi Melbourne CFers (and visitors)! Who can make it Thursday night? PLEASE RSVP so that we can cater. The previously-posted details repeated below Mark's presentation will focus on taking Object Oriented Programming from theory to practice, providing a clear path to the implementation details for ColdFusion Developers. Mark Mandel is a full time consultant and lead developer on several open source projects, most notably Transfer ORM, ColdSpring, JavaLoader and ColdDoc and has been has been working with ColdFusion for a number of years, including at his very own dot com back in the late 90's. Mark can often be found blogging at www.compoundtheory.com, which has housed his thoughts on ColdFusion, Java and various aspects of software development for several years. He can also be found as a regular poster on ColdFusion mailing lists as well as generally causing havoc in the #coldfusion channel on Dalnet irc network. When he's not too busy writing open source software and consulting he enjoys spending his extra time training martial arts in a wide variety of disciplines and reading way too much fantasy literature. Date: Thursday 15 July 2010 Time: 6:30 PM Location: CogState Level 2 255 Bourke Street Melbourne, VIC, 3000 A note on the door will provide a number to ring for access. RSVP: Please reply to this post if you are planning to attend so we know how many pizzas to order. As always, many thanks to Dale Fraser and CogState for their hospitality. We look forward to seeing you all there. Peter Robertson Co-Manager Melbourne CFUG Steve Onnis Manager Melbourne CFUG -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel)
I'll hopefully be there to let you 2 in, so should be the 3 of us. Regards Dale Fraser http://dale.fraser.id.au http://cfmldocs.com http://learncf.com http://flexcf.com -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Peter Robertson Sent: Tuesday, 13 July 2010 9:26 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel) You'd better! On 13 July 2010 21:19, Mark Mandel mark.man...@gmail.com wrote: If you're lucky, I may be there ;o) Mark On Tue, Jul 13, 2010 at 9:13 PM, Peter Robertson pe...@p-robertson.com wrote: Hi Melbourne CFers (and visitors)! Who can make it Thursday night? PLEASE RSVP so that we can cater. The previously-posted details repeated below Mark's presentation will focus on taking Object Oriented Programming from theory to practice, providing a clear path to the implementation details for ColdFusion Developers. Mark Mandel is a full time consultant and lead developer on several open source projects, most notably Transfer ORM, ColdSpring, JavaLoader and ColdDoc and has been has been working with ColdFusion for a number of years, including at his very own dot com back in the late 90's. Mark can often be found blogging at www.compoundtheory.com, which has housed his thoughts on ColdFusion, Java and various aspects of software development for several years. He can also be found as a regular poster on ColdFusion mailing lists as well as generally causing havoc in the #coldfusion channel on Dalnet irc network. When he's not too busy writing open source software and consulting he enjoys spending his extra time training martial arts in a wide variety of disciplines and reading way too much fantasy literature. Date: Thursday 15 July 2010 Time: 6:30 PM Location: CogState Level 2 255 Bourke Street Melbourne, VIC, 3000 A note on the door will provide a number to ring for access. RSVP: Please reply to this post if you are planning to attend so we know how many pizzas to order. As always, many thanks to Dale Fraser and CogState for their hospitality. We look forward to seeing you all there. Peter Robertson Co-Manager Melbourne CFUG Steve Onnis Manager Melbourne CFUG -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Filtering ORM results
I have been playing around with the ORM stuff in CF9 and i was wondering if someone can answer something for me. Can you filter associated objects without doing it through the cfproperty where clause? The online docs say you have to do it like this cfproperty name=unsoldArts cfc=Art fieldtype=one-to-many fkcolumn=ARTISTID where=issold=0 I want to be able to do it like this ORMExecuteQuery(from art where issold = 0) but because the comes back as an array it doesn't work. Anyone shed some light on this? Steve -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Filtering ORM results
Steve I'm not sure what you are asking. What exactly do you want returned? How are you attempting to get the information? What sort of domain model are you attempting to implement here? If you are looking at filtering data globally, you may want to look at Hibernate Filters: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/filters.html However, that can only be implemented through the .hbmxml files. Mark On Tue, Jul 13, 2010 at 10:23 PM, Steve Onnis st...@cfcentral.com.auwrote: I have been playing around with the ORM stuff in CF9 and i was wondering if someone can answer something for me. Can you filter associated objects without doing it through the cfproperty where clause? The online docs say you have to do it like this cfproperty name=unsoldArts cfc=Art fieldtype=one-to-many fkcolumn=ARTISTID where=issold=0 I want to be able to do it like this ORMExecuteQuery(from art where issold = 0) but because the comes back as an array it doesn't work. Anyone shed some light on this? Steve -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] CF Session Clock / Timer
Hi, Just wondering if its possible to have a session clock / timer so that my users know the remaining time left before the session expires and or when there is only x minutes left before the session times out that a popup window appears telling them their remaining time before the session closes ?? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: mailto:i...@trackingcentral.om.au i...@samaris.net Website: http://www.TrackingCentral.com.au www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] CF Session Clock / Timer
Yes, totally possible. Mix some Javascript with tracking timestamps of when users login etc, do an action etc and you're ready to go. Cheers Kai Hi, Just wondering if its possible to have a session clock / timer so that my users know the remaining time left before the session expires and or when there is only x minutes left before the session times out that a popup window appears telling them their remaining time before the session closes ?? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net Website: www.SAMARIS.net Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- Kai Koenig - Ventego Creative Ltd ph: +64 4 476 6781 - mob: +64 21 928 365 / +61 450 132 117 web: http://www.ventego-creative.co.nz blog: http://www.bloginblack.de twitter: http://www.twitter.com/agentK -- -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] CF Session Clock / Timer
Someone did an article showing at least one solution, using Javascript, back in the day (2000) in the CFDJ: http://coldfusion.sys-con.com/node/41925 A more recent article showing use of jquery is this: http://www.jensbits.com/2010/04/18/coldfusion-session-timeout-with-warning-and-session -refresh/ I'm sure there are many others. /charlie From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of rai...@ozemail.com.au Sent: Tuesday, July 13, 2010 8:48 PM To: cfaussie@googlegroups.com; coldfusion-ho...@yahoogroups.com Subject: [cfaussie] CF Session Clock / Timer Hi, Just wondering if its possible to have a session clock / timer so that my users know the remaining time left before the session expires and or when there is only x minutes left before the session times out that a popup window appears telling them their remaining time before the session closes ?? Regards Claude Raiola (B.Econ Acc; B.Hot. Mngt) Samaris Software Email: i...@samaris.net mailto:i...@trackingcentral.om.au Website: www.SAMARIS.net http://www.TrackingCentral.com.au Mobile: 0414 228 948 -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Apache, JRun and cfNTauthenticate domain issue
Hi all, We have an issue where our cfNTauthenticate tag is not working, it simply returns an empty string when trying to use it, it worked on our old windows server but not on our Linux server (running Apache). the cfNTauthenticate docs show that the 'Coldfusion J2EE server' needs to be running under the domain that you are trying to use cfNTauthenticate to authenticate against. How do I find out what domain the server is running as (or JRun / Apache whaterver)? How does one set the domain as far as JRun or Apache configuration is concerned? I can't find much JRun /Coldfusion domain related documentation. Thanks Barry Chesterman -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
RE: [cfaussie] Filtering ORM results
ok here is an example Users UserID Username UsersToAccessGroups UserID AccessGroupID AccessGroups AccessGroupID AccessGroup In the AccessGroups table there is 4 values, System Administrator, Network Administrator, Guest and Member Then i have a CFC for the User cfcomponent persistent=true table=Users entityname=User cfproperty name=UserID type=numeric column=UserID fieldtype=id generator=increment / cfproperty name=UserName type=string column=UserName fieldtype=column / cfproperty name=AccessGroupItem fieldtype=one-to-many type=array table=AccessGroups fkcolumn=UserID linktable=UsersToAccessGroups inversejoincolumn=AccessGroupID cfc=AccessGroups singularname=AccessGroup / /cfcomponent and i have a CFC for the AccessGroup cfcomponent persistent=true table=AccessGroups cfproperty name=AccessGroupID type=numeric fieldtype=id column=AccessGroupID / cfproperty name=AccessGroup type=string fieldtype=column column=AccessGroup / /cfcomponent What i want to be able to do is say get all the users that belong to a particular access group. I have tried using the ORMExecuteQuery() function to specify a WHERE clause but it doesn't like anything i put in there that has anything to do with the associated accessgroups object. I have been through the help docs that talk about using queries for getting data out of the orm 100 times (http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSf0ed2a6d7fb07688310 730d81223d0356fc-7ffe.html) and it shows that you can use the orm relationship for associated objects but i didn't have any joy with it. Steve _ From: Mark Mandel [mailto:mark.man...@gmail.com] Sent: Wednesday, 14 July 2010 7:46 AM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] Filtering ORM results Steve I'm not sure what you are asking. What exactly do you want returned? How are you attempting to get the information? What sort of domain model are you attempting to implement here? If you are looking at filtering data globally, you may want to look at Hibernate Filters: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/filters.html However, that can only be implemented through the .hbmxml files. Mark On Tue, Jul 13, 2010 at 10:23 PM, Steve Onnis st...@cfcentral.com.au wrote: I have been playing around with the ORM stuff in CF9 and i was wondering if someone can answer something for me. Can you filter associated objects without doing it through the cfproperty where clause? The online docs say you have to do it like this cfproperty name=unsoldArts cfc=Art fieldtype=one-to-many fkcolumn=ARTISTID where=issold=0 I want to be able to do it like this ORMExecuteQuery(from art where issold = 0) but because the comes back as an array it doesn't work. Anyone shed some light on this? Steve -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com mailto:cfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
Re: [cfaussie] Filtering ORM results
Okay, first of all - don't think about the ORM stuff as tables. Think about it all as Objects. It makes it much easier. Generally speaking, you don't (and in theory shouldn't) need to worry about the tables that store the data. That's up to Hibernate to manage. What it sounds like, is you are having an issue with joins in HQL. Took me a while to wrap my head around, until I realised I was thinking way too much like SQL. You have to think like objects. This is a bit pseduo code, so double check it. If you want to grab the users you want, there are few ways of doing the join: 1) from Users user where user.AccessGroupItem.AccessGroup = :name This is called an implicit join. By definition in the SQL it does an INNER JOIN 2) select user from Users user inner join user.AccessGroupItem accessgroup where accessgroup.AccessGroup = :name This is an explicit join, which you have a lot more control over. To learn more about joins, read here: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/queryhql.html#queryhql-joins As as side note - I would advocate the used of lowerCaseStartingPropertyNames, as HQL is case sensitive, and it tends to a be a widely followed convention regarding property names. Mark On Wed, Jul 14, 2010 at 11:23 AM, Steve Onnis st...@cfcentral.com.auwrote: ok here is an example *Users* UserID Username *UsersToAccessGroups* UserID AccessGroupID *AccessGroups* AccessGroupID AccessGroup In the AccessGroups table there is 4 values, *System Administrator*, *Network Administrator*, *Guest and Member* Then i have a CFC for the *User* cfcomponent persistent=true table=Users entityname=User cfproperty name=UserID type=numeric column=UserID fieldtype=id generator=increment / cfproperty name=UserName type=string column=UserName fieldtype=column / cfproperty name=AccessGroupItem fieldtype=one-to-many type=array table=AccessGroups fkcolumn=UserID linktable=UsersToAccessGroups inversejoincolumn=AccessGroupID cfc=AccessGroups singularname=AccessGroup / /cfcomponent and i have a CFC for the *AccessGroup* cfcomponent persistent=true table=AccessGroups cfproperty name=AccessGroupID type=numeric fieldtype=id column=AccessGroupID / cfproperty name=AccessGroup type=string fieldtype=column column=AccessGroup / /cfcomponent What i want to be able to do is say get all the users that belong to a particular access group. I have tried using the *ORMExecuteQuery()*function to specify a WHERE clause but it doesn't like anything i put in there that has anything to do with the associated accessgroups object. I have been through the help docs that talk about using queries for getting data out of the orm 100 times ( http://help.adobe.com/en_US/ColdFusion/9.0/Developing/WSf0ed2a6d7fb07688310730d81223d0356fc-7ffe.html) and it shows that you can use the orm relationship for associated objects but i didn't have any joy with it. Steve -- *From:* Mark Mandel [mailto:mark.man...@gmail.com] *Sent:* Wednesday, 14 July 2010 7:46 AM *To:* cfaussie@googlegroups.com *Subject:* Re: [cfaussie] Filtering ORM results Steve I'm not sure what you are asking. What exactly do you want returned? How are you attempting to get the information? What sort of domain model are you attempting to implement here? If you are looking at filtering data globally, you may want to look at Hibernate Filters: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/filters.html However, that can only be implemented through the .hbmxml files. Mark On Tue, Jul 13, 2010 at 10:23 PM, Steve Onnis st...@cfcentral.com.auwrote: I have been playing around with the ORM stuff in CF9 and i was wondering if someone can answer something for me. Can you filter associated objects without doing it through the cfproperty where clause? The online docs say you have to do it like this cfproperty name=unsoldArts cfc=Art fieldtype=one-to-many fkcolumn=ARTISTID where=issold=0 I want to be able to do it like this ORMExecuteQuery(from art where issold = 0) but because the comes back as an array it doesn't work. Anyone shed some light on this? Steve -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.comcfaussie%2bunsubscr...@googlegroups.com . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T: http://www.twitter.com/neurotic W: www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send
[cfaussie] Re: CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel)
Yep, I'll be there. On Jul 13, 10:08 pm, Dale Fraser d...@fraser.id.au wrote: I'll hopefully be there to let you 2 in, so should be the 3 of us. Regards Dale Fraser http://dale.fraser.id.auhttp://cfmldocs.comhttp://learncf.comhttp://flexcf.com -Original Message- From: cfaussie@googlegroups.com [mailto:cfaus...@googlegroups.com] On Behalf Of Peter Robertson Sent: Tuesday, 13 July 2010 9:26 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel) You'd better! On 13 July 2010 21:19, Mark Mandel mark.man...@gmail.com wrote: If you're lucky, I may be there ;o) Mark On Tue, Jul 13, 2010 at 9:13 PM, Peter Robertson pe...@p-robertson.com wrote: Hi Melbourne CFers (and visitors)! Who can make it Thursday night? PLEASE RSVP so that we can cater. The previously-posted details repeated below Mark's presentation will focus on taking Object Oriented Programming from theory to practice, providing a clear path to the implementation details for ColdFusion Developers. Mark Mandel is a full time consultant and lead developer on several open source projects, most notably Transfer ORM, ColdSpring, JavaLoader and ColdDoc and has been has been working with ColdFusion for a number of years, including at his very own dot com back in the late 90's. Mark can often be found blogging atwww.compoundtheory.com, which has housed his thoughts on ColdFusion, Java and various aspects of software development for several years. He can also be found as a regular poster on ColdFusion mailing lists as well as generally causing havoc in the #coldfusion channel on Dalnet irc network. When he's not too busy writing open source software and consulting he enjoys spending his extra time training martial arts in a wide variety of disciplines and reading way too much fantasy literature. Date: Thursday 15 July 2010 Time: 6:30 PM Location: CogState Level 2 255 Bourke Street Melbourne, VIC, 3000 A note on the door will provide a number to ring for access. RSVP: Please reply to this post if you are planning to attend so we know how many pizzas to order. As always, many thanks to Dale Fraser and CogState for their hospitality. We look forward to seeing you all there. Peter Robertson Co-Manager Melbourne CFUG Steve Onnis Manager Melbourne CFUG -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- E: mark.man...@gmail.com T:http://www.twitter.com/neurotic W:www.compoundtheory.com cf.Objective(ANZ) - Nov 18, 19 - Melbourne Australia http://www.cfobjective.com.au Hands-on ColdFusion ORM Training www.ColdFusionOrmTraining.com -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group athttp://groups.google.com/group/cfaussie?hl=en.- Hide quoted text - - Show quoted text - -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.
[cfaussie] Re: CFUG Melbourne July 2010: Who's Coming?? (OOP for ColdFusion Developers by Mark Mandel)
Hi Peter et al, I will be in attendence and more likely than not our intern, Andy will be visiting too. Gavin. On Jul 13, 9:13 pm, Peter Robertson pe...@p-robertson.com wrote: Hi Melbourne CFers (and visitors)! Who can make it Thursday night? PLEASE RSVP so that we can cater. The previously-posted details repeated below Mark's presentation will focus on taking Object Oriented Programming from theory to practice, providing a clear path to the implementation details for ColdFusion Developers. Mark Mandel is a full time consultant and lead developer on several open source projects, most notably Transfer ORM, ColdSpring, JavaLoader and ColdDoc and has been has been working with ColdFusion for a number of years, including at his very own dot com back in the late 90's. Mark can often be found blogging atwww.compoundtheory.com, which has housed his thoughts on ColdFusion, Java and various aspects of software development for several years. He can also be found as a regular poster on ColdFusion mailing lists as well as generally causing havoc in the #coldfusion channel on Dalnet irc network. When he's not too busy writing open source software and consulting he enjoys spending his extra time training martial arts in a wide variety of disciplines and reading way too much fantasy literature. Date: Thursday 15 July 2010 Time: 6:30 PM Location: CogState Level 2 255 Bourke Street Melbourne, VIC, 3000 A note on the door will provide a number to ring for access. RSVP: Please reply to this post if you are planning to attend so we know how many pizzas to order. As always, many thanks to Dale Fraser and CogState for their hospitality. We look forward to seeing you all there. Peter Robertson Co-Manager Melbourne CFUG Steve Onnis Manager Melbourne CFUG -- You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaus...@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.