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]