Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-11 Thread Nicholas Stein
Since I am also a C# programmer, I wrote some templates in CodeSmith. I would be happy to share. They might be a good starting point for you. Here are the templates I have so far. 1. StoredProcedures.cst - Look at a MSSqlServer table and generate CRUD stored procs. 2.

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-10 Thread Tom Chiverton
On Wednesday 09 Jan 2008, George Linderman wrote: want to INSERT or UPDATE is a large source of pain for me. Do you know of any faster way of doing this? Perhaps with a CFC or something else? Or As well as an ORM like Reactor, you might investigate a code generator like Illudium that can also

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-10 Thread Steve Bryant
George, I wrote DataMgr for just this sort of thing. http://www.bryantwebconsulting.com/cfcs/ http://datamgr.riaforge.org/ If you are using OO, then an ORM would be the way to go. Transfer, Reactor, and objectBreeze. I wrote some brief thoughts on different approaches here:

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Todd
Break up the form into forms? On Jan 9, 2008 11:56 AM, George Linderman wrote: Hey guys, We all do them all the time, just good old basic SQL queries. INSERT, UPDATE etc. However, many times the forms I develop are insanely long...so writing down all of the field names, and then their

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Brian Kotek
Use an ORM. On Jan 9, 2008 11:56 AM, George Linderman [EMAIL PROTECTED] wrote: Hey guys, We all do them all the time, just good old basic SQL queries. INSERT, UPDATE etc. However, many times the forms I develop are insanely long...so writing down all of the field names, and then their

RE: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Jerry Guido
that you have received this transmittal in error; any review, dissemination, distribution or copying of this transmittal is strictly prohibited. -Original Message- From: Todd [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 09, 2008 12:13 PM To: CF-Talk Subject: Re: CFC, Custom tag

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Marco Antonio C. Santos
: Wednesday, January 09, 2008 12:13 PM To: CF-Talk Subject: Re: CFC, Custom tag, or something for tedious SQL Queries? Break up the form into forms? On Jan 9, 2008 11:56 AM, George Linderman wrote: Hey guys, We all do them all the time, just good old basic SQL queries. INSERT, UPDATE

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Dominic Watson
Use an ORM ORM = Object-Relational Modeler/Modeling Examples: * Reactor: http://www.alagad.com/go/products-and-projects/reactor-for-coldfusion/reactor-for-coldfusion * Transfer: http://compoundtheory.com/?action=transfer.index In a nutshell, these work by automatically generating components

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Brian Kotek
Object-Relational Mapping, actually. Transfer seems to have the most traction nowadays. On Jan 9, 2008 1:17 PM, Dominic Watson [EMAIL PROTECTED] wrote: Use an ORM ORM = Object-Relational Modeler/Modeling Examples: * Reactor:

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Dominic Watson
Object-Relational Mapping, actually. Transfer seems to have the most traction nowadays. Lol ok, that makes more sense - I got the term 'modelling' from here: http://trac.reactorframework.com/ and I have heard modeler, mapping, mapper and modeling all used. I s 'modeling/modeler' just plain

Re: CFC, Custom tag, or something for tedious SQL Queries?

2008-01-09 Thread Brian Kotek
It's Mapping. Not sure where Doug got modeling from, that's not correct. On Jan 9, 2008 2:04 PM, Dominic Watson [EMAIL PROTECTED] wrote: Object-Relational Mapping, actually. Transfer seems to have the most traction nowadays. Lol ok, that makes more sense - I got the term 'modelling'