Dennis Brakhane wrote: > SELECT directory.name,file.name FROM file,directory,directory_file > WHERE file_id=file.id AND directory.id=directory_id AND file.name LIKE > 'README%'; > Any suggestions?
If you're using an SQL server that supports views (like postgresql) you can use a a view: http://shiny.thorne.id.au/shiny/2006/03/views-in-sqlobject.html -- Regards, Stephen Thorne Development Engineer Scanned by the NetBox from NetBox Blue (http://netboxblue.com/) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "TurboGears" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/turbogears -~----------~----~----~----~------~----~------~--~---
