RE: [KCFusion] checking for nulls...
cfif trim(whatever) eq whatever is null/cfif -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 7:46 AM To: CF-List (E-mail) Subject: [KCFusion] checking for nulls... what's the syntax to check if a variable is null... i.e. cfif var is 'null cfset var = something /cfif Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
Re: [KCFusion] checking for nulls...
Michael, ColdFusion has no true null primitive. It is, therefore, impossible through normal means to differentiate between a true null and the zero-length string nulls are translated into. For an example of working around this when using Java classes, see my article, Leveraging Java Classes from ColdFusion: http://www.macromedia.com/v1/handlers/index.cfm?id=22277method=full --Daryl - Original Message - From: Johnson, Michael [EMAIL PROTECTED] To: CF-List (E-mail) [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 7:46 AM Subject: [KCFusion] checking for nulls... what's the syntax to check if a variable is null... i.e. cfif var is 'null cfset var = something /cfif Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] Lookup Table
On a form, one of the fields is, let's say, "Things We Love". It is populated by an "TWL" table. TWLTable: 1 Grandchildren 2 Children 3 Sunsets How can I choose from the list OR add a new TWL to the table? James K "Jamie" Tieman Allied, Inc P.O. Box 422 Harrisonville, MO 64701 Phone 816.380.6274
RE: [KCFusion] Lookup Table
I would create a select list from the values in the table, and then also create a text input (with a slightly different name) for someone to enter a new value. Then, just check the form fields on your processing page... I would say that anything in the text input field overrides a value from the select list... so if the text input is populated, do an insert, then do your normal processing. If they just chose something from the select list, then just do your normal processing. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James K TiemanSent: Thursday, September 12, 2002 8:48 AMTo: KCFusionSubject: [KCFusion] Lookup Table On a form, one of the fields is, let's say, "Things We Love". It is populated by an "TWL" table. TWLTable: 1 Grandchildren 2 Children 3 Sunsets How can I choose from the list OR add a new TWL to the table? James K "Jamie" Tieman Allied, Inc P.O. Box 422 Harrisonville, MO 64701 Phone 816.380.6274
[KCFusion] CFApplication::execute
Our hosting Company "Communitech keeps coming up with this error this morning" What does this mean? Error Occurred While Processing Request Error Diagnostic Information unknown exception condition CFApplication::execute The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (1:1) to (5:50). Rick
Re: [KCFusion] CFApplication::execute
Sounds like someone is using unlocked Application and/or Session variables. If they're running a shared hosting environment, they should consider turning on "full checking" for both variable types to identify the culprit. --Daryl - Original Message - From: cfhelp To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 9:02 AM Subject: [KCFusion] CFApplication::execute Our hosting Company "Communitech keeps coming up with this error this morning" What does this mean? Error Occurred While Processing Request Error Diagnostic Information unknown exception condition CFApplication::execute The error occurred while processing an element with a general identifier of (CFAPPLICATION), occupying document position (1:1) to (5:50). Rick
RE: [KCFusion] Lookup Table
James, When you say this is a form and that you want to 'choose' from the list, or add a new record, what do you mean? If I understand you correctly, you want to be able to display what is currently in the record (in the table) and allow them to update the fields, OR they can click on a link somewhere (maybe there) and get the same form but blank and allow them to enter the information and then insert that info into a new record in the table. Use 1 form, have a query run inside the page that will query the record from the table. If the user is 'viewing/editing' the table, a record is found and the form fields are populated using #Query.fieldname#. To I To start with blank fields and perform an insert, somehow the form, when it is called, needs to know if the page is new or for editing. Modify the query above so that it runs, but does not actually find a record in the db. The fields will be returned, but as null values. Now, the form will be filled out, but be 'blank'. Make sure that you then send a hidden value, or a primary key from the form to your action page, use that value to determine if you should perform an update, insert, delete, etc. Now, if you meant to ask us how you would show the form for editing, but have a field (radio button) to indicate if this was to be updated or deleted, then it is even easier. The radio button should have 2+ values, insert, update, delete. When the action page is called, check for the radio button's value. If it is say, '1', then run an insert query. If 2, 'update' with the appropriate set statements. If 3, delete where primary key = ??. Does this make sense? By using a query at the top of the page to populate for new and existing data, you only need 1 form. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of James K Tieman Sent: Thursday, September 12, 2002 8:48 AM To: KCFusion Subject: [KCFusion] Lookup Table On a form, one of the fields is, let's say, Things We Love. It is populated by an TWL table. TWL Table: 1Grandchildren 2Children 3Sunsets How can I choose from the list OR add a new TWL to the table? James K Jamie Tieman Allied, Inc P.O. Box 422 Harrisonville, MO 64701 Phone 816.380.6274 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
You probably want to perform an IsDefined check, for instance cfif IsDefined(var)your statement/cfif IF you have a form submission with check boxes, boxes that are not checked are not submitted and hence are effectively null and you can't perform a value check on them because they don't exist. CF does NOT support null values. The closest it comes is having a few methods of checking on the existence of a variable. Everyone else's replies about checking the length of the variable and potentially trimming white space seems accurate...assuming the variable exists. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Johnson, Michael Sent: Thursday, September 12, 2002 7:46 AM To: CF-List (E-mail) Subject: [KCFusion] checking for nulls... what's the syntax to check if a variable is null... i.e. cfif var is 'null cfset var = something /cfif Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Lookup Table
How would you arrange the fields on the form? Would you stack them with the select box on top and update the text box after a selection is made?Could one of the choices could be "other" and if you clicked it, an empty string and the focus (cusor) would go into the text box? Does that make any sense? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nate RightmireSent: Thursday, September 12, 2002 8:58 AMTo: [EMAIL PROTECTED]Subject: RE: [KCFusion] Lookup Table I would create a select list from the values in the table, and then also create a text input (with a slightly different name) for someone to enter a new value. Then, just check the form fields on your processing page... I would say that anything in the text input field overrides a value from the select list... so if the text input is populated, do an insert, then do your normal processing. If they just chose something from the select list, then just do your normal processing. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James K TiemanSent: Thursday, September 12, 2002 8:48 AMTo: KCFusionSubject: [KCFusion] Lookup Table On a form, one of the fields is, let's say, "Things We Love". It is populated by an "TWL" table. TWLTable: 1 Grandchildren 2 Children 3 Sunsets How can I choose from the list OR add a new TWL to the table? James K "Jamie" Tieman Allied, Inc P.O. Box 422 Harrisonville, MO 64701 Phone 816.380.6274
RE: [KCFusion] checking for nulls...
The only problem I see with this, is he says checking if a variable is NULL, which probably means it does exist, hes just checking the value of it. I do this alot with datbase queries where I loop through a recordset, set some variables to the values that were in the database and then check if it contains data or is null. I guess what might be helpful to decide which is the best route to take would be to know what the intention of the code is to be used for. Checking if it exists or checking if the value exists but is null. Misty Woodward Oleani Technologies www.oleani.com -- Original Message -- From: Ryan Hartwich [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 09:26:51 -0500 You probably want to perform an IsDefined check, for instance cfif IsDefined(var)your statement/cfif IF you have a form submission with check boxes, boxes that are not checked are not submitted and hence are effectively null and you can't perform a value check on them because they don't exist. CF does NOT support null values. The closest it comes is having a few methods of checking on the existence of a variable. Everyone else's replies about checking the length of the variable and potentially trimming white space seems accurate...assuming the variable exists. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Johnson, Michael Sent: Thursday, September 12, 2002 7:46 AM To: CF-List (E-mail) Subject: [KCFusion] checking for nulls... what's the syntax to check if a variable is null... i.e. cfif var is 'null cfset var = something /cfif Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Lookup Table
Thats one way. I saw on a site where there was 2 radio buttons. The first one was defaulted to checked and the select box was enabled to choose from a list. The other radio box, when it was checked, disabled the drop down box and enabled the other text box to enter data in. I guess the point of it was so that if you selected something from the drop down box and that radio button was checked it would disable the text box and put an empty string in it, so it wouldnt be necessary to even check for its existance. Misty Woodward Oleani Technologies www.oleani.com -- Original Message -- From: James K Tieman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 09:29:59 -0500 How would you arrange the fields on the form? Would you stack them with the select box on top and update the text box after a selection is made? Could one of the choices could be other and if you clicked it, an empty string and the focus (cusor) would go into the text box? Does that make any sense? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nate Rightmire Sent: Thursday, September 12, 2002 8:58 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Lookup Table I would create a select list from the values in the table, and then also create a text input (with a slightly different name) for someone to enter a new value. Then, just check the form fields on your processing page... I would say that anything in the text input field overrides a value from the select list... so if the text input is populated, do an insert, then do your normal processing. If they just chose something from the select list, then just do your normal processing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of James K Tieman Sent: Thursday, September 12, 2002 8:48 AM To: KCFusion Subject: [KCFusion] Lookup Table On a form, one of the fields is, let's say, Things We Love. It is populated by an TWL table. TWL Table: 1Grandchildren 2Children 3Sunsets How can I choose from the list OR add a new TWL to the table? James K Jamie Tieman Allied, Inc P.O. Box 422 Harrisonville, MO 64701 Phone 816.380.6274 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Lookup Table
Some of the other suggestions will work OK if your list is a VERY simple, single field input. However, if you need to add a multifield child record, you may need a little different technique. We have used this technique: select ... option...--- Select A Record --/option option...Child Record 1/option option...Child Record 2/option option...Child Record 1/option option...--- Enter A New Record --/option /select Then write a JavaScript that pops up your child record edit page in a new window. You should also tell your child edit page to re-populate the select list in the parent window when you save the new record to the database. Robin Greenhagen President GSI http://www.gsi-kc.com/ -Original Message- From: James K Tieman [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 8:48 AM To: KCFusion Subject: [KCFusion] Lookup Table On a form, one of the fields is, let's say, Things We Love. It is populated by an TWL table. TWL Table: 1Grandchildren 2Children 3Sunsets How can I choose from the list OR add a new TWL to the table? James K Jamie Tieman Allied, Inc P.O. Box 422 Harrisonville, MO 64701 Phone 816.380.6274 __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
I would do it like below: CFIF testValue is not null ...do something CFELSE ...catch exception /CFIF From: Cox, Billy W [PCS] [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... Date: Thu, 12 Sep 2002 09:07:35 -0500 MIME-Version: 1.0 Received: from Falcon.HKSI.net ([209.15.194.101]) by mc1-f14.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12 Sep 2002 07:09:03 -0700 Received: from kcfusion.org (unknown [209.15.194.113])by Falcon.HKSI.net (Postfix) with ESMTPid 933DD2524E; Thu, 12 Sep 2002 09:49:23 -0500 (CDT) Received: from Falcon.HKSI.net [209.15.194.101] by hksi.net (SMTPD32-7.12) id A02A258B00A6; Thu, 12 Sep 2002 09:09:46 -0500 Received: from smtpgw5.sprintspectrum.com (smtpgw5.sprintspectrum.com [207.40.188.13])by Falcon.HKSI.net (Postfix) with ESMTP id E258A25239for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:47:57 -0500 (CDT) Received: from pkcex003.sprintspectrum.com (pkcex003.sprintspectrum.com [208.10.75.138])by smtpgw5.sprintspectrum.com (8.11.2/8.11.3) with ESMTP id g8CE7aE21317for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:07:37 -0500 (CDT) Received: by pkcex003.sprintspectrum.com with Internet Mail Service (5.5.2654.89)id SNL1WGQM; Thu, 12 Sep 2002 09:07:37 -0500 Message-ID: [EMAIL PROTECTED] Return-Receipt-To: Cox, Billy W [PCS] [EMAIL PROTECTED] X-Mailer: Internet Mail Service (5.5.2654.89) X-RBL-Warning: NOABUSE: Not supporting abuse@domain X-Note: This E-mail was scanned for spam. Precedence: bulk Sender: [EMAIL PROTECTED] X-Note: This E-mail was scanned for spam. Organization: Humankind Systems, Inc. Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 12 Sep 2002 14:09:04.0008 (UTC) FILETIME=[F34FB880:01C25A65] I would code it this way: cfif not len(trim(var)) cfset var=something /cfif It accomplishes the same thing, just more elegantly. Billy Cox Intranet/Extranet Sprint PCS 913-534-5873 913-638-5557 pcs -Original Message- From: Nate Rightmire [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... I always use the following: cfif len(trim(var)) is 0 cfset var = something /cfif I read that this was better than just cfif var=. I dunno if it really is, but that is what I use. My $.02 Nate -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Johnson, Michael Sent: Thursday, September 12, 2002 7:46 AM To: CF-List (E-mail) Subject: [KCFusion] checking for nulls... what's the syntax to check if a variable is null... i.e. cfif var is 'null cfset var = something /cfif Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] Roydean _ Send and receive Hotmail on your mobile device: http://mobile.msn.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
Umm... If you are going to do that type of thing, then you should probably do it like this cfset null = CFIF trim(testValue) is not null ...do something CFELSE ...catch exception /CFIF -Original Message- From: Roy Dean [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 10:44 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... I would do it like below: CFIF testValue is not null ...do something CFELSE ...catch exception /CFIF From: Cox, Billy W [PCS] [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: '[EMAIL PROTECTED]' [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... Date: Thu, 12 Sep 2002 09:07:35 -0500 MIME-Version: 1.0 Received: from Falcon.HKSI.net ([209.15.194.101]) by mc1-f14.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12 Sep 2002 07:09:03 -0700 Received: from kcfusion.org (unknown [209.15.194.113])by Falcon.HKSI.net (Postfix) with ESMTPid 933DD2524E; Thu, 12 Sep 2002 09:49:23 -0500 (CDT) Received: from Falcon.HKSI.net [209.15.194.101] by hksi.net (SMTPD32-7.12) id A02A258B00A6; Thu, 12 Sep 2002 09:09:46 -0500 Received: from smtpgw5.sprintspectrum.com (smtpgw5.sprintspectrum.com [207.40.188.13])by Falcon.HKSI.net (Postfix) with ESMTP id E258A25239for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:47:57 -0500 (CDT) Received: from pkcex003.sprintspectrum.com (pkcex003.sprintspectrum.com [208.10.75.138])by smtpgw5.sprintspectrum.com (8.11.2/8.11.3) with ESMTP id g8CE7aE21317for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:07:37 -0500 (CDT) Received: by pkcex003.sprintspectrum.com with Internet Mail Service (5.5.2654.89)id SNL1WGQM; Thu, 12 Sep 2002 09:07:37 -0500 Message-ID: [EMAIL PROTECTED] Return-Receipt-To: Cox, Billy W [PCS] [EMAIL PROTECTED] X-Mailer: Internet Mail Service (5.5.2654.89) X-RBL-Warning: NOABUSE: Not supporting abuse@domain X-Note: This E-mail was scanned for spam. Precedence: bulk Sender: [EMAIL PROTECTED] X-Note: This E-mail was scanned for spam. Organization: Humankind Systems, Inc. Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 12 Sep 2002 14:09:04.0008 (UTC) FILETIME=[F34FB880:01C25A65] I would code it this way: cfif not len(trim(var)) cfset var=something /cfif It accomplishes the same thing, just more elegantly. Billy Cox Intranet/Extranet Sprint PCS 913-534-5873 913-638-5557 pcs -Original Message- From: Nate Rightmire [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 8:35 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... I always use the following: cfif len(trim(var)) is 0 cfset var = something /cfif I read that this was better than just cfif var=. I dunno if it really is, but that is what I use. My $.02 Nate -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Johnson, Michael Sent: Thursday, September 12, 2002 7:46 AM To: CF-List (E-mail) Subject: [KCFusion] checking for nulls... what's the syntax to check if a variable is null... i.e. cfif var is 'null cfset var = something /cfif Mike Johnson Science Application International Corporation (757) 870-9165 Emai: [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] Roydean _ Send and receive Hotmail on your mobile device: http://mobile.msn.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The
RE: [KCFusion] checking for nulls...
The ultimate solution would be a UDF!
http://www.cflib.org/udf.cfm?ID=644 (code below)
Then all you would have to do is say
cfif isNull(whatever)
whatever is null
/cfif
cfscript
/**
* Returns True if the value passed to it represents quot;NULLquot;.
*
* @param valValue to evaluate for NULL. (Required)
* @param NullIdentifier String that represents NULL. Default is an empty
string (). (Optional)
* @return Returns a Boolean.
* @author Rob Brooks-Bilson ([EMAIL PROTECTED])
* @version 1, May 1, 2002
*/
function IsNull(val){
var NullIdentifier = ;
if (ArrayLen(Arguments) gte 2)
NullIdentifier = Arguments[2];
if (val is NullIdentifier) {
return True;
}
else {
return False;
}
}
/cfscript
Geez, do you think this thread has gone on way to long or is it just me?
-Original Message-
From: Matt Jones
Sent: Thursday, September 12, 2002 10:57 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...
Umm...
If you are going to do that type of thing, then you should probably do
it like this
cfset null =
CFIF trim(testValue) is not null
...do something
CFELSE
...catch exception
/CFIF
-Original Message-
From: Roy Dean [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 10:44 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...
I would do it like below:
CFIF testValue is not null
...do something
CFELSE
...catch exception
/CFIF
From: Cox, Billy W [PCS] [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: '[EMAIL PROTECTED]' [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...
Date: Thu, 12 Sep 2002 09:07:35 -0500
MIME-Version: 1.0
Received: from Falcon.HKSI.net ([209.15.194.101]) by
mc1-f14.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Thu, 12
Sep
2002 07:09:03 -0700
Received: from kcfusion.org (unknown [209.15.194.113])by Falcon.HKSI.net
(Postfix) with ESMTPid 933DD2524E; Thu, 12 Sep 2002 09:49:23 -0500 (CDT)
Received: from Falcon.HKSI.net [209.15.194.101] by hksi.net
(SMTPD32-7.12)
id A02A258B00A6; Thu, 12 Sep 2002 09:09:46 -0500
Received: from smtpgw5.sprintspectrum.com (smtpgw5.sprintspectrum.com
[207.40.188.13])by Falcon.HKSI.net (Postfix) with ESMTP id E258A25239for
[EMAIL PROTECTED]; Thu, 12 Sep 2002 09:47:57 -0500 (CDT)
Received: from pkcex003.sprintspectrum.com (pkcex003.sprintspectrum.com
[208.10.75.138])by smtpgw5.sprintspectrum.com (8.11.2/8.11.3) with ESMTP
id
g8CE7aE21317for [EMAIL PROTECTED]; Thu, 12 Sep 2002 09:07:37 -0500
(CDT)
Received: by pkcex003.sprintspectrum.com with Internet Mail Service
(5.5.2654.89)id SNL1WGQM; Thu, 12 Sep 2002 09:07:37 -0500
Message-ID:
[EMAIL PROTECTED]
Return-Receipt-To: Cox, Billy W [PCS] [EMAIL PROTECTED]
X-Mailer: Internet Mail Service (5.5.2654.89)
X-RBL-Warning: NOABUSE: Not supporting abuse@domain
X-Note: This E-mail was scanned for spam.
Precedence: bulk
Sender: [EMAIL PROTECTED]
X-Note: This E-mail was scanned for spam.
Organization: Humankind Systems, Inc.
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 12 Sep 2002 14:09:04.0008 (UTC)
FILETIME=[F34FB880:01C25A65]
I would code it this way:
cfif not len(trim(var))
cfset var=something
/cfif
It accomplishes the same thing, just more elegantly.
Billy Cox
Intranet/Extranet
Sprint PCS
913-534-5873
913-638-5557 pcs
-Original Message-
From: Nate Rightmire [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 8:35 AM
To: [EMAIL PROTECTED]
Subject: RE: [KCFusion] checking for nulls...
I always use the following:
cfif len(trim(var)) is 0
cfset var = something
/cfif
I read that this was better than just cfif var=. I dunno if it
really
is, but that is what I use.
My $.02
Nate
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Johnson, Michael
Sent: Thursday, September 12, 2002 7:46 AM
To: CF-List (E-mail)
Subject: [KCFusion] checking for nulls...
what's the syntax to check if a variable is null...
i.e.
cfif var is 'null
cfset var = something
/cfif
Mike Johnson
Science Application International Corporation
(757) 870-9165
Emai: [EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
__
The KCFusion.org list and website is hosted by Humankind Systems, Inc.
List Archives http://www.mail-archive.com/cf-list@kcfusion.org
Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED]
To Subscribe mailto:[EMAIL PROTECTED]
To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] next meeting?
When is the next meeting? __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
Geez, do you think this thread has gone on way to long or is it just me? Honestly, I think the original question may have been a SQL question, not a CF question. ;-) -glenn __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
Well, how's it going Misty? -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... LOL I think its great! Was getting a little dusty in my KCFusion inbox. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:23:20 -0500 Geez, do you think this thread has gone on way to long or is it just me? Honestly, I think the original question may have been a SQL question, not a CF question. ;-) -glenn __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] checking for nulls...
cf_joking Oh, well fine then... shall we keep the NULL conversation going? 1. Um, it was a CF question. (see original post) 2. What solution did Mike use? Come on, we all want to know. /cf_joking cf_for_real 3. I agree with Misty. 4. UDFs are cool. 5. Just having some fun here /cf_for_real Hey Misty, Did you know I can throw stuff at Matt for you from where I sit? We are working together again but, Matt is still Mr. Fusebox. -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... LOL I think its great! Was getting a little dusty in my KCFusion inbox. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:23:20 -0500 Geez, do you think this thread has gone on way to long or is it just me? Honestly, I think the original question may have been a SQL question, not a CF question. ;-) -glenn __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Changing the subject
I heard about that job a few months ago guess they are still looking. Too bad I like this job so much. My top secret project rocks! Can't tell you more than that or I would have to kill ya. Time for lunch. btw... Yes, we are all freaking genious's! ;) Justin Hansen -- Uhlig Communications Systems Engineer -- [EMAIL PROTECTED] 913-754-4273 -- -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:56 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Changing the subject Don't you people have jobs?!!! Ya know with all this activity I think Ryan is going to be expecting each and everyone of us at the next meeting. Just the other day I was thinking: everyone in Kansas City who programs ColdFusion must be freaking genious's since no one was posting for help. haha Well I am anyway ;) On a more serious note, I recently came across a CF opportunity that I passed up, but if anyone is interested it was a work from home CF position. It was a salaried position but plan on working about 60 hours a week from the sounds of it. Unfortunately, Ive got 3 kids and really, would you want to stay home all day with that? (Actually if you email me, Ill tell you why I didnt take it and you can pursue it or not) Misty -- Original Message -- From: Justin Hansen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:41:27 -0500 cf_joking Oh, well fine then... shall we keep the NULL conversation going? 1. Um, it was a CF question. (see original post) 2. What solution did Mike use? Come on, we all want to know. /cf_joking cf_for_real 3. I agree with Misty. 4. UDFs are cool. 5. Just having some fun here /cf_for_real Hey Misty, Did you know I can throw stuff at Matt for you from where I sit? We are working together again but, Matt is still Mr. Fusebox. -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... LOL I think its great! Was getting a little dusty in my KCFusion inbox. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:23:20 -0500 Geez, do you think this thread has gone on way to long or is it just me? Honestly, I think the original question may have been a SQL question, not a CF question. ;-) -glenn __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] Changing the subject
Ok way to many emails asking why I didnt take it, so let me just say this once. The pay was not great. Even Sprint's bill rate is higher than this and we all know what they have done to their bill rate lately. Misty -- Original Message -- From: Justin Hansen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 12:12:32 -0500 I heard about that job a few months ago guess they are still looking. Too bad I like this job so much. My top secret project rocks! Can't tell you more than that or I would have to kill ya. Time for lunch. btw... Yes, we are all freaking genious's! ;) Justin Hansen -- Uhlig Communications Systems Engineer -- [EMAIL PROTECTED] 913-754-4273 -- -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:56 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] Changing the subject Don't you people have jobs?!!! Ya know with all this activity I think Ryan is going to be expecting each and everyone of us at the next meeting. Just the other day I was thinking: everyone in Kansas City who programs ColdFusion must be freaking genious's since no one was posting for help. haha Well I am anyway ;) On a more serious note, I recently came across a CF opportunity that I passed up, but if anyone is interested it was a work from home CF position. It was a salaried position but plan on working about 60 hours a week from the sounds of it. Unfortunately, Ive got 3 kids and really, would you want to stay home all day with that? (Actually if you email me, Ill tell you why I didnt take it and you can pursue it or not) Misty -- Original Message -- From: Justin Hansen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:41:27 -0500 cf_joking Oh, well fine then... shall we keep the NULL conversation going? 1. Um, it was a CF question. (see original post) 2. What solution did Mike use? Come on, we all want to know. /cf_joking cf_for_real 3. I agree with Misty. 4. UDFs are cool. 5. Just having some fun here /cf_for_real Hey Misty, Did you know I can throw stuff at Matt for you from where I sit? We are working together again but, Matt is still Mr. Fusebox. -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 11:33 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] checking for nulls... LOL I think its great! Was getting a little dusty in my KCFusion inbox. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 11:23:20 -0500 Geez, do you think this thread has gone on way to long or is it just me? Honestly, I think the original question may have been a SQL question, not a CF question. ;-) -glenn __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL
Re: [KCFusion] deletes on database?
Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc design standards that change frequently I think the extra overhead of standardizing and separating the layers adds significant complexity. However, I would love to hear from those who have used this method in large, formal design groups. It may be the way to go. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adaryl Wakefield Sent: Wednesday, September 11, 2002 10:10 PM To: [EMAIL PROTECTED] Subject: [KCFusion] deletes on database? I once saw a job announcement that said something to the effect. ..no deletes on the database will be allowed. All deletes are done via XML... At the time I just raised my eyebrow and went on but now I'm kinda curious if anybody can shed some light on what exactly they meant. I only have an academic understanding of XML and a small one at that. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] deletes on database?
I generally use stored procedures unless a cached query would be appropriate. (i.e. populating dropdowns that don't change often) -Original Message- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 12:59 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] deletes on database? Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc design standards that change frequently I think the extra overhead of standardizing and separating the layers adds significant complexity. However, I would love to hear from those who have used this method in large, formal design groups. It may be the way to go. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adaryl Wakefield Sent: Wednesday, September 11, 2002 10:10 PM To: [EMAIL PROTECTED] Subject: [KCFusion] deletes on database? I once saw a job announcement that said something to the effect. ..no deletes on the database will be allowed. All deletes are done via XML... At the time I just raised my eyebrow and went on but now I'm kinda curious if anybody can shed some light on what exactly they meant. I only have an academic understanding of XML and a small one at that. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives
Re: [KCFusion] deletes on database?
Well I know some that use stored procedures for everything. For me, I try to use them only when things get complex. For instance, Im writing an application that goes into the database checks who a shipper is based on a mailstop, based on that it does another query, takes the result of that query and goes into another database pulls out the next tracking number then calls another Oracle function within it. So you can see the more jumping around i have do, the more it makes sense to do it on the Oracle box instead. The other reason regardless of what makes sense, is some companies force you to put everything into stored procedures or functions no matter what. There are a lot of companies now moving to not letting CF programmers write SQL statements and instead having database guys do it because they are more efficient in writing SQL (ya I dont buy that either) but it is thought to be better. Make the database better by letting the people who specialize in it write the queries. This makes sense I suppose but its a big increaser of development time. Ive literally sat here twiddling my thumbs for hours waiting on my DB guy to come back and load my oracle function for me to test it. it sucks. But thats company processes at work! :) Misty -- Original Message -- From: Adaryl Wakefield [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 12:58:32 -0500 Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc design standards that change frequently I think the extra overhead of standardizing and separating the layers adds significant complexity. However, I would love to hear from those who have used this method in large, formal design groups. It may be the way to go. Ryan -Original Message- From: [EMAIL PROTECTED]
Re: [KCFusion] deletes on database?
I (personally) find using stored procedures instead of simple queries to be a nuisance for anything but large, cross-platform projects. Instead of replacing simple queries with stored procedures, you can just use cfqueryparam to get the same performance benefit (query plan reuse) in SQL Server or Oracle. --Daryl Banttari Macromedia - Original Message - From: Adaryl Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:58 PM Subject: Re: [KCFusion] deletes on database? Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc design standards that change frequently I think the extra overhead of standardizing and separating the layers adds significant complexity. However, I would love to hear from those who have used this method in large, formal design groups. It may be the way to go. Ryan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Adaryl Wakefield Sent: Wednesday, September 11, 2002 10:10 PM To: [EMAIL PROTECTED] Subject: [KCFusion] deletes on database? I once saw a job announcement that said something to the effect. ..no deletes on the database will be allowed. All deletes are done via XML... At the time I just raised my eyebrow and went on but now I'm kinda curious if anybody can shed some light on what exactly they meant. I only have an academic understanding of XML and a small one at that. A. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise..
RE: [KCFusion] deletes on database?
Ha!! Some of the CF developers on my team are better SQL writers than some DBAs I know.!! We also use stored proc for complex situations like Misty mentioned. -Betty -Original Message- From: Misty Woodward [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 12, 2002 1:35 PM To: [EMAIL PROTECTED] Subject: Re: [KCFusion] deletes on database? Well I know some that use stored procedures for everything. For me, I try to use them only when things get complex. For instance, Im writing an application that goes into the database checks who a shipper is based on a mailstop, based on that it does another query, takes the result of that query and goes into another database pulls out the next tracking number then calls another Oracle function within it. So you can see the more jumping around i have do, the more it makes sense to do it on the Oracle box instead. The other reason regardless of what makes sense, is some companies force you to put everything into stored procedures or functions no matter what. There are a lot of companies now moving to not letting CF programmers write SQL statements and instead having database guys do it because they are more efficient in writing SQL (ya I dont buy that either) but it is thought to be better. Make the database better by letting the people who specialize in it write the queries. This makes sense I suppose but its a big increaser of development time. Ive literally sat here twiddling my thumbs for hours waiting on my DB guy to come back and load my oracle function for me to test it. it sucks. But thats company processes at work! :) Misty -- Original Message -- From: Adaryl Wakefield [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 12:58:32 -0500 Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc
Re: [KCFusion] deletes on database?
Folks, One of the chief reasons for using stored procedures is to make applications more secure. Girish Daryl Banttari [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: Re: [KCFusion] deletes on database? CF-List-owner@kcf usion.org 09/12/02 01:33 PM Please respond to CF-List I (personally) find using stored procedures instead of simple queries to be a nuisance for anything but large, cross-platform projects. Instead of replacing simple queries with stored procedures, you can just use cfqueryparam to get the same performance benefit (query plan reuse) in SQL Server or Oracle. --Daryl Banttari Macromedia - Original Message - From: Adaryl Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:58 PM Subject: Re: [KCFusion] deletes on database? Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any
Re: [KCFusion] deletes on database?
See that i knew. I have been diving though my libary all day for a better explantion though. Care to elaborate if you have time? The only security issue that i am aware of is the url attack which can be defended with cfqueryparam. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:55 PM Subject: Re: [KCFusion] deletes on database? Folks, One of the chief reasons for using stored procedures is to make applications more secure. Girish Daryl Banttari [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: Re: [KCFusion] deletes on database? CF-List-owner@kcf usion.org 09/12/02 01:33 PM Please respond to CF-List I (personally) find using stored procedures instead of simple queries to be a nuisance for anything but large, cross-platform projects. Instead of replacing simple queries with stored procedures, you can just use cfqueryparam to get the same performance benefit (query plan reuse) in SQL Server or Oracle. --Daryl Banttari Macromedia - Original Message - From: Adaryl Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:58 PM Subject: Re: [KCFusion] deletes on database? Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that Stored Functions shine in, is with code re-use. The function I wrote is to be used across 3 systems. Which means, I only have to change it in one place and I can manage all 3 sites with it. Misty -- Original Message -- From: Glenn Crocker [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] Date: Thu, 12 Sep 2002 10:50:12 -0500 MessageI generally don't do any JOINs in my CF code, instead using queries/views to accomplish them. (Sometimes, when a parameter needs to be way inside a JOIN, I'll put one in CF.) I haven't done the full-on stored procedure architecture, but most of my projects are just one or two developers, so it's not a big team thing with lots of turnover. -glenn -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ryan Hartwich Sent: Wednesday, September 11, 2002 10:28 PM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] deletes on database? Adaryl, Somewhere I interviewed or spoke with someone about this topic. It was my understanding that the individual coders being employed were generally not allowed to do any form of insert/update/delete into the database through their code. They were however permitted to write Select statements to tables and/or views. The coders were given a set of API calls utilizing XML services internally to do the direct DB manipulation. The idea was to force data integrity and consistency by only allowing data to be modified through approved prebuilt modules. A permutation of this would be to not permit inline DB calls in your CF code and to call all DB statements via stored procedures. I have heard this speeds up development, improves reusability, and quality. I'm a bit skeptical of this however. I have spent a few years writing code as the primary developer and write my SQL code directly inside of my CF pages. At least for small development teams with ad-hoc design standards that change frequently I think the extra overhead of standardizing and separating the layers adds
Re: [KCFusion] deletes on database?
Adaryl, In short, by hiding (or not letting have access to) the details of manipulations/information that is being done inside of the stored procedure you have prevented its possible misuse (misuse can mean lot of issues such as leaking of secure information, database corruption etc.). Girish Adaryl Wakefield To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: Sent by: Subject: Re: [KCFusion] deletes on database? CF-List-owner@kcf usion.org 09/12/02 03:28 PM Please respond to CF-List See that i knew. I have been diving though my libary all day for a better explantion though. Care to elaborate if you have time? The only security issue that i am aware of is the url attack which can be defended with cfqueryparam. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:55 PM Subject: Re: [KCFusion] deletes on database? Folks, One of the chief reasons for using stored procedures is to make applications more secure. Girish Daryl Banttari [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: Re: [KCFusion] deletes on database? CF-List-owner@kcf usion.org 09/12/02 01:33 PM Please respond to CF-List I (personally) find using stored procedures instead of simple queries to be a nuisance for anything but large, cross-platform projects. Instead of replacing simple queries with stored procedures, you can just use cfqueryparam to get the same performance benefit (query plan reuse) in SQL Server or Oracle. --Daryl Banttari Macromedia - Original Message - From: Adaryl Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:58 PM Subject: Re: [KCFusion] deletes on database? Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database calls. When I first started doing it, I hated it. Honestly, I still hate it. From a development standpoint, as far as time goes, i would say it takes longer than just writing it directly into CF. When Im coding in CF I just write out my CF query and move on. When writing Stored Functions your 8 line query turns into a huge function where you have to declare varaibles, check for variabls, create the function, create your IN Variables, write in your return values, etc. The part that
Re: [KCFusion] deletes on database?
Adaryl, Here's my $.02 Chapter 32 (Working With Stored Procedures), page 1057, in the book Web Application Construction Kit Fourth Edition (Ben Forta and Nate Weiss), there is a pretty good description about why performance may be enhanced by using stored procedures: Depending on the situation, using stored procedures can often cause an application to perform better. For two basic reasons, the use of stored procedures will speed your application. First, most database systems do some type of precompilation of the stored procedure so that it runs more quickly when it is actually used. For instance, Microsoft SQL Server makes all its performance-optimizing decisions (such as what indexes and which join algorithms to use) the first time a stored procedure is run. Subsequent executions of the stored procedure do not need to be parsed and analyzed, which causes the procedure to be run somewhat more quickly than if you executed its SQL statements in an ad hoc fassion every time. Generally, the more steps the procedure represents, the more of a difference this precompilation makes. Oracle servers do something very similar. Second, if you compare the idea of having one stored procedure verses several CFQUERY and CFIF tags in a template, the stored procedure approach is often more efficient because less communication is necessary between ColdFusion and the database server. Ok - enough stuff from a book. There are dozens of things to consider when deciding upon whether or not to use stored procedures or query's directly in the cf code. One can make an argument that once a stored procedure is written against a table, everyone can re-use that stored procedure. If the company is big enough to have both a SQL team and front end team, then the duties can be broken down easier. Our entire application is written using CFSTOREDPROC calls exclusively, and all of the stored procedures are done in MS SQL Server. There is no CFQUERY tags. Some of our searches are accessing tables in excess of 18 million records. One advantage from a security standpoint is that we do not have to grant any access to the database other than the EXECUTE privilege on the stored procedure. No generic insert, update, delete rights are given to individual users for the tables. So in the event that someone did gain access to your database they could still just execute stored procedures. If all the rights were there they could do select, insert, delete statements directly against the tables. So database integrity and security are greatly enhanced. Chris --- Adaryl Wakefield [EMAIL PROTECTED] wrote: See that i knew. I have been diving though my libary all day for a better explantion though. Care to elaborate if you have time? The only security issue that i am aware of is the url attack which can be defended with cfqueryparam. A. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 2:55 PM Subject: Re: [KCFusion] deletes on database? Folks, One of the chief reasons for using stored procedures is to make applications more secure. Girish Daryl Banttari [EMAIL PROTECTED]To: [EMAIL PROTECTED] cc: Sent by: Subject: Re: [KCFusion] deletes on database? CF-List-owner@kcf usion.org 09/12/02 01:33 PM Please respond to CF-List I (personally) find using stored procedures instead of simple queries to be a nuisance for anything but large, cross-platform projects. Instead of replacing simple queries with stored procedures, you can just use cfqueryparam to get the same performance benefit (query plan reuse) in SQL Server or Oracle. --Daryl Banttari Macromedia - Original Message - From: Adaryl Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 12:58 PM Subject: Re: [KCFusion] deletes on database? Hey why is it every time I post something it generates an avalanche of activity. :-) Its like you guys forget this thing exist. So (and anybody can field this one) I was studying how to write stored procedures in SQL Server last night I was like..gee. thats a lot of freaking work. So what would you say was the most appropriate time to use stored procedures vs. just putting it on the page. A. P.S. As a matter of fact Misty, no, I don't have a jobI'm a consultant! - Original Message - From: Misty Woodward [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 12, 2002 10:59 AM Subject: RE: [KCFusion] deletes on database? In one of the projects I am working on now, they use Oracle stored functions only for database
[KCFusion] Possibilities for the next meeting
Glad someone asked! I have two ideas and was hoping to have the meeting next week, but at this rate I doubt it will happen. 1) Demonstration on installing/configuring the ActiveEdit (or similar) custom tags that make HTML/WYSIWYG editors available in a web browser. Then how to insert them into your CF programs, retrieve and save the data for later html display. 2) Discussion and demonstration of a system for sales reps to pre-engineer a material handling system. Website (for private use of sales reps) prompts for system design information, dynamically asks different questions, and then creates a parts list to 'build' the system. Parts list is saved in CF and then a Perl program running in Linux runs, calls an API for a product called PDF-Lib that will generate a PDF file on the fly. End result, sales reps have a 10 page unique bid proposal created on the fly. System uses the 'zlayer' attribute in HTML/CSS to layer html on top of graphics, JavaScript, perl, Postures (database) PDF-Lib (www.pdflib.org) running on Linux. As it stands now, we have two possible venues (if available when we request it) A) one in an office in southern Overland Park with a capacity of about 10 B) the other our normal meeting space in the Admin building of UMKC (near the Plaza), capacity of 10 or 50+, room specific. I have not received confirmation of willingness nor availability for #1. I am pretty sure my employers would have no problem with me demonstrating #2 but would need to check. To all: Do you prefer 1 or 2, A or B, and if possible, next Tuesday or Wednesday. Please indicate if you intend to come if the topic/location/date would work for you, Thanks Ryan To those of you who have not participated in our (usually) monthly meetings. For the past year+ the meetings have typically been informal with a planned presentation lasting 30-60 minutes and constant QA and side conversations during and afterwards. It is a great way for you to meet other local CF programmers, hear about projects, methods of coding and performing work, etc. The attendance has usually hovered between 4-10 people though I am attempting to raise this. __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
