Dreamweaver Club Forums

Dreamweaver Club Forums (http://www.dreamweaverclub.com/forum//index.php)
-   PHP (http://www.dreamweaverclub.com/forum//forumdisplay.php?f=188)
-   -   Help needed on LIKE statement (http://www.dreamweaverclub.com/forum//showthread.php?t=42368)

clearwaters 01-06-2012 09:57 AM

Help needed on LIKE statement
 
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

edbr 01-07-2012 12:13 AM

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%'


All times are GMT. The time now is 11:22 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Copyright 2006 DreamweaverClub.com