Using Wildcards on Integers MySql

Question

Hi,

SQL PHP/MySql development.

Since 8.02 I cannot use LIKE '%' on integers.

Specific problem:

On a search form I have a dynamic menu/list. The menu is
populated with categories (values are integers, labels the names of
the categories).

When submitted everything works fine - showing the records
belonging to the selected category of another recordset.

If I add a static option with the value of % (or _) to the
dynamic menu for "All Categories" nothing shows up.

Prior to 8.02 this worked.

Does anyone how to get this working?
Thanks.

Tom

Newsgroup_User · Answer

Tom Denmark wrote:> Since 8.02 I cannot use LIKE '%' on integers. > > Does anyone how to get this working?Yes, select "Text" as the data type instead of "Numeric".LIKE is a pattern comparison operator that requires a string,and all strings must be wrapped in quotes. If you select "Text",Dreamweaver escapes any control characters and wraps the string in quotesbefore presenting it to MySQL. If you select "Numeric", Dreamweaverlooks for an integer and presents it to MySQL without quotes. If youuse a wildcard, such as % or _, Dreamweaver suspects a SQLinjection attack and replaces the number with 0.Although it may seem counter-intuitive, Dreamweaver 8.0.2 istreating LIKE correctly.-- David PowersAdobe Community ExpertAuthor, "Foundation PHP for Dreamweaver 8" (friends of ED)http://foundationphp.com/

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded