| Re: sql query with union |
| by Catzwolf on 2005/6/4 12:35:50 I think queryF should be dropped from the database class and this method of securing the database on a 'get' should be handled by a switch in ( proxy or not) the class to stop the confusion. |
| Re: sql query with union |
| by ChowSinWon on 2005/6/4 12:34:35 Quote:
i see. so the error message of debugger was wrong  Quote: Database update not allowed during processing of a GET request thanx. |
| Re: sql query with union |
| by Mithrandir on 2005/6/4 12:21:51 Quote: xoops recognizes that query as UPDATE Not quite. XOOPS recognizes the query as a non-SELECT query - due to the ( before the SELECT. Try the query without brackets. |
| sql query with union |
| by ChowSinWon on 2005/6/4 11:57:46 hi there. i just stumbled on this little problem. since i still am not familiar enough with xoops, it took me some time, to solve it. i was using a MySQL query with UNION (available since MySQL 4.0) like that: le="color: #000000"><?php (SELECT a FROM table1) UNION (SELECT a FROM table2) that worked for me quite wonderful. but XOOPS recognizes that query as UPDATE which makes usage of $xoopsDB->query($sql) in a GET request impossible. i am aware, that queryF($sql) exists and it does work fine, but isn't it just wrong? or maybe i am just missing something...  greetings ric |
Search
Recent Posts
Who's Online
Donat-O-Meter
| Stats | |
| Goal: | $15.00 |
| Due Date: | Jul 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $15.00 |
|
|