| Anonymous | Login | Signup for a new account | 10-06-26 12:22 CEST |  |
| Main | My View | View Issues | Change Log | Roadmap |
| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |
| 0001727 | SphereServer | executable - linux build | public | 03-03-10 12:00 | 12-06-14 12:46 | |
| Reporter | HOCOK | |||||
| Assigned To | Ben | |||||
| Priority | normal | Severity | minor | Reproducibility | have not tried | |
| Status | closed | Resolution | won't fix | |||
| Platform | OS | OS Version | ||||
| Product Version | 0.56c Nightly | |||||
| Target Version | Fixed in Version | |||||
| Summary | 0001727: db. object mysql overwriten | |||||
| Description | db.query "SELECT * FROM `table1`;" for i 0 (<db.row.numrows> - 1) db.query "SELECT * FROM `table2`;" local.z = <db.row.0.any> endfor Can you fix, when you use db in for , then db object is overwrited by next db query ? need some local db query.. so it will not be overwriten.. This is really annoying bug | |||||
| Tags | No tags attached. | |||||
| Nightly Version | Not Available | |||||
| Experimental Flags | None | |||||
| Option Flags | None | |||||
| Internal Build Number | ||||||
| Attached Files | ||||||
 Relationships |
|
 Relationships |
|
Notes |
|
|
(0000427) dzhony (reporter) 27-03-10 13:50 |
use JOIN statement in SQL query, the for cycle may be significantly slower |
|
(0000428) HOCOK (reporter) 27-03-10 14:00 |
yes but this is not a fix.. some times you need to use function in function and in function / dialog etc. Every of them use own sql query, and they all will overwrite db. object.. that is not nice. |
|
(0002288) Ben (manager) 12-06-14 03:39 |
DB is a global variable so this is not possible. Changing DB to be a localized var would create other issues in the server and is not worth changing for. |
|
(0002291) HOCOK (reporter) 12-06-14 12:15 |
Thanks for the "fast" answer. We have learned to deal with this bug. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 03-03-10 12:00 | HOCOK | New Issue | |
| 03-03-10 12:00 | HOCOK | Nightly Version | => Not Available |
| 03-03-10 12:00 | HOCOK | Experimental Flags | => None |
| 03-03-10 12:00 | HOCOK | Option Flags | => None |
| 27-03-10 13:50 | dzhony | Note Added: 0000427 | |
| 27-03-10 14:00 | HOCOK | Note Added: 0000428 | |
| 14-11-10 19:54 | MrSugarCube | Category | executable - linux => executable - linux build |
| 12-06-14 03:39 | Ben | Note Added: 0002288 | |
| 12-06-14 03:40 | Ben | Status | new => closed |
| 12-06-14 03:40 | Ben | Assigned To | => Ben |
| 12-06-14 03:40 | Ben | Resolution | open => won't fix |
| 12-06-14 12:15 | HOCOK | Note Added: 0002291 | |
| 12-06-14 12:15 | HOCOK | Status | closed => feedback |
| 12-06-14 12:15 | HOCOK | Resolution | won't fix => reopened |
| 12-06-14 12:46 | Ben | Status | feedback => closed |
| 12-06-14 12:46 | Ben | Resolution | reopened => won't fix |
|
Issue History |
| Copyright © 2000 - 2010 MantisBT Group |
 |