NULL insert

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

NULL insert

Patrick Larkin-2
Lasso 8.5

If I have a drop down selection like so:

<select name="2a1" class="span1">
  <option value="" >N</option>
  <option  value="0" >0</option>
  <option  value="1">1</option>
  <option  value="2">2</option>
  <option  value="3">3</option>
</select>

And the value is sent to an inline for insertion, how would I get the "N" option to insert a NULL value or leave the default NULL value as is?  

Do I have to do it in a SQL statement?

Thanks.



Patrick Larkin
Information Systems
Bethlehem Area School District
https://www.beth.k12.pa.us





#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>
Reply | Threaded
Open this post in threaded view
|

Re: NULL insert

Tim Taplin
I believe that the form action_params will not contain the empty variable. So, you should be able to check whether action_param('2a1') == '' and then do whatever you want in your sql to manage that field.

Tim Taplin

On Nov 26, 2013, at 1:38 PM, Patrick Larkin <[hidden email]> wrote:

> Lasso 8.5
>
> If I have a drop down selection like so:
>
> <select name="2a1" class="span1">
>  <option value="" >N</option>
>  <option  value="0" >0</option>
>  <option  value="1">1</option>
>  <option  value="2">2</option>
>  <option  value="3">3</option>
> </select>
>
> And the value is sent to an inline for insertion, how would I get the "N" option to insert a NULL value or leave the default NULL value as is?  
>
> Do I have to do it in a SQL statement?
>
> Thanks.
>
>
>
> Patrick Larkin
> Information Systems
> Bethlehem Area School District
> https://www.beth.k12.pa.us
>
>
>
>
>
> #############################################################
> This message is sent to you because you are subscribed to
>  the mailing list Lasso
> [hidden email]
> To unsubscribe, E-mail to: <[hidden email]>
> Send administrative queries to  <[hidden email]>


#############################################################
This message is sent to you because you are subscribed to
  the mailing list Lasso
[hidden email]
To unsubscribe, E-mail to: <[hidden email]>
Send administrative queries to  <[hidden email]>