On 2/14/06, Roberto Perez <[EMAIL PROTECTED]> wrote: > >On 2/14/06, Charlie Griefer wrote: > > > >that regex will remove anything that's not a number or a decimal point. > > > >so yes, on INSERT/UPDATE, use the regex to insert only numeric values. > > > > Mmmm...I just tested it, and this is what it does: > - if there are several spaces followed by a number, it strips the spaces and > gets the number;
right...as mentioned, it will remove all characters that are non-numeric(except for a decimal point) > - if there is a comma, it strips the comma and gets the numbers; right...as mentioned, it will remove all characters that are non-numeric(except for a decimal point) > - if there are only spaces, it throws an error; > - if there is text (e.g., "n/a"), it throws an error. "it" throws an error? what is "it"? the regex? the query? what is the error? -- Charlie Griefer ================================================ "...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed." ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232304 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
