![]() |
#1 |
Join Date: Jan 2012
Posts: 1
|
![]() Hi,
I have created a search from with 3 different fields. I wanted the search results with LIKE statements from a table. I am confused how to add LIKE statement in query with % wild card. Results are coming only when i add WHERE clause as "=" but not with %. Can some body guide me how to insert LIKE statement with % wild cared in dream weaver recordset. Thanks |
![]() |
![]() |
![]() |
#2 |
![]() ![]() Join Date: Aug 2005
Location: Bali
Posts: 11,216
|
![]() you may have to hand code that , im not certain but i think it maybe a quirk using it in the dreamweaver wizard, but i am far from certain.
I mat regret this as i hate trying to modify dreamweaver code but post the code, if you cant add wild card use + and ill see if i can help. A typical sql statement would be something resembling WHERE FirstName LIKE 'S%'
__________________
If you're happy and you know it shake your meds! different style links examples Flight / Hotel search Free script download Bali Villas |
![]() |
![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|