Re: Insert Text - Mailing list pgsql-novice

From Charley Tiggs
Subject Re: Insert Text
Date
Msg-id 43DF26E8.1020001@xpressdocs.com
Whole thread Raw
In response to Insert Text  (<operationsengineer1@yahoo.com>)
List pgsql-novice
In a web app, if it's a text area, the param will appear as an empty
string in PHP.  If you then pass this along to ADOdb, it'll populate the
db as an empty string.

If you don't want this behavior, then check for empty strings before
insert and substitute NULL or drop the field from the array before
insertion.

Charley

operationsengineer1@yahoo.com wrote:
> i allow my users to insert notes.  when they leave the
> note blank, "" gets inserted into the db.  is this
> expected behavior?  tia...
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org

pgsql-novice by date:

Previous
From: "Web2cad"
Date:
Subject: Re: put text list into table form
Next
From: "Ketema J. Harris"
Date:
Subject: variables outside of functions