Classic ASP Discussion - ASP :adding to ACCESS Database from a for

Print Page | Close Window

ASP :adding to ACCESS Database from a for

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3420
Printed Date: 29 March 2026 at 12:03pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: ASP :adding to ACCESS Database from a for

Posted By: nirmal
Subject: ASP :adding to ACCESS Database from a for
Date Posted: 10 June 2003 at 8:18am

hi,

i followed the method given by web wiz guide way to add form data into an access database using ASP..... i'm encountering a problem ...when one of the fields is not entered it does not add to t he database ...so all the fileds should be entered always ...can a ny body suggest a way to save a NULL charcter to the datbase when no field is enterd........

Thanks,

-------------
AIm at the Sky u might not reach it but u will fly higher

Replies:

Posted By: stephen
Date Posted: 10 June 2003 at 8:51am

You need to expanciate further. Your post could mean two things, Are you trying to save the function NULL in the database, cos in that case access would just live it blank i think, unlike sql Server that puts the value NULL in the cell. However if you are just trying to write the character as you said, then you can try this:

strFieldValue = Request.Form("fieldName")

If strFieldValue ="" Then

strFieldValue = "NULL"

End if

Then write strFieldValue into the database.