I have been very pleased with CodeSmith. I wrote a template that dives into a
database and creates the 4 CRUD statements for every table in the database. I
am using SQL Server 2008, but it works with 2005 as well. I would be glad to
share the templates with you should you decide to use codes
Here is a list of most of the offerings I am aware of.
http://www.carehart.org/cf411/#cfcodegen
http://www.remotesynthesis.com/cfopensourcelist/index.cfm?event=public.home&categoryID=8474EB08-DB24-BAF7-24A39BADA46972B5
There are also some plugins for CF builder.
http://www.riaforge.org/index.cfm
On Monday 19 Apr 2010, Justin Scott wrote:
> Just curious what people are using to make/manage CRUD screens these days
> for data management applications. Anything new in this area over the last
> couple of years?
ColdFusion Builder has a wizard.
--
Helping to enthusiastically cultivate low-ri
None really. Charlie Arehart compiled a list of them here:
http://www.carehart.org/cf411/#cfcodegen
I have tried most of them. I like/use Illudium because of the templates. I
haven't tried the newest release but I hear you can do all tables of a DB.
G!
On Sun, Mar 1, 2009 at 5:02 PM, Peter Bo
> although the constant < > is frustrating!
Hmm, that should be < > then.
i.e. the escaped equivalent of < and >
Not sure why they're getting converted.
~|
Adobe® ColdFusion® 8 software 8 is the most important and drama
> I don't know of a comparison. I know I like Illudium, because I can
> adjust the XSLT to make it output as I would like it.
Yeah, the XSLT is good for flexibility, although the constant < > is
frustrating!
Would be much more readable with a dummy cf: namespace instead.
However, I couldn't ge
I don't know of a comparison. I know I like Illudium, because I can
adjust the XSLT to make it output as I would like it.
Steve "Cutter" Blades
Adobe Certified Professional
Advanced Macromedia ColdFusion MX 7 Developer
Co-Author of "Learning Ext JS"
http://www.packtpub.com/learning-ext-js/book
> But they are not digging through a hay stack. In my same example if
> a property manager for Rosharon logs in they typically only have 2-3
> properties they can even see or search through because the system
> already knows to limit things based upon the user. That is far from a
> needle in a ha
But they are not digging through a hay stack. In my same example if a
property manager for Rosharon logs in they typically only have 2-3
properties they can even see or search through because the system already
knows to limit things based upon the user. That is far from a needle in a
haystack. T
> I speculate they like it because they no longer have to list off a
> few unique features and just one. It certainly gets cumbersome trying
> to figure out which "rosharon" property someone is talking about when
> you have multiple street addresses tied to multiple segments but the
> person worki
Actually, no, not that group of people at all. They were accustomed to
referencing properties by their physical location because that is how their
old systems worked and how they talk of them in person, which is why I
initially did not put any IDs within emails or the website. What happened
is th
> I used to think that people do not care to see the primary key so in
> my last big application I did not display them(unique numeric IDs) in
> most places. After about 6-8 months it was found that the users want
> to see those keys and that they use them to reference things. For
> example they r
>
> But if you had 10 records and then deleted the 10th and then created a new
> record,
> you had a much greater risk of that record being contaminated with
> information from the previous record that had been there
..
Excellent point :)
I used to think it odd how dbs don't fill in the gaps
> I think reading the article will make your mind up either way about
> the wisdom of not using 'auto increments' / surrogate pks (I realise
> they are not the same thing).
This in particular
===
2) The definite possibility of historical data contamination. If you
leave your company, and som
I used to think that people do not care to see the primary key so in my last
big application I did not display them(unique numeric IDs) in most places.
After about 6-8 months it was found that the users want to see those keys
and that they use them to reference things. For example they rather say
>
> Heh... read the article... Had never heard anyone complain before about
> arbitrary primary keys... and honestly, it strikes me as being rather
> odd... I've only ever heard people complain about meaningful keys
> actually. But it just seems really odd to complain that "hey, it's a
> challenge
> > > ACK i was missing my # signs!!! new wife must have stolen them!
> >
> > I hear that's a common problem with newlyweds. :)
>
> hmmm... you think she only married him for his # signs? :)
Yeah, gotta be careful. She might be a # digger. :)
--
s. isaac dealey ^ new epoch
isn't it time fo
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=6136&whichpage=1
Heh... read the article... Had never heard anyone complain before about
arbitrary primary keys... and honestly, it strikes me as being rather
odd... I've only ever heard people complain about meaningful keys
actually. But it just
On Jan 16, 2008 6:52 PM, s. isaac dealey <[EMAIL PROTECTED]> wrote:
> > ACK i was missing my # signs!!! new wife must have stolen them!
>
> I hear that's a common problem with newlyweds. :)
hmmm... you think she only married him for his # signs? :)
--
"Scientists tell us that the fastest animal
> ACK i was missing my # signs!!! new wife must have stolen them!
I hear that's a common problem with newlyweds. :)
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTap.riaforge.org/blog
~~
Ok, so I did some googling because I wanted to know WHY it was 'best
practice' to add a surrogate key to the table and why to rail against the
idea of using 'natural keys' as primary keys.
I stumbled across perhaps the longest thread I have ever read completely, it
starts in November 2001 and the
>
> No, it's not sarcasm. Joe Celko is very well known and respected in that
> community.
Yeh, I see! Just googled "primary keys" "business logic" (cos I'm
interested) and his name came up straight away:
http://www.codinghorror.com/blog/archives/000817.html
Some varying and strong opinions of h
> > Joe Ceiko holds that theory and considering he's so
> > influential in the relational db world...
>
> I assume that's sarcasm; not being a mover in the relational
> db world I wouldn't know :P
No, it's not sarcasm. Joe Celko is very well known and respected in that
community.
Dave Watts, C
>
> Joe Ceiko holds that theory and considering he's so influential in the
> relational db world...
I assume that's sarcasm; not being a mover in the relational db world I
wouldn't know :P
I'd opt for the new primary key and unique constraint on the
columns everytime. Zero headache. The unique c
On "For some reason a former employer drilled it
into the team that Auto incrementing PK's were dead weight if you could
composite a key with existing data"
Joe Ceiko holds that theory and considering he's so influential in the
relational db world...
~
ACK i was missing my # signs!!! new wife must have stolen them!
IF NOT EXISTS (SELECT
ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk
FROM user_provider_services
WHERE ups_provider_fk =
AND ups_client_fk =
AND ups_
Sorry stepped away from the computer a couple days to get married WOOT!
now back to work
What I've come up with is:
IF NOT EXISTS (SELECT
ups_id_pk,ups_provider_fk,ups_client_fk,ups_service_fk
FROM user_provider_services
WHERE ups_provider_fk =
> > An auto Incrementing PK just makes it easier to insert a
> > duplicate.
>
> Not if the column is marked as a PK.
I think that Richard means, it's easier to insert duplicate data values with
a surrogate key. This is certainly true, unless you place constraints on the
natural key as well.
Dav
> I am time and again asked to build a cross join table with
> 2-3 primary keys.
> Also i am asked time and again to build a table that doesn't
> use a auto incrementing Primary key.
>
> This is usually to port an antiquated system to SQL and web
> enable it (think AS400).
>
> Has anyone built
On Monday 14 Jan 2008, Richard Dillman wrote:
> An auto Incrementing PK just makes it easier to insert a duplicate.
Not if the column is marked as a PK.
--
Tom Chiverton
Helping to proactively market bricks-and-clicks infomediaries
on: http://thefalken.livejournal.com
**
Well in the first example the concatenated ID needs to be unique.
In the second i would need a unique combination of ALL 3 Columns.
An auto Incrementing PK just makes it easier to insert a duplicate.
On Jan 14, 2008 10:39 AM, Tom Chiverton <[EMAIL PROTECTED]>
wrote:
> On Monday 14 Jan 2008, Rich
On Monday 14 Jan 2008, Richard Dillman wrote:
> Has anyone built a Crud system that can handle either of these situations?
Why not create a new PK column and use that ?
--
Tom Chiverton
Helping to paradigmatically initiate high-end partnerships
on: http://thefalken.livejournal.com
*
On 8/16/07, Raymond Camden <[EMAIL PROTECTED]> wrote:
> Ok, so why not tell us the _first_ error? :)
Okay, you got it. I'm spending the evening reading the CF8 docs, and
when I get in tomorrow morning, I'm going to give it another try.
Things SEEM like they're making a little more sense tonight wh
ed Advanced Coldfusion Developer
>
> -Original Message-
> From: LHWH Interactive [mailto:[EMAIL PROTECTED]
> Sent: Thursday, August 16, 2007 3:32 PM
> To: CF-Talk
> Subject: Re: Crud. I've never actually USED a custom tag...
>
> On 8/16/07, Peterson, Chris <
Ok, so why not tell us the _first_ error? :)
On 8/16/07, LHWH Interactive <[EMAIL PROTECTED]> wrote:
> *sigh*
>
> And of course, as soon as I restart and go into my admin, I'm able to
> add an additional path in the CF administrator.
>
> Okay okay, this is starting to get a LITTLE clearer. Now tha
*sigh*
And of course, as soon as I restart and go into my admin, I'm able to
add an additional path in the CF administrator.
Okay okay, this is starting to get a LITTLE clearer. Now that I've got
workable paths, things seem to be getting a little easier to
understand.
Once I get beyond the path
On 8/16/07, Raymond Camden <[EMAIL PROTECTED]> wrote:
> Lots of questions here.
>
> First off - no, you do not need to use the core custom tags path. When you do:
>
> cf_foo
>
> CF will...
>
> Look in your current folder.
> Look in the custom tags folder.
>
> Note that you can define multiple folde
On 8/16/07, Dave Francis <[EMAIL PROTECTED]> wrote:
> Really need more info on yoiur symptoms.
Well, honestly, I'm just wading thru path errors right now. I think my
problem is just calling pages and paths. If I can get all the "pieces"
in the right places, I'm pretty sure this will work. I'm usin
Lots of questions here.
First off - no, you do not need to use the core custom tags path. When you do:
cf_foo
CF will...
Look in your current folder.
Look in the custom tags folder.
Note that you can define multiple folders in the CF Admin, and in CF8
you can specify folders at runtime.
The p
-Original Message-
From: LHWH Interactive [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 16, 2007 3:32 PM
To: CF-Talk
Subject: Re: Crud. I've never actually USED a custom tag...
On 8/16/07, Peterson, Chris <[EMAIL PROTECTED]> wrote:
> Paste your code and maybe someone can
I don't have CF8, but in general, CF looks for custom tags in the folder of
the calling page, then the CustomTags folder. (BlueDragon lets you specify
additional folders, does CF8?). And if you move a tag, then you have to
restart CF.
Really need more info on yoiur symptoms.
-Original Message
On 8/16/07, Peterson, Chris <[EMAIL PROTECTED]> wrote:
> Paste your code and maybe someone can give you a tip =)
Honestly? That's part of the problem. I'm having a tough time figuring
out all the path nonesnse. First off, do I have to put all the files
in my ColdFusion8/CustomTags/ directory? And
Paste your code and maybe someone can give you a tip =)
Chris Peterson
Gainey IT
Adobe Certified Advanced Coldfusion Developer
-Original Message-
From: LHWH Interactive [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 16, 2007 2:35 PM
To: CF-Talk
Subject: Crud. I've never actually USED
ase.
Rich
-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 4:44 PM
To: CF-Talk
Subject: Re: CRUD
Doesn't the RDS plugin for CFEclipse build back end CFCs as well? I
know it
does not build the exact same thing but was under the impression it
Thanks, I had seen and used the first link but did not know about the
second. Going to have to give it a try this week.
On 8/8/06, Matt Williams <[EMAIL PROTECTED]> wrote:
>
> For code generation, also see Peter Farrell's site:
> http://rooibos.maestropublishing.com (beans and Transfer Objects)
>
it
> builds
> > all of the back end CFCs for you.
> >
> > Thanks for the tips!
> > Chda
> >
> >
> >
> > -Original Message-
> > From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, August 08, 2006 3:11 PM
> > T
t; From: Aaron Rouse [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 08, 2006 3:11 PM
> To: CF-Talk
> Subject: Re: CRUD
>
> I do this as well, my first version of it stored the table information in
> the application scope so I only did that one query. The second version
> tho
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 08, 2006 3:11 PM
To: CF-Talk
Subject: Re: CRUD
I do this as well, my first version of it stored the table information in
the application scope so I only did that one query. The second version
though I changed to just do a query for table information
I do this as well, my first version of it stored the table information in
the application scope so I only did that one query. The second version
though I changed to just do a query for table information before any
insert/updates because found the hit to the database system tables just was
not hurt
> Let me first start off I am not an OO kind of guy. I like things
> linear and easy to read. That is why I like CF.
>
> I have a few database tables that have hundreds of fields.
>
> Making forms and action pages to edit, insert and update the data into
> the tables is cumbersome and tedious
MAIL PROTECTED]
>Sent: Monday, August 07, 2006 3:43 PM
>To: CF-Talk
>Subject: Re: CRUD
>
>
>Warning, plug ahead (but for free, open source product):
>
>Chad,
>
>I have a solution (DataMgr) that does what I think you are asking for.
>
>It is an object, but doesn&#
That looks pretty nice. Thanks for posting it.
I think though that the OP was looking for a tool which also created the
form itself. Does DataMgr do this too?
-Original Message-
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: Monday, August 07, 2006 3:43 PM
To: CF-Talk
Subject: Re
Warning, plug ahead (but for free, open source product):
Chad,
I have a solution (DataMgr) that does what I think you are asking for.
It is an object, but doesn't require you to do any OO in order to use it. Nor
does it require any major changes to the structure of your code.
http://www.bryant
-Original Message-
From: Denny Valliant [mailto:[EMAIL PROTECTED]
Sent: 07 August 2006 03:01
To: CF-Talk
Subject: Re: CRUD
On 8/6/06, Kevin Roche <[EMAIL PROTECTED]> wrote:
>
> Chad,
>
> Reactor only creates CFCs that do the standard J2EE like CRUD model
> (DAO, Gateway, Active R
On 8/6/06, Kevin Roche <[EMAIL PROTECTED]> wrote:
>
> Chad,
>
> Reactor only creates CFCs that do the standard J2EE like CRUD model (DAO,
> Gateway, Active Record), which you can call from your own display and edit
> pages,
>
> Model-Glue (version 2.0 of which incoporates reactor) will also create
-
From: Chad Gray [mailto:[EMAIL PROTECTED]
Sent: 06 August 2006 16:23
To: CF-Talk
Subject: RE: CRUD
Im not quite sure what you mean, model or maintenance.
I will read up on the below links! Thanks for the suggestions.
-Original Message-
From: Kevin Roche [mailto:[EMAIL PROTECTED
Im not quite sure what you mean, model or maintenance.
I will read up on the below links! Thanks for the suggestions.
-Original Message-
From: Kevin Roche [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 06, 2006 11:15 AM
To: CF-Talk
Subject: RE: CRUD
Chad,
Do you want to do the
Chad,
Do you want to do the model or the complete maintenance program?
The model is best covered by Reactor which you can get from
http://www.doughughes.net/index.cfm?filter=category&categoryId=30
If you want to create a complete maintenance system the best choice is the
Model-Glue framework wh
2007...no specific day...just '07.
j/k
On 11/9/05, Thomas Chiverton <[EMAIL PROTECTED]> wrote:
>
> On Wednesday 09 November 2005 07:02, Barney Boisvert wrote:
> > Based on my experience building custom, app-specific generators, what
>
> So you're gonna have this rolled out by, say, Friday ?
> :-)
On Wednesday 09 November 2005 07:02, Barney Boisvert wrote:
> Based on my experience building custom, app-specific generators, what
So you're gonna have this rolled out by, say, Friday ?
:-)
--
Tom Chiverton
Advanced ColdFusion Programmer
~~
Barney,
Sounds like it's almost ready!
On 11/9/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
>
> Based on my experience building custom, app-specific generators, what
> I've liked, disliked, and considered...
>
> A generator should be able to be rerun at arbitrary times and update
> the CRUD pa
lol. Great reply. :-)
--
John C. Bland II
"I do what I can do when I can do it." - Chris Tucker, Money Talks
http://www.gotoandstop.org - Home of FMUG.az
~|
Logware (www.logware.us): a new and convenient web-based time tracking
lol. Great reply. :-)
Thx Barney!
On 11/9/05, Barney Boisvert <[EMAIL PROTECTED]> wrote:
>
> Based on my experience building custom, app-specific generators, what
> I've liked, disliked, and considered...
>
> A generator should be able to be rerun at arbitrary times and update
> the CRUD part wit
Based on my experience building custom, app-specific generators, what
I've liked, disliked, and considered...
A generator should be able to be rerun at arbitrary times and update
the CRUD part without affecting anything else. It should create beans
that have getters/setters for properties. It sh
on 3/21/03 12:36 PM, Raymond Camden at [EMAIL PROTECTED] wrote:
> You may want to set the value to false _above_ the cfif blocks, and only
> turn it to true on a good login.
>
Okay, now I KNOW I'm doing something right...because that's exactly the
approach I took...
Who knows...one day I might
To: CF-Talk
> Subject: Re: Crud...I thought I had it down...[cflogin]
>
>
> on 3/21/03 11:44 AM, Raymond Camden at [EMAIL PROTECTED] wrote:
>
> > LoggedIn will NOT be defined if you try to login and fail.
> Notice your
> > error msg branch doesn't set l
on 3/21/03 11:44 AM, Raymond Camden at [EMAIL PROTECTED] wrote:
> LoggedIn will NOT be defined if you try to login and fail. Notice your
> error msg branch doesn't set loggedIn to 0?
Yep, you're absolutely right. I kinda caught that as I was pasting it in,
and corrected it when I changed it to s
on 3/21/03 11:35 AM, [EMAIL PROTECTED] at
[EMAIL PROTECTED] wrote:
> you probably need to set your var LoggedIn in the session scope. This wil
> make the var available throught the session. the variables scope exists in
> the cfm page only.
>
>
>
> (mind your cflocks though)
CFMX baby! and t
LoggedIn will NOT be defined if you try to login and fail. Notice your
error msg branch doesn't set loggedIn to 0?
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
Member of Team Macromedia (http://www.macromedia.com/g
Set it as session.loggedIN Once you change the page you are no longer
executing the query, which means you are not setting the variables again.
That's why they never exist.
Eric
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Friday, March 21, 2003 11:01 AM
To: CF-Talk
S
you probably need to set your var LoggedIn in the session scope. This wil make the
var available throught the session. the variables scope exists in the cfm page only.
(mind your cflocks though)
Doug
>-Original Message-
>From: Jeff [mailto:[EMAIL PROTECTED]
>Sent: Friday, March 21
71 matches
Mail list logo
