RE: Urgent help needed!!! How to check null value in List of controls

2004-10-07 Thread Pascal Peters
Look at cfstoredproc and cfprocparam. 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 > contro

Re: Urgent help needed!!! How to check null value in List of controls

2004-10-07 Thread Keyur Mistry
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. exec sp_insert_allotment_history_daywise ##, ##, ##, ## [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: Urgent help needed!!! How to check null value in List of controls

2004-10-07 Thread Keyur Mistry
Hi  Pascal, Thanks, for giving me reply!!! I want to pass value to the stored procedure not table. Is following code are correct or require any changes. exec sp_insert_allotment_history_daywise ##, ##, ##, ## [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe]

Re: Urgent help needed!!! How to check null value in List of controls

2004-10-07 Thread Keyur Mistry
>I lost a few #s copying. In the name attributes of the 2nd & 3rd textbox > >Pascal > >could >> code the cfqueryparams like this: >> >> null="#YesNoFormat(Len(form['cutoff_' & i]))#"> >> >> Pascal >> [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Dona

RE: Urgent help needed!!! How to check null value in List of controls

2004-10-07 Thread Pascal Peters
I lost a few #s copying. In the name attributes of the 2nd & 3rd textbox Pascal > -Original Message- > From: Pascal Peters [mailto:[EMAIL PROTECTED] > Sent: 07 October 2004 15:18 > To: CF-Talk > Subject: RE: Urgent help needed!!! How to check null value in List of >

RE: Urgent help needed!!! How to check null value in List of controls

2004-10-07 Thread Pascal Peters
I'm not 100% certain what you want to do, but have a look at this: form: value="#twebroomtypes_id#">#roomtype# MAXLENGTH="5" VALUE=""> MAXLENGTH="5" VALUE=""> MAXLENGTH="5" VALUE=""> action page INSERT INTO tbl (twebroomtypes_id,fitrate,allotment,cutoff) VALUES( , value=