I can think of two options although there may be some magic in
SQLObject that I'm not aware of:
1) Use the queryAll function to run an ad-hoc query.
File._connection.queryAll("SELECT ....")
2) Create FileDirectory(SQLObject) and do the related join manually so
you can access FileDirectory with SQLBuilder.
Also, it's a good idea to not write you sql joins like you did in that
statement. The more standard way would be:
SELECT directory.name, file.name
FROM file
JOIN directory_file ON file.id = directory_file.file_id
JOIN directory ON directory_file.directory_id = directory.id
WHERE file.name LIKE 'README%'
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
