logo-dw

Go Back   Dreamweaver Club Forums > Hand Coders Forum > PHP
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
Old 01-06-2012, 09:57 AM   #1
clearwaters
 
Join Date: Jan 2012
Posts: 1
Default 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
clearwaters is offline   Reply With Quote
Old 01-07-2012, 12:13 AM   #2
edbr
edbr's Avatar
 
Join Date: Aug 2005
Location: Bali
Posts: 11,164
Default

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
edbr is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 08:59 PM.


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