Home
The Toolkit for Online Communities
15939 Community Members, 0 members online, 2382 visitors today
Log In Register

Forum OpenACS Q&A: Response to NULL SQL issues

OpenACS Home : Forums : OpenACS Q&A : Response to NULL SQL issues : One Message

+
Posted by David Walker on
The concatenation operator || returns NULL if one of the items being
concatenated is NULL.  Your best bet is probably to make the admin_note
field default '' and update all the currently NULL fields to equal ''