Re: break my regexp?

by "rudy" <r937(at)interlog.com>

Date:	Wed, 1 May 2002 23:58:08 -0400
To:	"Michael Gerholdt" <Michael.Gerholdt(at)fredonia.edu>, "hwg-techniques" <hwg-techniques(at)hwg.org>
	todo: View Thread, Original

> I'm trying to create some regexp to do syntax checking 
> on fairly simple SQL statements.

well, i don't do regexps, but are you allowing for stuff like

    select table1.foo
           , table2.bar * 2 as bartwo
      from table1
        , (select userid, count(*)
            from users group by userid ) as table2
    where table1.user=table2.userid
      
sql can be incredibly complex if you let it

of course, i guess maybe this is what you might be trying to do -- 
not let it

> Know where it has been done?

sql validator at mimer  -- http://developer.mimer.se/validator/


rudy
http://rudy.ca/

HWG hwg-techniques mailing list archives, maintained by Webmasters @ IWA