Also, no #s around CF tags
Pascal
> -----Original Message-----
> From: Keyur Mistry [mailto:[EMAIL PROTECTED]
> Sent: 07 October 2004 16:20
> To: CF-Talk
> Subject: Re: Urgent help needed!!! How to check null value in List of
> controls
>
> Hi Pascal,
>
> Thanks, for giving me reply!!!
>
> What if i want to pass value to the stored procedure??
>
> Is following code are correct or require any changes.
>
> <cfloop index="i" list="#twebroomtypes_id#">
>
> exec sp_insert_allotment_history_daywise
> #<cfqueryparam cfsqltype="cf_sql_numeric" value="#i#">#,
>
> #<cfqueryparam cfsqltype="cf_sql_varchar" value="#form['fitrate_' &
i]#"
> null="#YesNoFormat(Len(form['fitrate_' & i]))#">#,
>
> #<cfqueryparam cfsqltype="cf_sql_varchar" value="#form['allotment_' &
> i]#" null="#YesNoFormat(Len(form['allotment_' & i]))#">#,
>
> #<cfqueryparam cfsqltype="cf_sql_varchar" value="#form['cutoff_' &
i]#"
> null="#YesNoFormat(Len(form['cutoff_' & i]))#">#
>
> </cfloop>
>
>
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
