Register to post in forums, or Log in to your existing account
 

Play RetroMUD
Post new topic  Reply to topic     Home » Forums » zMUD General Discussion
mortie
Wanderer


Joined: 26 Sep 2002
Posts: 73
Location: United Kingdom

PostPosted: Tue Jun 08, 2004 12:19 pm   

%query in a non case sensitive search
 
Hi,

I use this line to search my db

DBQuery=%query( %pos( "%-1", &Name|ro))

At the moment when i give a keyword(s) to search it only picks up on the case sensitive ones in the db.

e.g

Intersection

(misses out any records that the keyword is "intersection")

Ive tried searching on the forums but couldn't find an answer.

Is there a way to force %query to look al all occurances regardless of case?

Thanks

mortie
Reply with quote
LightBulb
MASTER


Joined: 28 Nov 2000
Posts: 4817
Location: USA

PostPosted: Tue Jun 08, 2004 5:45 pm   
 
Define the case.
DBQuery=%query( %pos( %lower("%-1"), %lower(&Name|ro)))
Reply with quote
Display posts from previous:   
Post new topic   Reply to topic     Home » Forums » zMUD General Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

© 2009 Zugg Software. Hosted by Wolfpaw.net