 |
emnaki
Wanderer
Joined: 12 May 2007
Posts: 59
|
 Posted: Wed May 27, 2009 2:07 pm
[3.08] #MAPQUERY pops error
|
When I use #MAPQUERY, ie. the example from the help files. It pops up an access violation error.
|
|
|
|
|
chris-74269
Magician
Joined: 23 Nov 2004
Posts: 364
|
Posted: Wed May 27, 2009 9:12 pm
|
I'm guessing it's because of the mapper rewrite, and the former MAPQUERY utilizing ADO/MDAC components to do the SQL query.
|
|
|
|
|
wrym
Magician
Joined: 06 Jul 2007
Posts: 349
Location: The big palace, My own lil world
|
Posted: Thu May 28, 2009 7:03 am
|
I highly doubt anything is still using ADO still. That'ld be a fairly obvious oops on the part of Zugg. I can say that %mapquery DOES work.
BUT, i am getting errors from #mapquery, i'ld say it has something to do with trying to display the information in the spreadsheet view.
As an alternative you might try something like this....
| Code: |
$query=%concat("name like '",%subregex(%3,"'","''"),"'")
locations = %mapquery($query)
#forall @locations {
#print {%format("&4s",%i)"," %roomname(%i) "In zone" %roomzone(%i)"," %zonename(%roomzone(%i))}
}
#if (%numitems(@locations) = 0) {#print no locations found} |
|
|
_________________
"To the engineer, all matter in the universe can be placed into one of two categories: (1) things that need to be fixed, and (2) things that will need to be fixed after you've had a few minutes to play with them" - Scott Adams, The Dilbert Principle |
 |
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Mon Jun 01, 2009 6:37 pm
|
#MAPQUERY doesn't use ADO/MDAC, so that isn't the problem. Please give me an example of the exact #MAPQUERY command you are trying to use.
|
|
|
|
|
wrym
Magician
Joined: 06 Jul 2007
Posts: 349
Location: The big palace, My own lil world
|
Posted: Mon Jun 01, 2009 11:50 pm
|
Here are the 2 commands I used to check...
| Code: |
| #print %mapquery("Name LIKE '%camp%'") |
no errors...
| Code: |
| #mapquery {Name LIKE '%camp%'} |
causes 3 errors,
Access violation @ 00CFBAE4 read address 000003B4
Access violation @ 00D0A3C3 read address 00000870
Access violation @ 00D0A086 read address 000003B4 |
|
_________________
"To the engineer, all matter in the universe can be placed into one of two categories: (1) things that need to be fixed, and (2) things that will need to be fixed after you've had a few minutes to play with them" - Scott Adams, The Dilbert Principle |
|
|
|
Zugg
MASTER
Joined: 25 Sep 2000
Posts: 23379
Location: Colorado, USA
|
Posted: Tue Jun 02, 2009 6:16 pm
|
Confirmed and added to bug list.
|
|
|
|
|
|
|
|
