@Billy - I think you are actually answering the question correctly : those are 4 different writes to the db when only two would have sufficed. Sometimes, complexities are borne of design flaws. -- Ndungi Kyalo biblia.kenya.or.ke On Wed, Jan 27, 2010 at 4:42 PM, Billy <billyx5@gmail.com> wrote:
this is in SQL ,yes there is a reason as to why the month and year occupy
the separate column,the two columns for month and year will be used to populate the effective_date column,the datetime can be in any format most preferable date-month-year.
@Esther - Not really answering the question here but why would you use two different columns to update the third as opposed to just populating it with the required date in the first place. 0_o?
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks ------------ Skunkworks Server donations spreadsheet
http://spreadsheets.google.com/ccc?key=0AopdHkqSqKL-dHlQVTMxU1VBdU1BSWJxdy1f... ------------ Skunkworks Rules http://my.co.ke/phpbb/viewtopic.php?f=24&t=94 ------------ Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general