<cfif NOT (isDefined("form.notqualifiedId") and
IsMSSQLGUID(form.notqualifiedId))>
<cfset form.notqualifiedId = "NULL">
</cfif>
then in the sql statement...
update accounts set
NOTQUALIFIEDID = <cfif form.notqualifiedId is "NULL">NULL,
<cfelse>'#form.notqualifiedId#',</cfif>
where accountNumber = 1
:) wow self, good stuff.
(apart from cfqueryparam, but im preventing bad data in the capturing of
the data)
thanks anyway, good night.
....tony
Tony Weeg
sr. web applications architect
navtrak, inc.
[EMAIL PROTECTED]
410.548.2337
www.navtrak.net
-----Original Message-----
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 01, 2004 11:47 PM
To: CF-Talk
Subject: mssql NULL
this errors.
<cfif NOT (isDefined("form.notqualifiedId") and
IsMSSQLGUID(form.notqualifiedId))>
<cfset form.notqualifiedId = NULL>
</cfif>
I want to send null to the database as the value.
can this be done, so that I can then, in turn, do this.
update accounts set notQualifiedId = #form.notQualifiedId# where
accountNumber = 1
thanks.
....tony
r e v o l u t i o n w e b d e s i g n
[EMAIL PROTECTED]
www.revolutionwebdesign.com
its only looks good to those who can see bad as well
-anonymous
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
