[thelist] ASP/SQL date database question
L. Floyd
lfloyd at sonic.net
Sun Jul 9 15:20:26 CDT 2000
Well, my problem was due to my ignorance, just as I suspected. What was
happening was I was building string that was to be my SQL statement to
update the database. So the string had a lot of.... "MyField ='" &
MyField & "', NextField='" & Nextfield.... etc., where MyField was a
varible of some sort. What I was trying to do was something like:
DateComplete = Null
and then use DateComplete in my SQL string. Well, Null ends up looking
like nothing once it's put in a string. I ended up doing some decision
making with 'if's and just putting in the SQL string like was suggested
by someone out there:
"DateComplete=Null". Just that simple.
I wonder if I tried to set DateComplete="Null". I bet that would work.
I'll try it tomorrow.
Thanks for the help!
- larry
"L. Floyd" wrote:
>
> Forgive my ignorance, but I'm just stumped with this. I have an Access
> database that I'm updating using ASP/VBScript. One of the fields each
> record in the database is a date that initially is empty. It's simple
> enuff to put a date in there, but I'm having difficulty making that
> field blank again! Is there a way to simply remove the contents of that
> field for a given record? I've tried using null as a replacement value,
> but haven't had much luck (as I'm sitting here typing this, I just
> thought of a way to possibly use null, but I'll have to wait until I get
> to work tomorrow to try it =0).
>
> Any help will be greatly appreciated. I'll try to come up with a tip by
> tomorrow.
>
> - larry
More information about the thelist
mailing list