[binarycloud-cvs-commit] cvs: r2 /binarycloud/user/mod/query_example QueryExample.php schema.sql

[alex <bin...@li...>]

alex		Tue Aug 21 19:02:43 2001 EDT

  Modified files:              
    /r2/binarycloud/user/mod/query_example	QueryExample.php schema.sql 
  Log:
  Modified the module and SQL to be oracle compatible. I suppose I shold test this on MySQL :)
  
  
Index: r2/binarycloud/user/mod/query_example/QueryExample.php
diff -u r2/binarycloud/user/mod/query_example/QueryExample.php:1.1 r2/binarycloud/user/mod/query_example/QueryExample.php:1.2
--- r2/binarycloud/user/mod/query_example/QueryExample.php:1.1	Mon Aug 20 14:08:52 2001
+++ r2/binarycloud/user/mod/query_example/QueryExample.php	Tue Aug 21 19:02:43 2001
@@ -1,10 +1,10 @@
 <?php
 // Header {{{
 /*
- * -File		$Id: QueryExample.php,v 1.1 2001/08/20 21:08:52 alex Exp $
- * -License		LGPL (http://www.gnu.org/copyleft/lesser.html)
+ * -File	$Id: QueryExample.php,v 1.2 2001/08/22 02:02:43 alex Exp $
+ * -License	LGPL (http://www.gnu.org/copyleft/lesser.html)
  * -Copyright	2001, Entity
- * -Author		Andreas Aderhold, a.a...@th...
+ * -Author	Andreas Aderhold, a.a...@th...
  */
 
 // {{{ class QueryExample
@@ -29,7 +29,7 @@
 
 		// doing a simple custom SELECT query
 		$query = array(
-			'QUERY' => 'SELECT newsId, news FROM news',
+			'QUERY' => 'SELECT newsid, news FROM news',
 			'ARGTYPES' => array('integer','text'),
 		);
 		$this->result = $QueryManager->DoCustomQuery($query, null, true);
Index: r2/binarycloud/user/mod/query_example/schema.sql
diff -u r2/binarycloud/user/mod/query_example/schema.sql:1.1 r2/binarycloud/user/mod/query_example/schema.sql:1.2
--- r2/binarycloud/user/mod/query_example/schema.sql:1.1	Mon Aug 20 14:08:52 2001
+++ r2/binarycloud/user/mod/query_example/schema.sql	Tue Aug 21 19:02:43 2001
@@ -1,13 +1,16 @@
--- You have to insert these in database test
---
--- Table structure for table `news`
---
-CREATE TABLE news (
-  newsId int(11) default NULL,
-  news text
-) TYPE=MyISAM;
-
---
--- Dumping data for table `news`
---
-INSERT INTO news (newsId, news) VALUES ( '1', 'Hey, Congratualtions. Querymanager is working. You are reading a database record from the query_example. See user.mod.query_example for details.');  
+-- You have to insert these in database test
+--
+-- Table structure for table `news`
+--
+CREATE TABLE news (
+  newsId int(11) default NULL,
+  news text
+) TYPE=MyISAM;
+
+-- For Oracle:
+CREATE TABLE news (newsid int default NULL,news varchar(255));
+
+--
+-- Dumping data for table `news`
+--
+INSERT INTO news (newsId, news) VALUES ( '1', 'Hey, Congratualtions. Querymanager is working. You are reading a database record from the query_example. See user.mod.query_example for details.');