mapquery

Syntax: %mapquery([SQLstring])

Executes the SQL query string (WHERE clause) and returns a string list of room ID numbers for the matching rooms.

Example:

#SHOW %mapquery("[Name] LIKE '%road%'")

displays a string list like 3|45|56|67 with the Room ID of each room that has "road" somewhere in the room name. The % character is the SQL wildcard character for Access databases.

 

#VAR Path %mapquery("[Name] LIKE '%road%'")
#FORALL @Path {#SHOW %roomname(%i)}

Loop through the matching records and display the name of each room in the result.