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.');
|
