
March 2nd, 2005, 01:22 PM
|
|
Registered User
|
|
Join Date: Feb 2005
Posts: 26
Time spent in forums: 7 h 31 m 25 sec
Reputation Power: 0
|
|
WML and JSP??
Hey guys,
im a new learner to wml and wap. Basically im trying to design a search menu for a mobile phone (searches function names), using WML which will allow user to enter in search criteria the actual SQL search will take place on the JSP page, which will search the Acsess database which holds the names of functions such as Messages.
The only problem i am having is creating a SQL query to search for partial words, so that if a user types in INB the search shoud display INBOX. For this do i use a LIKE statement such as
SELECT INB from table WHERE row like '%INBOX%'
im sorry i am new to databases as well!!
Thanks xx
|