Personal tools
You are here: Home → Knowledge → Techie Central → OpenACS presentation → db-api.html
Navigation
Log in


Forgot your password?
New user?
 
Document Actions

db-api.html

Click here to get the file

Size 1 kB - File type text/html

File contents

  <html>
<head>
<title>OpenACS DB vs. JDBC</title>

</head>
<body bgcolor="white" text="black">

<h2>OpenACS DB vs. JDBC</h2>

<hr>

<table width="100%" border="1">
<tr>
  <th>OpenACS</th>
  <th>Java</th>
</tr>
<tr>
  <td>
   <pre>

   db_multirow results results {
       select item_id as file_id,
              content_item.get_title(item_id) as title
       from   cr_items
       where  lower(content_item.get_title(item_id)) like :query
       and    acs_permission.permission_p(item_id,:user_id,'read') = 't'
   } {

      lappend urls "[ad_conn url]?[ad_urlencode file_id]"

   }
  
   </pre>
  </td>
  <td>

  </td>
</tr>
</table>

<hr />
<address><a href="mailto:tristancohen@yahoo.com">tristancohen@yahoo.com</a></address>

</body>
</html>
by admin — last modified 2003-04-28 10:37
 

View My Stats