| From: | Charley Tiggs <charley(at)xpressdocs(dot)com> |
|---|---|
| To: | operationsengineer1(at)yahoo(dot)com |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Insert Text |
| Date: | 2006-01-31 08:59:20 |
| Message-ID: | 43DF26E8.1020001@xpressdocs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)yahoo(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Davis | 2006-01-31 11:57:04 | Re: put text list into table form |
| Previous Message | Bruno Wolff III | 2006-01-31 05:49:01 | Re: Upgrade to PG 8 before starting major development? |