Problem with nulls

[Bob]

I am passing values from a form to an asp page that has
the code to update underlying records with all changes.
How can I update blank fields that are remaining blank or
may have been just blanked out?

The updates are bombing and it tells me I have to assign
default input parameters for all fields. I don't want
fields filled with info when they don't need info.

Anyone have a workaround for this?

[Robert Lambrecht]

No I have not tried that, but don't think that will work. The input
default parameters have to be defined on the asp page were generated
using the database interface wizard. By stepping through the database
results to tweek them, there is a point where you can select options and
it allows you to define the defaults for all the fields.

If I just typed in dbull.value I'm sure it would take it as a text
string and enter that into a field that was passed as empty.

I was just reading a Frontpage 2002 book and noticed the use of % as a
default for search forms and may try that. I just don't know if there is
anything that can be stuck in that box to pass nothing along.

Maybe I need to regroup and dump data directly into the database and
accept the funky update message that frontpage generates. It of course
comes across without any formatting or theme.

I'll give what you suggested a shot, but am not very optimistic based on
what is has done to me so far.

Thanks for your rapid response.

Bob



*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!