Jump to content

Archived

This topic is now archived and is closed to further replies.

barkster

Simple Query not Working

Recommended Posts

I'm trying to do this query below using a the LIKE command but is not working for me which I assume if the word Smith shows up in the persons last name it will give me a result but it isn't. Also I'm using Dreamweaver for this, both queries work when I run from Navicat but the first does not in dreamweaver?

SELECT RecFirstName, RecLastName
FROM RecUsers
WHERE RecLastName LIKE '%Smith%'

Results = 0

But if I do this it works??
SELECT RecFirstName, RecLastName
FROM RecUsers
WHERE RecLastName LIKE 'Smith%'

Results 2 rows
Kim Smith
John Smith

Any ideas on why this isn't working?

Share this post


Link to post
Share on other sites
Sounds like Dreamweaver is doing something to leading percentage signs -- I have no idea. Both queries work in SQL, so it's clearly a Dreamweaver issue.

Share this post


Link to post
Share on other sites
yeah, if I run the page I get results for both but when I'm testing from Dreamweaver it doesn't work. I'm posting on dreamweaver group now. Thanks

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.