If not null asp classic

Hide a section as in don't process a section of the page if a DB field is NULL You can't "not process a page" because until you process the page you can't determine if the field is null. You can branch based on it being null, or else you'll need to use two pages, or try to accomplish a conditional include, which is more work thatn the system should do.

Binoj Antony. This discussion thread is closed Start new discussion. DB2 Database. Cannot get form to show field based on value of another field. Mobile Development. Software Development. Remote Development and Debugging Tools. How to use Nuget assembly as files with visual studio community. Ms access. Append Query trying not to add duplicate records to new table. GerardoLima: true, but then the data coming back is going to be a string anyway. A developer should know this and adjust accordingly.

If they don't then it's a classic case of putting the computer back in the box and shipping back to the supplier. Once again, the old adage of: "Never assume as it makes an ass of u and me" should be kept in mind.

Show 7 more comments. Ezeilo Uchenna Ezeilo Uchenna 71 4 4 bronze badges. Good advice, always cleaner to attempt to separate logic from presentation where possible. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. The Overflow Blog. Podcast Making Agile work for data science. Stack Gives Back Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually. Linked Related 2. Hot Network Questions. Ask a Question. How to pass null value to a column in sql server table through classic asp. Please Sign up or sign in to vote. See more: ASP. Hi everybody I have a column in my table with datatype as datetime.

But if I pass empty value means it should store null value. I know how to pass null value to a column in asp. In asp. But Im not knowing how to pass null value through my classic asp page. Can anybody please help Add a Solution. Technoses May am. Top Rated Most Recent. Accept Solution Reject Solution. This is a pretty late response, but I had this very problem and neither of these answers were right.

I spent about half an hour searching for this going through pages of Google results, and finally found it! I wanted to post it here for future reference because I think it's pretty relevant. First, you can use an SQL query to change a field to null, and you just use the string "null" in that case.

I'm a die hard JS fan, so of course I believe eval is evil, and doing the same thing with SQL queries feels wrong to me. So I needed a different way to set records to null. And I found the solution! It's as simple as using the variable "Null" in VBScript. You don't want to cast Null either, just pass in Null.

Here's what my code looks like note I'm writing this to learn, so I didn't create a permission system or anything : VB.