Trapping entityDelete() errors

2010-12-22 Thread Ryan Heldt
Working with ColdFusion 9 ORM, is there a way to trap entityDelete() errors when there's a constraint violation. I have my delete setup like so: try { entityDelete(local.objSongCategory); // report success } catch (Any e) { transaction action="rollback"; // report fai

RE: Cfoutput query backwards

2007-11-15 Thread Ryan Heldt
Ben Nadel has a queryToArray function. I suppose you could convert the query to an array then call up each "row" in reverse order a little eaiser, although I haven't tried it myself. http://www.bennadel.com/snippets/24-QueryToArray-qRecordSet-.htm Or, you could add a 'DESC' to the end of your SQL

RE: sms

2007-11-14 Thread Ryan Heldt
Don't know if this was mentioned before. Might be helpful: http://www.bennadel.com/index.cfm?dax=blog:692.view Ryan > -Original Message- > From: Graham Pearson [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 14, 2007 6:02 AM > To: CF-Talk > Subject: Re: sms > > -BEGIN PGP SIGN

RE: Image Management

2007-11-07 Thread Ryan Heldt
om finding out. Also makes writing a cleanup script much eaiser. Just a thought. Ryan Heldt > -Original Message- > From: Claude Schneegans [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 07, 2007 7:54 AM > To: CF-Talk > Subject: Re: Image Management > > >>My

RE: MX 6.1 and Sending SMS Messages

2007-11-02 Thread Ryan Heldt
Don't know if this was mentioned, but Ben Nadel offered a way of doing this using cfmail a while back. Might be a little easier than wrestling with a bunch of Java classes: http://www.bennadel.com/index.cfm?dax=blog:692.view Ryan > -Original Message- > From: Dave Phillips [mailto:[EMAIL

RE: Creating an Audit Trail

2007-10-31 Thread Ryan Heldt
Our apps have what we call session messages. Usually they're messsages returned to the user after performing an operation (stored in session). This might be something like "The user 'Heldt, Ryan' has been created." or "The product 'Kitchen Sink' has been deleted." Almost every action generates a me

RE: Copying a CFC Persisted in Session Scope

2007-10-29 Thread Ryan Heldt
That is, in fact, what I am doing. I have a AuthenticatedUser CFC that contains all of the information about the user that is signed in. Now, for example, say I want to run a query that gets all of the timebills for that user, I would "SELECT foo FROM bar WHERE UserID = #session.myAuthenticatedUser

RE: Access db interface

2007-10-29 Thread Ryan Heldt
Is this what you're looking for? http://cfdbexplorer.riaforge.org/ All you'd need to do is set up a ColdFusion DSN to your Access database. > -Original Message- > From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] > Sent: Monday, October 29, 2007 3:57 PM > To: CF-Talk > Subject: Access d

RE: Copying a CFC Persisted in Session Scope

2007-10-29 Thread Ryan Heldt
opying a CFC Persisted in Session Scope > > Yes, but why are you creating a copy in the first place? Why > do you think you need a copy and not a reference? > > On 10/29/07, Ryan Heldt <[EMAIL PROTECTED]> wrote: > > > > Thanks everyone for responding. Unfortunately, t

RE: Copying a CFC Persisted in Session Scope

2007-10-29 Thread Ryan Heldt
Thanks everyone for responding. Unfortunately, the method suggested by Rich below seemed to create a pointer rather than a separate instance of the object, as I had hoped. However, after discussing this with a co-worker, we seem to have cooked-up a viable solution. There were two objects I wanted

Copying a CFC Persisted in Session Scope

2007-10-29 Thread Ryan Heldt
ginal, and duplicate() doesn't work on CFCs (we're using CFMX 7). Anyone have a workaround or best-practice solution for this type of thing? -- Ryan Heldt Senior Web Developer Global Reach Internet Productions http://www.globalreach.com Phone: 515-296-079

Palm/Outlook Sync with ColdFusion

2007-05-15 Thread Ryan Heldt
One of my ColdFusion applications has a calendar and tasks list. The client wants to be able to sync (or at least download) the data into Palm Desktop or Outlook. I thought I found a solution in Wyncs (wyncs.com) however after running into a couple problems they determined I was somehow competin