LOL, yeah, that's what I meant...
_____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Rouse Sent: Monday, March 31, 2008 11:54 AM To: [email protected] Subject: [houcfug] Re: free issue tracking systems? Yeah, that is essentially what I have been leaning towards except I was thinking of using the session time out instead of the applications. On Mon, Mar 31, 2008 at 11:46 AM, Seth Bienek <[EMAIL PROTECTED]> wrote: Maybe you could have a lockExpires column and stamp it 20 minutes (or ApplciationTimeout) into the future, then clear that column once a user exits a record. The edit page could look at the value of that column to determine wether to disable the save button or not. That way abandoned records would automatically unlock after 20 minutes (the lockExpires date would still be in the record but would be invalid)... Just a thought. Seth _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Rouse Sent: Monday, March 31, 2008 11:35 AM To: [email protected] Subject: [houcfug] Re: free issue tracking systems? Hah, well Aaron actually barely started to do this change then he had to go into surgery for a fractured wrist. For some reason I just never got back to it because that all happened over the summer. I actually want to dig into it very soon. The first thing I plan to do is change the user authentication to work with AD then move onto the comments history. I am still debating how I want to tackle the toe stepping. I think what I will do is lock a record from updates once a user opens it up, have that lock expire when their session expires or when they do the actual update. Then allow for a process to manually unlock things. Definitely things I need to get to soon because I have been using LH more and more lately. On Mon, Mar 31, 2008 at 10:44 AM, Seth Bienek <[EMAIL PROTECTED]> wrote: If someone (like Aaron, wink wink, nudge nudge) were to break the historty out into a seperate table and check in the changes, it would be a big improvent for what is probably the biggest drawback to the product. Seth _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aaron Rouse Sent: Monday, March 31, 2008 9:58 AM To: [email protected] Subject: [houcfug] Re: free issue tracking systems? That reminds me, we used it on Oracle on the project I mentioned earlier. At the time the scripts for Oracle created the comments/issues fields as varchar2. We routinely were getting to the point of running out of room due to the datatype. First tried to increase it to 4000k and ultimately went to a clob. Ray, the maker of LH, seemed to think that the scripts for Oracle did a clob out of the box but the ones we got did not, do not know if he since updated this. I personally always wanted to modify it so that comments were their own record in the database to make it easier to search on comments based upon user and time/date. On Mon, Mar 31, 2008 at 9:48 AM, Seth Bienek <[EMAIL PROTECTED]> wrote: I've had good luck using Lighthouse Pro for a 4-person team on my current project. http://lighthousepro.riaforge.org/ It's not a full-featured system, but it is CF-based, and well architected, so you can add the functionality you need fairly easily.. On a side note, the SQL is pretty plain vanilla, which makes it good for deploying on most DB platforms. It was designed for MySQL, but we deployed it on Oracle with only minor modifications (mostly to account for Oracle's case-sensitivity). Trac is a more complete free "project management" system, but is a little more (functionally) than we have needed, and I was put off by the poor usability and learning curve aspects. It may suit your needs, though: http://trac.edgewall.org/ Take Care, Seth _____ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Davis Sent: Monday, March 31, 2008 9:11 AM To: [email protected] Subject: [houcfug] free issue tracking systems? Anyone recommend a free or inexpensive issue tracking system? Mark Davis __________________________________________________ ProjecTools.com P.O. Box 786 Bellville, TX 77418 (713) 371 9840 x 1308 cell (303) 261-7851 [EMAIL PROTECTED] -- Aaron Rouse http://www.happyhacker.com/ -- Aaron Rouse http://www.happyhacker.com/ -- Aaron Rouse http://www.happyhacker.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the "Houston ColdFusion Users' Group" discussion list. To unsubscribe, send email to [EMAIL PROTECTED] For more options, visit http://groups.google.com/group/houcfug?hl=en -~----------~----~----~----~------~----~------~--~---
