[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