Zugg Software :: View topic

Adept Joined: 10 Jan 2002 Posts: 264 Location: USA

#MAPQUERY {Name LIKE '%@room_to_find%'}
works fine, but i wanna go a step farther:

#MAPQUERY {Name LIKE '%@room_to_find%' AND Area LIKE '%@current_area%'}

Area gives an error stating: Area is not defined
Zone gives an unspecified error.

What exactly are the other SQL field names in the automapper?

Thanks in advance,
Private

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

The common ones and there type (I think they can all be used)
name - string
desc - string
hint - string
userstr - string
userint - int
cost - int
color - int
ZONEID - int

since zoneid is refrenced by a number you have to do some fancy footwork to select it properly and you will need the FULL zone name, also %zonenum() without a paramater will return the zonenum of the current zone you are in, in the mapper

#MAPQUERY {Name LIKE '%@room_to_find%' AND ZONEID LIKE '%zonenum(@current_area)'}

Adept Joined: 10 Jan 2002 Posts: 264 Location: USA

Thanks a ton, those field name/types should be added to the help file, would make like more simple :)

That was exactly what i was looking for, where'd ya find em? trial and error?

Wizard Joined: 15 Jan 2002 Posts: 1644 Location: USA

Opened the map database in access :p