Eric Dalquist wrote:
I've tested with every database listed except MS SQL Server but the
Joins section in their documentation seems to imply they support the
ANSI SQL syntax for joins as well:
http://msdn2.microsoft.com/en-us/library/aa213233(SQL.80).aspx
Awesome.
Nothing else jumped out at me.
drew
-Eric
Drew Wills wrote:
Eric Dalquist wrote:
I'd like to make some changes to the import/export scripts as
outlined here: http://www.ja-sig.org/issues/browse/UP-1897
The base idea is that currently importing a .user without also
importing a corresponding .layout results in an entry in UP_USER that
cannot log in since the user's profile is imported as well even
though the profile may require a layout.
The change is moving the <profile> information from the .user files
into the .layout files. This would result in a .user that can be
imported and function even if that user has no layout. Entities
exported from 2.6 will still function as the 2.6 format import
scripts are not touched by the change.
As we discussed last week, I feel these changes are desirable and
would be happy to see them make it, all else being equal.
Looking at the .patch file, I see a lot of "LEFT JOIN" expressions in
the SQL statements -- are you confident that these will run on all the
common RDBMS platforms?
I'm not a SQL guru, and I can't remember which vendors support and
don't support specific syntax. I mostly just try to keep the SQL
simple in uPortal.
Can anyone chime in on the subject of "LEFT JOIN" on the following DB
flavors, either all of them or individually?
- hsqldb
- postgresql
- oracle
- *MS SQL Server*
- mysql
drew wills
--
Andrew Wills
UNICON, Inc.
Office: (480) 558-2476
http://code.google.com/p/cernunnos/
--
Join your friends and colleagues at JA-SIG 2008 - "Higher Education Solutions: The
Community Source Way!"
April 27th - 30th, 2008 in St. Paul, Minnesota USA
Featuring CAS, DSpace, Fedora, Fluid, Internet2, Kuali, Sakai, uPortal, and
more!
Information/Registration at:
http://www.ja-sig.org/conferences/08spring/index.html
Subscribe to the conference blog, The Community Source Way
http://jasig2008.blogspot.com, for news and updates about the event.
Join the Conference networking site at http://ja-sigspring08.crowdvine.com/
You are currently subscribed to [email protected] as: [EMAIL
PROTECTED]
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/uportal-dev
