Index: openacs-4/packages/acs-admin/www/apm/version-edit-2.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/version-edit-2.xql,v diff -u -r1.4 -r1.4.20.1 --- openacs-4/packages/acs-admin/www/apm/version-edit-2.xql 20 Apr 2004 21:12:28 -0000 1.4 +++ openacs-4/packages/acs-admin/www/apm/version-edit-2.xql 23 Oct 2020 17:03:05 -0000 1.4.20.1 @@ -15,7 +15,7 @@ select version_name as old_version_name, version_uri as old_version_uri from apm_package_versions - where version_id = $version_id + where version_id = :version_id Index: openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql,v diff -u -r1.2 -r1.2.32.1 --- openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql 11 May 2001 04:42:43 -0000 1.2 +++ openacs-4/packages/acs-admin/www/apm/packages/index-oracle.xql 23 Oct 2020 17:03:05 -0000 1.2.32.1 @@ -25,7 +25,7 @@ from cr_revisions where revision_id = (select content_item.get_latest_revision(item_id) from apm_package_versions - where version_id = $version_id) + where version_id = :version_id) Index: openacs-4/packages/acs-content-repository/tcl/deprecated-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/deprecated-procs.xql,v diff -u -r1.1 -r1.1.2.1 --- openacs-4/packages/acs-content-repository/tcl/deprecated-procs.xql 22 Jan 2018 10:43:06 -0000 1.1 +++ openacs-4/packages/acs-content-repository/tcl/deprecated-procs.xql 23 Oct 2020 17:03:05 -0000 1.1.2.1 @@ -81,7 +81,7 @@ where r.mime_type = m.mime_type and - r.revision_id = $revision_id + r.revision_id = :revision_id Index: openacs-4/packages/acs-content-repository/tcl/revision-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/tcl/revision-procs-oracle.xql,v diff -u -r1.13.20.2 -r1.13.20.3 --- openacs-4/packages/acs-content-repository/tcl/revision-procs-oracle.xql 3 Jan 2020 10:46:57 -0000 1.13.20.2 +++ openacs-4/packages/acs-content-repository/tcl/revision-procs-oracle.xql 23 Oct 2020 17:03:05 -0000 1.13.20.3 @@ -14,7 +14,7 @@ select content from cr_revisions - where revision_id = $revision_id + where revision_id = :revision_id Index: openacs-4/packages/assessment/tcl/as-item-type-sa-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/tcl/as-item-type-sa-procs.xql,v diff -u -r1.3 -r1.3.12.1 --- openacs-4/packages/assessment/tcl/as-item-type-sa-procs.xql 17 Feb 2006 12:13:55 -0000 1.3 +++ openacs-4/packages/assessment/tcl/as-item-type-sa-procs.xql 23 Oct 2020 17:03:05 -0000 1.3.12.1 @@ -29,9 +29,9 @@ from as_item_data d, as_session_item_map m, cr_revisions ri, cr_revisions rs where d.session_id in ([join $sessions ,]) and d.as_item_id = ri.revision_id - and ri.item_id = $as_item_item_id + and ri.item_id = :as_item_item_id and d.section_id = rs.revision_id - and rs.item_id = $section_item_id + and rs.item_id = :section_item_id and m.session_id = d.session_id and m.item_data_id = d.item_data_id Index: openacs-4/packages/evaluation/www/view/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/view/index-postgresql.xql,v diff -u -r1.2 -r1.2.12.1 --- openacs-4/packages/evaluation/www/view/index-postgresql.xql 8 Aug 2006 21:26:43 -0000 1.2 +++ openacs-4/packages/evaluation/www/view/index-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.2.12.1 @@ -16,13 +16,13 @@ ( select CASE - WHEN et3.number_of_members = 1 THEN $user_id + WHEN et3.number_of_members = 1 THEN :user_id ELSE (select etg2.group_id from evaluation_task_groups etg2, evaluation_tasks et2, acs_rels map where map.object_id_one = etg2.group_id - and map.object_id_two = $user_id + and map.object_id_two = :user_id and etg2.task_item_id = et2.task_item_id and et2.task_id = et.task_id) Index: openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql,v diff -u -r1.10 -r1.10.12.1 --- openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql 8 Aug 2006 21:26:45 -0000 1.10 +++ openacs-4/packages/evaluation-portlet/www/evaluation-evaluations-portlet-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.10.12.1 @@ -33,7 +33,7 @@ ( select CASE - WHEN et3.number_of_members = 1 THEN $user_id + WHEN et3.number_of_members = 1 THEN :user_id ELSE (select etg2.group_id from evaluation_task_groups etg2, evaluation_tasks et2, Index: openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql,v diff -u -r1.39.2.2 -r1.39.2.3 --- openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 20 Nov 2019 13:18:27 -0000 1.39.2.2 +++ openacs-4/packages/file-storage/tcl/file-storage-procs-oracle.xql 23 Oct 2020 17:03:05 -0000 1.39.2.3 @@ -75,7 +75,7 @@ select content from cr_revisions - where revision_id = $live_revision + where revision_id = :live_revision Index: openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql,v diff -u -r1.51.2.2 -r1.51.2.3 --- openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql 20 Nov 2019 13:18:27 -0000 1.51.2.2 +++ openacs-4/packages/file-storage/tcl/file-storage-procs-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.51.2.3 @@ -63,7 +63,7 @@ select lob from cr_revisions - where revision_id = $live_revision + where revision_id = :live_revision Index: openacs-4/packages/forums/www/moderate/move-thread-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/moderate/move-thread-oracle.xql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/forums/www/moderate/move-thread-oracle.xql 13 Nov 2017 15:22:26 -0000 1.3 +++ openacs-4/packages/forums/www/moderate/move-thread-oracle.xql 23 Oct 2020 17:03:05 -0000 1.3.2.1 @@ -35,9 +35,9 @@ update forums_messages set last_child_post = (select max(last_child_post) from forums_messages - where forum_id = :forum_id and tree_sortkey between tree.left((select tree_sortkey from forums_messages where message_id = $father_message_id)) and tree.right((select tree_sortkey from forums_messages where message_id = $father_message_id)) + where forum_id = :forum_id and tree_sortkey between tree.left((select tree_sortkey from forums_messages where message_id = :father_message_id)) and tree.right((select tree_sortkey from forums_messages where message_id = :father_message_id)) ) - where message_id = $father_message_id + where message_id = :father_message_id Index: openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql 13 Nov 2017 15:22:26 -0000 1.3 +++ openacs-4/packages/forums/www/moderate/move-thread-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.3.2.1 @@ -35,9 +35,9 @@ update forums_messages set last_child_post = (select max(last_child_post) from forums_messages - where forum_id = :forum_id and tree_sortkey between tree_left((select tree_sortkey from forums_messages where message_id = $father_message_id)) and tree_right((select tree_sortkey from forums_messages where message_id = $father_message_id)) + where forum_id = :forum_id and tree_sortkey between tree_left((select tree_sortkey from forums_messages where message_id = :father_message_id)) and tree_right((select tree_sortkey from forums_messages where message_id = :father_message_id)) ) - where message_id = $father_message_id + where message_id = :father_message_id Index: openacs-4/packages/forums/www/moderate/move-thread.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/moderate/move-thread.xql,v diff -u -r1.2 -r1.2.12.1 --- openacs-4/packages/forums/www/moderate/move-thread.xql 8 Aug 2006 21:26:53 -0000 1.2 +++ openacs-4/packages/forums/www/moderate/move-thread.xql 23 Oct 2020 17:03:05 -0000 1.2.12.1 @@ -31,7 +31,7 @@ update forums_messages set reply_count = reply_count - 1, approved_reply_count = approved_reply_count - 1 - where message_id = $father_message_id + where message_id = :father_message_id @@ -62,4 +62,4 @@ - \ No newline at end of file + Index: openacs-4/packages/general-comments/www/file-add-2-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/general-comments/www/file-add-2-oracle.xql,v diff -u -r1.1 -r1.1.30.1 --- openacs-4/packages/general-comments/www/file-add-2-oracle.xql 31 Oct 2001 20:46:59 -0000 1.1 +++ openacs-4/packages/general-comments/www/file-add-2-oracle.xql 23 Oct 2020 17:03:05 -0000 1.1.30.1 @@ -60,8 +60,8 @@ update cr_revisions - set filename = '$tmp_filename', - content_length = $tmp_size + set filename = :tmp_filename, + content_length = :tmp_size where revision_id = :revision_id Index: openacs-4/packages/general-comments/www/file-add-2-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/general-comments/www/file-add-2-postgresql.xql,v diff -u -r1.2 -r1.2.30.1 --- openacs-4/packages/general-comments/www/file-add-2-postgresql.xql 1 Nov 2001 19:01:47 -0000 1.2 +++ openacs-4/packages/general-comments/www/file-add-2-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.2.30.1 @@ -56,8 +56,8 @@ update cr_revisions - set content = '$tmp_filename', - content_length = $tmp_size + set content = :tmp_filename, + content_length = :tmp_size where revision_id = :revision_id Index: openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql,v diff -u -r1.4 -r1.4.2.1 --- openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql 15 Nov 2017 11:08:17 -0000 1.4 +++ openacs-4/packages/rss-support/tcl/rss-generation-service-procs-oracle.xql 23 Oct 2020 17:03:05 -0000 1.4.2.1 @@ -28,8 +28,8 @@ begin acs_sc_binding.new( - contract_id => $contract_id, - impl_id => $impl_id + contract_id => :contract_id, + impl_id => :impl_id ); end; Index: openacs-4/packages/rss-support/tcl/rss-generation-service-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/tcl/rss-generation-service-procs-postgresql.xql,v diff -u -r1.3 -r1.3.2.1 --- openacs-4/packages/rss-support/tcl/rss-generation-service-procs-postgresql.xql 15 Nov 2017 11:08:17 -0000 1.3 +++ openacs-4/packages/rss-support/tcl/rss-generation-service-procs-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.3.2.1 @@ -29,7 +29,7 @@ - select acs_sc_binding__new($contract_id,$impl_id) + select acs_sc_binding__new(:contract_id,:impl_id) Index: openacs-4/packages/theme-zen/www/doc/lists/index-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/theme-zen/www/doc/lists/index-postgresql.xql,v diff -u -r1.2 -r1.2.10.1 --- openacs-4/packages/theme-zen/www/doc/lists/index-postgresql.xql 15 May 2007 20:14:57 -0000 1.2 +++ openacs-4/packages/theme-zen/www/doc/lists/index-postgresql.xql 23 Oct 2020 17:03:05 -0000 1.2.10.1 @@ -24,7 +24,7 @@ else :folder_path || '/' || fs_objects.file_upload_name end as file_url, case - when fs_objects.last_modified >= (now() - cast('$n_past_days days' as interval)) + when fs_objects.last_modified >= (now() - cast(:n_past_days days as interval)) then 1 else 0 end as new_p