Home : Gossamer Threads Inc. : Discussion :

Gossamer Threads Inc.: Discussion: Re: [Alex] GT::SQL: Edit Log

Here is the list of edits for this post
Re: [Alex] GT::SQL
Quote:
I think that means your regex is wrong. =)

No I mean a formatted error, not a server error. When your column is set to null, if a value is entered and you want, say all digits, your regex would be:

^\d+$

...however if I left the field blank I'd get an error saying "The column 'blah' cannot contain the value ''" ..but really it can because the column is null.

I can get around it by doing:

^(?:|\d+)$

...but that's ugly Unsure

Last edited by:

Paul: Apr 4, 2003, 9:59 AM

Edit Log: