Page 1 of 1

adding a non null invisible value in field

Posted: Wed May 21, 2003 3:01 am
by jarow
How can I do the following?

I need a default value for a field , something like a space or something similar, that would act as a non-null value for a field, yet would not yield visible results.

Does that make any sense ?

In other words, a default value that the database thinks is a real value but it is not visible.

thanks

Jarow

Posted: Wed May 21, 2003 5:50 am
by ckuipers
You can set default values when creating the tables. When no values are added to that column, it will default. I assume (haven't tried it though) you can default to a space, or maybe even a blank.

Besides that you can have PHP edit your defaults (NULL) to process them before parsing them. Have you tried parsing these NULLs as I think they don't appear...