On 23/04/2004 11:36 mike wrote:
Is it possible to to the following
I have tables which are updated via webpage (perl) with fields of type int and date (all nullable). If the values are blank the entire insert fails, with a wrong type error.
Is there any way to stop this behaviour so that the valid information is allowed,but the blank values get ignored.
By blank, I assume you mean a zero-length string or the request parameter being absent? I think you need to detect these conditions in your perl program anf construct the SQL accordingly.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
