I would like to do this:
function insertVal() {
var inVal = NULL;
if (form.ITEM_ID is 1) {
inVal = form.TYPE_ID;
}
return inVal;
}
But, when I use NULL in CFSCRIPT, I get an error (this is part of creating
an INSERT query).
I need that keyword NULL in the query when certain conditions are met ... if
I just do inVal='' (an empty string), I get an error. So my only other
option seems to be to set inVal=0, which sort of works, but it's a kludge is
not really what I want. It will create progmatic problems down the road.
H.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Owens
Internet Operations Coordinator
InsideVC.com/Ventura County Star
[EMAIL PROTECTED]
AIM: GoCatGo1956
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
