OpenACS

skaufman
committed
MAIN:skaufman:20050302001704
on 02 Mar 05
adds get_url proc to fix bug 2331
/tcl/notification-procs-oracle.xql (+23)
  1 <?xml version="1.0"?>
  2 <!DOCTYPE queryset PUBLIC "-//OpenACS//DTD XQL 1.0//EN" "http://www.thecodemill.biz/repository/xql.dtd">
  3 <!-- packages/lars-blogger/tcl/notification-procs-oracle.xql -->
  4 <!-- @author Stan Kaufman (skaufman@epimetrics.com) -->
  5 <!-- @creation-date 2005-03-01 -->
  6 <!-- @cvs-id $Id$ -->
  7
  8 <queryset>
  9  
  10   <rdbms>
  11     <type>oracle</type>
  12     <version>8.1.6</version>
  13   </rdbms>
  14  
  15   <fullquery name="lars_blogger::notification::get_url.select_weblog_package_url">
  16     <querytext>
  17       select site_node.url(node_id)
  18       from site_nodes
  19       where object_id = :entry_id
  20     </querytext>
  21   </fullquery>
  22
  23 </queryset>