Option Value = NULL

[GP3000]

I have a drop down box with several selections that when submitted, update a
SQL Server backend database. I'd also like to have an option in the drop down
box that allows me to pass a NULL value back to the database. A sort of
"reset" if you will.

I've tried the code below, but it just writes the word "NULL" to the
database...not actually a <NULL> value.

<select name="select">
<option value="NULL">No Value</option>
<option value="1">Bill</option>
<option value="2">Chris</option>
<option value="3">John</option>
</select>

Any help would be greatly appreciated!! Thanks!!

[Brandon Taylor]

<option value="">No Value</option>

"GP3000" <webforumsuser@macromedia.com> wrote in message
news:d3m2dh$n6v$1@forums.macromedia.com...

>I have a drop down box with several selections that when submitted, update
>a
> SQL Server backend database. I'd also like to have an option in the drop
> down
> box that allows me to pass a NULL value back to the database. A sort of
> "reset" if you will.
>
> I've tried the code below, but it just writes the word "NULL" to the
> database...not actually a <NULL> value.
>
> <select name="select">
> <option value="NULL">No Value</option>
> <option value="1">Bill</option>
> <option value="2">Chris</option>
> <option value="3">John</option>
> </select>
>
> Any help would be greatly appreciated!! Thanks!!
>

[GP3000]

I've tried this solution to no avail...it does not actually pass a NULL value
back to the database...the record is actually updated with a "space". So if
you query on the table for all NULLs, the record does not come back. If you
query on a "space" it comes back.

[Unregistered]

Hi, what you can do is set a default value like "0" then before updating the database, make an IF Statement that checks for that "0", then replace it with NULL.

It's something like: <option value="0">No Value</option>

then before updating the database (this is just pseudo-code, modify as needed):
noValue = dropdownlist.value;
if (noValue == "0")
{
noValue = null;
}

Then, update database. You may need to replace the "null" to a null SQL type of the programming language that you're using.

Hope you pull it off!

Disso