 |
foolstone
Newbie
Joined: 16 Mar 2006
Posts: 1
|
 Posted: Fri Mar 17, 2006 5:56 am
A Quest about database %query
|
#query &key=~"foobar"
the above work well and display the match record
the key value contains foobar,just like "foobarxxxxx"
but
#echo %query(&key=~"foobar")
display nothing
if exactly match,just like below
#echo %query(&key=~"foobarxxxxx")
it work well
why?
how to partly match in database query? |
|
|
|
|
Vijilante
SubAdmin
Joined: 18 Nov 2001
Posts: 5182
|
Posted: Fri Mar 17, 2006 10:02 am
|
Use the %match function instead. The match operator that you are using always had odd problems that just couldn't be pinned down.
|
|
_________________
The only good questions are the ones we have never answered before.
Search the Forums |
 |
|
|
|
|
|
