Re: Inserting Null Value or String Value

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



>>>>> "Keary" == Keary Suska <hierophant@xxxxxxxxxx> 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@xxxxxxxxxxx                     76-15 113th Street, Apt 3B
roland@xxxxxxxxxxxxx                       Forest Hills, NY 11375


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux