Re: Choosing an ORM

2007-06-04 Thread Dave Hoff
Can anyone recommend an ORM that works with MySql? 

>Thanks Terrance,
>
>I've not seen Squidhead before, but if it's as good as it sounds then It
>would be perfect for me, anything to avoid writing DAO code ;-)
>
>I'll have a look at it this afternoon, but it sounds fantastic,
>
>Rob
>
>-Original Message-
>From: Ryan, Terrence [mailto:[EMAIL PROTECTED] 
>Sent: 04 June 2007 14:32
>To: CF-Talk
>Subject: RE: Choosing an ORM
>
>I'm not going to jump in to Reactor vs Transfer.  They're both great
>products.  I wish I could use them. (We have a mandate for stored procs. )  
>
>But if you're looking to handle stored procedures, may I make a plug for my
>product, Squidhead (http://squidhead.riaforge.org/).
>
>It doesn't have hooks for any of the other frameworks yet, but it does
>implement the DAO and Gateway for a MSSQL database using stored procedures.
>And while it doesn't have any hooks for the frameworks, there's nothing to
>stop it from working with modelglue, or fusebox. 
>
>In addition to writing its own CRUD in stored procs, it also reads in and
>makes available your stored procedures as CFC methods. It can handle
>multiple queries proc call, etc.
>
>
>   
>
>Terrence Ryan
>Senior Systems Programmer
>Wharton Computing and Information Technology   
>E-mail: [EMAIL PROTECTED]
>
>
>-Original Message-
>From: Robert Rawlins - Think Blue
>[mailto:[EMAIL PROTECTED] 
>Sent: Monday, June 04, 2007 4:06 AM
>To: CF-Talk
>Subject: Choosing an ORM
>
>Hello Guys,
>
> 
>
>I've just started work on a large scale rebuild of my core business
>application, and to aid me the gruelling task I'm toying with implementing
>MG, ColdSpring and one of the ORM's. I've done some small work with these in
>the past but used Reactor. Now, I'm sure I've read somewhere that Reactor
>and MG got a divorce, and that MG would most likely end up sleeping with
>Transfer, is this the case?
>
> 
>
>Another thing to take into consideration is that I had planned to take all
>my queries and move them into stored procs on my SQL Server as some of them
>were getting pretty fat and needed a helping hand to keep performance where
>I want it, will I still be able to do this when working with an ORM?
>
> 
>
>What are your thoughts on this stuff? What's hot? And what's not?
>
> 
>
>Look forward to hearing from you guys,
>
> 
>
>Rob

~|
CF 8 – Scorpio beta now available, 
easily build great internet experiences – Try it now on Labs
http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280003
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Event Gateway - Stall Processing

2007-02-02 Thread Dave Hoff
I'm writing an application using the CF xmpp gateway. I need to somehow "stall" 
processing. I send an IM message to a users IM client and need to send another 
say 3 seconds after. I just need to stall processing in the cfc for 3 seconds 
or so. Without a pause I'm worried the first message will not be viewed, since 
the second is sent almost instantaneously. Any ideas?

~|
Upgrade to Adobe ColdFusion MX7 
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs 
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:268452
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Find last file.

2006-10-19 Thread Dave Hoff
Try this function on cflib:

FileDateLastModified: http://www.cflib.org/udf.cfm?ID=126

windows only

On 10/19/06, Ben Koshy <[EMAIL PROTECTED]> wrote:
>
> Problem with that method is that it'll do a String Sort... and unless he's
> diligent about padding with enough zeroes... it could sort things oddly
> such
> as
>
> file01
> ..
> ..
> ..
> file10
> file100
> file101
> file11
> file12
>
> A date sort might work but if he modifies the file ...the dates will be
> changed as it goes by the modify date and not the creation date.  If the
> app
> doesn't touch them after creation he'll be ok.
>
> - Original Message -
> From: "Teddy Payne" <[EMAIL PROTECTED]>
> To: "CF-Talk" 
> Sent: Thursday, October 19, 2006 9:57 PM
> Subject: Re: Find last file.
>
>
> > Ian,
> > You can use cfdirectory to query a folder.  Then use cfquery to perform
> a
> > query of a query of the cfdirectory name and then sort based upon the
> file
> > name in desc order.
> >
> > Teddy
> >
> > On 10/19/06, Ian Skinner <[EMAIL PROTECTED]> wrote:
> >>
> >> I have an app that writes out a file that is named with consecutive
> >> numbers, i.e. file01, file02, file04.  The numbers are actually based
> on
> >> the date the file is written.  What I'm looking for is an easy way to
> >> find
> >> the last file written, the one with the highest integer appended to the
> >> file
> >> name.
> >>
> >> Can anybody help my muddled mind?
> >>
> >> TIA
> >>
> >>
> >> --
> >> Ian Skinner
> >> Web Programmer
> >> BloodSource
> >> www.BloodSource.org
> >> Sacramento, CA
> >>
> >> -
> >> | 1 |   |
> >> -  Binary Soduko
> >> |   |   |
> >> -
> >>
> >> "C code. C code run. Run code run. Please!"
> >> - Cynthia Dunning
> >>
> >> Confidentiality Notice:  This message including any
> >> attachments is for the sole use of the intended
> >> recipient(s) and may contain confidential and privileged
> >> information. Any unauthorized review, use, disclosure or
> >> distribution is prohibited. If you are not the
> >> intended recipient, please contact the sender and
> >> delete any copies of this message.
> >>
> >>
> >>
> >>
> >
> >
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257401
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Email Routing and Management

2006-10-19 Thread Dave Hoff
Check out Sproutit Mailroom

http://www.sproutit.com

On 10/19/06, Tom Chiverton <[EMAIL PROTECTED]> wrote:
>
> On Wednesday 18 October 2006 19:49, Mehdi, Agha wrote:
> > I need some recommendations for Customer Support Email routing and
> > management tools with built-in workflow.
>
> Have you seen Jira or Trac ?
>
> --
> Tom Chiverton
> Helping to carefully engage internet patterns
>
> 
>
> This email is sent for and on behalf of Halliwells LLP.
>
> Halliwells LLP is a limited liability partnership registered in England
> and Wales under registered number OC307980 whose registered office address
> is at St James's Court Brown Street Manchester M2 2JF.  A list of members is
> available for inspection at the registered office. Any reference to a
> partner in relation to Halliwells LLP means a member of Halliwells LLP.
> Regulated by the Law Society.
>
> CONFIDENTIALITY
>
> This email is intended only for the use of the addressee named above and
> may be confidential or legally privileged.  If you are not the addressee you
> must not read it and must not use any information contained in nor copy it
> nor inform any person other than Halliwells LLP or the addressee of its
> existence or contents.  If you have received this email in error please
> delete it and notify Halliwells LLP IT Department on 0870 365 8008.
>
> For more information about Halliwells LLP visit www.halliwells.com.
>
>
> 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257348
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Strange URL pointing to CFM page

2006-10-18 Thread Dave Hoff
> All,
> 
> I've never seen this type of hyperlink before.  It resolves to a cfm 
> page.
> 
> Is it pointing to a directory or a file?
> 
> http://www.domainname.
> com/coupons?subscriberemail=Y29sZGZ1c2lvbi5kZXZlbG9wZXJAYXR0Lm5ldA==

It is possible to have IIS forward all 404 not found pages to a specified cfm 
page where you can parse the url and do with it what you wish. I've used this 
technique to produce rails style urls. 

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257221
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4


Re: Dynamically creating and assigning session variables

2006-10-16 Thread Dave Hoff
Updated: Fixed!!

Thanks Rob, assigning the vars using: session['M' & i] did the trick.

> I'm sure this isn't best practice, but I'm working with the "menu" 
> event gateway example that ships with CF7 and I'm trying to generate 
> the menu from a database replacing the hard-coded menu that is there. 
> The menu is stored in a session variable and I need to dynamically 
> assign the session name and its value. 
> 
> -
> childVar = "session.M" & i & "_" & j;
> tempVar = "session.M" & i;
> 
> #childVar# = #tempVar#.addChild(name="#childName#", key="#j#", 
> cfc="#childCFC#", method="#childMethod#");
> -
> 
> It looks like #childVar# works, but when I assign it to #tempVar#.
> addChild CF throws an error.
> 
> Any suggestions on how I might make this 
work?

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256922
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Re: Dynamically creating and assigning session variables

2006-10-16 Thread Dave Hoff
Thanks Rob. I'll try and paste the entire code below. 

for(i=1; i LTE getTopLevel.recordset.recordcount; i=i+1)
{
tempName = getTopLevel.recordset.name[i];
tempCFC = "gateway.imified.apps." & getTopLevel.recordset.cfc_name[i];
tempMethod = getTopLevel.recordset.entry_method[i];
tempService = getTopLevel.recordset.Id[i];
tempVar = "session.M" & i;


if(getTopLevel.recordset.cfc_name NEQ "") 
  #tempVar# = session.root.addChild(name="#tempName#", key="#i#");
else
  #tempVar# = session.root.addChild(name="#tempName#", key="#i#", 
cfc="gateway.imified.apps.#tempCFC#", method="#tempMethod#");

// Get children
SQLString = "select * from methods where service_id = " & tempService & " order 
by sort_order asc";
DATASOURCE = request.dsn;
getChildren = query(sql=SQLString, datasource=DATASOURCE);

for(j=1; j LTE getChildren.recordset.recordcount; j=j+1)
{
childName = getChildren.recordset.method_name[i];
childCFC = "gateway.imified.apps." & getChildren.recordset.cfc_name[i];
childMethod = getChildren.recordset.entry_method[i];
childVar = "session.m" & i & "_" & j;

#childVar# = #tempVar#.addChild(name="#childName#", key="#j#", 
cfc="#childCFC#", method="#childMethod#");
}
}
-

CF throws the following error:
Invalid CFML construct found on line 122 at column 95. ColdFusion was looking 
at the following text:.The CFML compiler was processing:a 
script statement beginning with ""#"" on line 122, column 73.

Looks like it has a problem with:
#childVar# = #tempVar#.addChild(name="#childName#", key="#j#", 
cfc="#childCFC#", method="#childMethod#"); 

Temp var is causing the trouble. Does the code above (as messy as it is) look 
like it should work?

Thanks.

>On 10/16/06, Dave Hoff <[EMAIL PROTECTED]> wrote:
>
>What error is thrown?  For readability (and maybe functionality), try:
>
>childVar = session['M' & i & '_' & j];
>tempVar = session['M' & i];
>
>Or, just do it all at once:
>
>session['M' & i & '_' & j] = session['M' & i].addChild ( ... );

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256921
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4


Dynamically creating and assigning session variables

2006-10-16 Thread Dave Hoff
I'm sure this isn't best practice, but I'm working with the "menu" event 
gateway example that ships with CF7 and I'm trying to generate the menu from a 
database replacing the hard-coded menu that is there. The menu is stored in a 
session variable and I need to dynamically assign the session name and its 
value. 

-
childVar = "session.M" & i & "_" & j;
tempVar = "session.M" & i;

#childVar# = #tempVar#.addChild(name="#childName#", key="#j#", 
cfc="#childCFC#", method="#childMethod#");
-

It looks like #childVar# works, but when I assign it to #tempVar#.addChild CF 
throws an error.

Any suggestions on how I might make this work?

~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four 
times a year.
http://www.fusionauthority.com/quarterly

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:256916
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4