Index: openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql 12 Jun 2003 06:55:45 -0000 1.2
+++ openacs-4/packages/photo-album/tcl/photo-album-procs-postgresql.xql 26 Jun 2003 02:45:09 -0000 1.3
@@ -12,7 +12,7 @@
- select photo_album__new_root_folder(:package_id)
+ select photo_album__new_root_folder(:package_id)
@@ -55,7 +55,7 @@
select case
- when content_item__get_content_type(i.item_id) = 'content_folder'
+ when content_item__get_content_type(i.item_id) = 'content_folder'
then 'index?folder_id='
when content_item__get_content_type(i.item_id) = 'pa_album'
then 'album?album_id='
@@ -75,26 +75,26 @@
select exists (select 1
- from cr_items i, cr_items i2
- where i.item_id = :item_id
+ from cr_items i, cr_items i2
+ where i.item_id = :item_id
and i.tree_sortkey between i2.tree_sortkey and tree_right(i2.tree_sortkey)
and i2.item_id = :root_folder
)
- and content_item__get_content_type(:item_id) = :content_type
+ and content_item__get_content_type(:item_id) = :content_type
-
- select acs_permission__grant_permission (
- :object_id, -- object_id
- :user_id, -- grantee_id
- :privilege -- privilege
- )
-
+
+ select acs_permission__grant_permission (
+ :object_id, -- object_id
+ :user_id, -- grantee_id
+ :privilege -- privilege
+ )
+
@@ -151,7 +151,7 @@
UPDATE pa_photos
SET camera_model = :tmp_exif_Cameramodel,
user_filename = :upload_name,
- date_taken = datetime(:tmp_exif_DateTime),
+ date_taken = to_timestamp(:tmp_exif_DateTime,'YYYY-MM-DD HH24:MI:SS'),
flash = :tmp_exif_Flashused,
aperture = :tmp_exif_Aperture,
metering = :tmp_exif_MeteringMode,
@@ -173,7 +173,7 @@
and crr.revision_id = cri.latest_revision
and i.image_id = cri.latest_revision
order by crr.content_length desc
-
+