Joseph Flanigan wrote:
DBX - excellent tool! Recommend it to others myself. Like the user interface. In my tool, I choose not to use a tree to list DB objects because in nearly every case, the node would be expanded. Instead, the tool uses selects and color the different objects. Also, it makes sorting by name across object types easier.
As far as Information_Schema over procedures? Some of the tool uses sysobjects and sp_help. But since Info_Schema is in the ANSI standard, my thought where other DBMS would use. Also, it there was a compelling reason to have other DBMS, the functions can be modified to have similar results. So using information schema allows separating the code generation from the DB.
Source. GPL/Open Souce.
Collaboration. You bet.
Joseph
At 01:01 AM 3/10/2004, you wrote:
Hello,
Thought I'd take this off the list for a moment. I was wondering a few things:
First, whether or not you had seen my own application, DBX, for SQLServer /
CF development. It can be found at www.websolete.com/exchange.cfm , with
some screenshots at www.websolete.com/images/dbx_screenshots . Sort of my
'baby', and I work on it constantly. It is also an app for which I've had
earmarked for CFC generation for a while, but have never spent the time on.
A while back, I was approached by someone regarding his own CFC generator
application, but apparently that has never come to pass, as its been a long
while since I've heard from him (the app in question was to be commercial,
IIRC).
Third, perhaps I didn't poke around enough, but is your code open source? I
didn't see where to download based off the url you gave, and was wondering
whether using your code in other applications, namely my own, was within the
license model you have. I see that you're using INFORMATION_SCHEMA to grab
the db schemata, and while it works, it's a bit old hat from what I
understand. My own uses standard catalog procedures, with some minor
twists, on the premise that their use will be better preserved in subsequent
versions of SQLServer (recommedned by MS over INFORMATION_SCHEMA.
At any rate, curious regarding the licensing or whether you're interested in
any collaborative effort.
Regards, Kevin Miller Websolete.com
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Joseph Flanigan
Sent: Wednesday, March 10, 2004 3:59 AM
To: [EMAIL PROTECTED]
Subject: Re: [CFCDev] CFC Code generator
Ok. I think this Code Generator is ready enough for this group to comment
on.
http://www.switch-box.org/cfsqltool/
This tool uses database objects and names to define CF namespaces and scripts to use for communicating with the database.
The tool has several wizards. For CFC generation, please look at the user
stored procedure wizard and the table CRUD wizard.
The database is SQL Server. The tool uses MS's version of ANSI Standard
INFORMATION_SCHEMA views . I am not familiar enough with other DBMSs
implementations of these views to say how the tool will work with them.
But, since the tool uses a CFC, INFORMATION_SCHEMA, perhaps the functions
can be changed for other DBMS. In the tool's documents is a version of
INFORMATION_SCHEMA.cfc.
The Table CRUD wizard option selector is especially interesting.
3-click-coding.
Joseph
------------------------------------------ Switch_box www.Switch-box.org MediaFirm, Inc. PO Box 2171 Loveland, CO 80539
[EMAIL PROTECTED]
---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
------------------------------------------ Switch_box www.Switch-box.org MediaFirm, Inc. PO Box 2171 Loveland, CO 80539
[EMAIL PROTECTED]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email
to [EMAIL PROTECTED] with the words 'unsubscribe cfcdev' in the message of the email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
An archive of the CFCDev list is available at www.mail-archive.com/[EMAIL PROTECTED]
