ALTER procedure test
(
@param as varchar(10)
)
as
IF @param IS NOT NULL
select @param
ELSE
SELECT 'MY PARAM IS NULL'
GO
<cfset blah = "">
<CFSTOREDPROC procedure="dbo.test" datasource="#DSN#">
<CFPROCPARAM cfsqltype="cf_sql_varchar" value="#blah#"
null="#IIF(LEN(BLAH) EQ 0, TRUE, FALSE)#">
<CFPROCRESULT name="result">
</CFSTOREDPROC>
<cfdump var="#result#">
OUTPUTS : 'MY PARAM IS NULL'
Scott Thornton, Programmer
Application Development
Information Services and Telecommunications
Hunter-New England Area Health Service
Phone RNH +61 2 49236078 JHH +61 2 49214193
Fax +61 2 49214191
[EMAIL PROTECTED]
>>> [EMAIL PROTECTED] 01/21/05 1:53 PM >>>
Sorry, had it the wrong way around:
<CFPROCPARAM type="In" cfsqltype="CF_SQL_VARCHAR"
dbvarname="@HL7_SOURCE"
value="" null="#iif(LEN(SOMEFILED),false,true)#">
or something like that in any case.
Darryl Lyons
To unsubscribe from this email please forward this email to
[EMAIL PROTECTED]
This email message is confidential and may be privileged. If you are not
the intended recipient
please forward the email to [EMAIL PROTECTED] and delete the
original.
ABN AMRO Morgans Limited and its associates hold or may hold securities
in the companies/trusts mentioned herein.
Any general advice included in this email has been prepared without
taking into account your objectives, financial situation or needs.
Before acting on the advice, you should consider its appropriateness or
discuss with one of our investment advisors.
ABN AMRO Morgans Limited (ABN 49 010 669 726 AFSL 235410) A Participant
of ASX Group.
A principal member of the Financial Planning Association.
---
You are currently subscribed to cfaussie as:
[EMAIL PROTECTED]
To unsubscribe send a blank email to
[EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
---
You are currently subscribed to cfaussie as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
Aussie Macromedia Developers: http://lists.daemon.com.au/
