Re: Inserting Null Value or String Value

>>>>> "Keary" == Keary Suska <hierophant(at)pcisys(dot)net> writes:

Keary> If I surround the date with single quotes it should be
Keary> fine, but I can't do that when I want to insert a null
Keary> value. I know that I can do an "IF <use quotes> ELSE
Keary> <don't use quotes>" in the SQL string, by I am entering
Keary> many values and this would really get messy. I was hoping
Keary> that there was a better solution. Thanks for any help.

Why is this too difficult? You *are* doing some sort of input
validation before you send the data to posgres aren't you?

roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
roland(at)astrofoto(dot)org Forest Hills, NY 11375