Index: openacs-4/packages/scorm-importer/tcl/import-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/scorm-importer/tcl/Attic/import-procs.xql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/scorm-importer/tcl/import-procs.xql 14 May 2010 23:30:31 -0000 1.3 +++ openacs-4/packages/scorm-importer/tcl/import-procs.xql 18 May 2010 02:00:23 -0000 1.4 @@ -4,51 +4,56 @@ - insert into cp_package (cp_package_id) values (:scorm_course_id) + insert into cp_package + (cp_package_id) + values + (:scorm_course_id) - + update cp_package - set jsdata = :jsdata, - xmldata = :xmldata, - activitytree = :activity_tree, - global_to_system = :global_to_system - where cp_package_id = :scorm_course_id + set jsdata = :jsdata, + xmldata = :xmldata, + activitytree = :activity_tree, + global_to_system = :global_to_system + where cp_package_id = :scorm_course_id insert into cp_node - (cp_node_id, nodename, cp_package_id) + (cp_node_id, nodename, cp_package_id) values - (:cp_node_id, :nodename, :cp_package_id) + (:cp_node_id, :nodename, :cp_package_id) insert into cp_tree - (child, depth, cp_package_id, parent, rgt) + (child, depth, cp_package_id, parent, rgt) values - (:cp_node_id, :depth, :cp_package_id, :parent, '0') + (:cp_node_id, :depth, :cp_package_id, :parent, '0') insert into cp_[string tolower ${nodename}] - ([join $attributes ", "]) + ([join $attributes ", "]) values - (:[join $attributes ", :"]) + (:[join $attributes ", :"]) - update cp_tree set rgt = :rgt where child = :cp_node_id + update cp_tree + set rgt = :rgt + where child = :cp_node_id