[Date Prev][Date Next][Thread Prev][Thread Next][Minivend by date
][Minivend by thread
]
Q: ignoring upper/lower case in SQL searches?
****** message to minivend-users from "Sparks, Alan" <asparks@harris.com> ******
Is there a way to write a SQL search that ignores uppercase/lowercase
differences? I've tried building a search using the mv_search_field and
mv_orsearch type tags (since I have TWO fields to search), which works, but is
case sensitive.
If I try to use a mv_sql_query type approach, and have one mv_searchspec but two
question marks in the query, it looks like the second one isn't replaced.
Anyone have any tips? Much thanks in advance for any advice.
-Alan
=============
Alan Sparks, IS Engineering Support <asparks@harris.com>
Harris Communications, Camarillo CA (805) 389-2430
-
To unsubscribe from the list, DO NOT REPLY to this message. Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list
