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.

 




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net