Hi,
At least 12 years ago I developped my own visual database management system,
mainly because no one able to fulfill my needs was available on the market.
This manager includes a powerful visual query builder which generated not only
SQL code, but SQL integrated within CF code.
Now that many new products are on the market, I wonder if one is able to do
what I need or if I sould still use and support my own.
For instance, my system is able to generate the followind code with only 10
clicks, no text to enter.
Is this possible with any other SQL builder ?
<CFPARAM NAME="form.public" DEFAULT="0">
<CFPARAM NAME="form.docTitle" DEFAULT="">
<CFPARAM NAME="form.docNote" DEFAULT="">
<CFPARAM NAME="form.fileName" DEFAULT="">
<CFPARAM NAME="form.localName" DEFAULT="">
<CFPARAM NAME="form.fileSize" DEFAULT="0">
<CFPARAM NAME="form.docDate" DEFAULT="0">
<CFPARAM NAME="form.docType" DEFAULT="">
<CFPARAM NAME="form.timeDownloaded" DEFAULT="0">
<CFPARAM NAME="form.linkPage" DEFAULT="0">
<CFPARAM NAME="form.category" DEFAULT="0">
<CFPARAM NAME="form.membersOnly" DEFAULT="0">
<CFQUERY DATASOURCE="#application.applicationName#">
UPDATE docs SET
public = <CFQUERYPARAM CFSQLTYPE="CF_SQL_BIT"
VALUE="#form.public#">,
docTitle = <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR"
VALUE="#form.docTitle#">,
docNote = <CFQUERYPARAM CFSQLTYPE="CF_SQL_LONGVARCHAR"
VALUE="#form.docNote#">,
fileName = <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR"
VALUE="#form.fileName#">, <!--- original file name (ex: document.doc) --->
localName = <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR"
VALUE="#form.localName#">, <!--- local filename (ex: ABCDEF.cfm) --->
fileSize = <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER"
VALUE="#form.fileSize#">,
docDate = <CFQUERYPARAM CFSQLTYPE="CF_SQL_TIMESTAMP"
VALUE="#form.docDate#">, <!--- date uploaded --->
docType = <CFQUERYPARAM CFSQLTYPE="CF_SQL_VARCHAR"
VALUE="#form.docType#">, <!--- file extention (ex: doc xls mdb jpeg ...) --->
timeDownloaded = <CFQUERYPARAM CFSQLTYPE="CF_SQL_SMALLINT"
VALUE="#form.timeDownloaded#">, <!--- number of time downloaded --->
linkPage = <CFQUERYPARAM CFSQLTYPE="CF_SQL_BIT"
VALUE="#form.linkPage#">,
category = <CFQUERYPARAM CFSQLTYPE="CF_SQL_SMALLINT"
VALUE="#form.category#">,
membersOnly = <CFQUERYPARAM CFSQLTYPE="CF_SQL_BIT"
VALUE="#form.membersOnly#">
WHERE docId = <CFQUERYPARAM CFSQLTYPE="CF_SQL_INTEGER" VALUE="#form.docId#">
</CFQUERY>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349240
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
