Bor_type_updt.pl
Submitted by Brian Crampton on Fri, 2007-02-09 18:40.
I'm doing some work with the bor_type_updt.pl script, which works fine. The problem I'm having is with some Date_of_births, which appear blank, but aren't.
From what I can gather, blank DOBs are stored in the system as 01/01/1970 (they just don't display in alto). However when I do a BusObj query showing DOBs I can see all these 01/01/1970s - null entries, but I also get quite a few showing as 'blank'.
How can I do a bit of SQL which set's these 'blank' ones to null?
I've tried with date_of_birth='', but that doesn't work.
Cheers
Mark Hughes
http://www.wirral-libraries.net/
http://www.stembystem.co.uk/
date of birth values
The 01/01/2970 00:00 datetime is the default value held in the database. This value won't be displayed in Alto. This is not a NULL value as NULL has a particular meaning in the database.
However the blank values you see in the report are actually held as NULLs in the database. If you look in the BusinessObjects microcube they will be shown as #EMPTY values although the report will not display anything.
To select these rows in SQL it would be DATE_OF_BIRTH=NULL
Brian Crampton
Developer, Talis
Thanks
I was getting confused (easily done...)
I understand now. Thanks.
http://www.wirral-libraries.net/
http://www.stembystem.co.uk/