Re: oraperl: inserting null dates
From: Michael Nolan <nolan_at_helios.unl.edu>
Date: 12 Oct 1993 20:15:42 GMT
Message-ID: <29f39e$fvv_at_crcnis1.unl.edu>
Date: 12 Oct 1993 20:15:42 GMT
Message-ID: <29f39e$fvv_at_crcnis1.unl.edu>
ttg242_at_newton.sps.mot.com (David Thornewill von Essen) writes:
>Has anyone found an elegant workaround other than inserting a dummy date
>and then updating all rows with col = NULL where col = dummy date.
Yes, make sure that the variable referenced in the bind statement is undefined. (undef $date_var;)
Remember, though, that using the variable (in a print statement, for example) causes it to be defined and empty again.
--- Michael Nolan, Sysop for the DBMS RoundTable on GEnie nolan_at_notes.tssi.com, dbms_at_genie.geis.com (posted from nolan_at_helios.unl.edu)Received on Tue Oct 12 1993 - 21:15:42 CET