[thelist] ASP/SQL date database question
rudy limeback
r937 at interlog.com
Fri Jul 7 00:54:30 CDT 2000
>I've tried using null as a replacement value,
>but haven't had much luck
hi larry
is your access field defined to allow nulls? then you should be able to do
it this way --
update yourTable
set yourColumn = null
access defines its null fields with Required = No in the table design
thingie (sorry, i dunno the technical name for that thingie where you
design the
table)
also, sorry again, i dunno how to write the twenty or so asp statements
that you need to feed the sql statement to the database using asp (no
offence aardvark, scott, and/or all you other asp dudes and dudettes) -- in
cold fusion you'd simply wrap a <cfquery> ... </cfquery> around the sql and
you're done ;o)
rudy.limeback
r937.com
evolt.org
More information about the thelist
mailing list