Zugg Software :: View topic

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

is it possible?

#MAPQUERY {Name LIKE 'The Kitchen'}

shows all 'The Kitchen' and 'the kitchen'

just wanna do an exact as possible querry

The help file just says to "See an SQL guide for more details on allowed syntax."

but so far ive tried...

#MAPQUERY {Name COLLATE SQL_Latin1_General_CP1_CS_AS = 'The Kitchen'}

for an "unspecified error"

and

#MAPQUERY {CONVERT(VARBINARY, Name) = CONVERT(VARBINARY, 'The Kitchen')}

for an undefined function 'CONVERT'

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

Try this (untested)

instead of #MAPQUERY {Name LIKE 'The Kitchen'}

use #MAPQUERY {Name = 'The Kitchen'}

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

nope... tried, still unsensitve... the brute

in foxpro sql it would be == but zmud pukes on that.

from what i've found around the web, the COLLATE and CONVERT options are the thing for ADO and MS SQL, but zmud doesn't seem to support those functions.

SubAdmin Joined: 18 Nov 2001 Posts: 5182

Keep in mind that the #MAPQUERY command preforms an SQL query with its arguments placed into the WHERE portion of the query. For example:

#MAPQUERY {Name LIKE 'The Kitchen'}
results in something like:
SELECT ObjectTbl WHERE (Name LIKE 'The Kitchen');

The exact conversion is something Zugg never published, but since the query is done through ADO you should be able to use those functions. My experience with SQL is quite limited, but seems to indicate Name in the above query would have to become ObjectTbl.Name to make the query happy. Zugg may have simply not spent too much time writing the needed parsing to handle substitutions using those odd ADO functions.

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

as per my examples in the original post...