This is not a question for web2py-users (if you need this you'll have to use it once in a while I hope, it's teeeeerribily slow).
For having this work with web2py you should find a way to infere sql tables to models for using web2py, and I don't think something like this can be done with the standard DBAPI without "tricky" queries watching over dbo.systables & co. You should stick to some well-known implementations directly in T-SQL. Google is always your friend. <[email protected]>http://stackoverflow.com/questions/709120/ Il giorno lunedì 30 luglio 2012 17:07:15 UTC+2, Ramos ha scritto: > > Its not that mass searching but easy to script a find that having to open > each table and look at it to find a value. > There are about 120 tables. > > > > 2012/7/30 Willoughby <[email protected]> > >> If you need to do mass searching on a big database, I'd keep it on >> SQLServer and use the Full Text Search service. >> http://msdn.microsoft.com/en-us/library/cc721269%28SQL.100%29.aspx >> >> On Monday, July 30, 2012 7:01:33 AM UTC-4, Ramos wrote: >>> >>> Hello i have a problem >>> i have a big sqlserver database called MXPROD with dozens of tables. >>> I need to find tables that have 01533 in one of the field of the table. >>> this field in one of the tables was named eqnum but i dont know if other >>> tables use the same name for the field. >>> >>> How can i script this using python? >>> >>> Thank you >>> >>> António >>> >> -- >> >> >> >> > > --
