sql - How to use LIKE operator with wildcards in parameterized query in MS-Access -

-

i using ms access database, need pass parametrized query. ms access uses in format ... '[par1]' {par1 parameter in ms-access-query} need way use parametrized query wildcard support. example, if user enter 325 par1, sql-command text in condition ... field1 "*325*"

have tried following:

like "*" & [par1] & "*"

Comments

Post a Comment

Popular posts from this blog

arrays - PHP Shopping Cart Variable and Object errors -

-
i need eliminate errors im getting. have shopping cart displayed on products page way of cart update page. below pair of errors (notices) every product listed: notice: undefined variable: obj in c:\xampp\htdocs\project2\browseproducts.php on line 89 notice: trying property of non-object in c:\xampp\htdocs\project2\browseproducts.php on line 89 when click on of add cart buttons, nothing added cart , get: notice: undefined index: stock in c:\xampp\htdocs\project2\cart_update.php on line 25 my code is: <?php $user = "root"; $password = ""; $database = "webstore"; mysql_connect("localhost", $user, $password); @mysql_select_db($database) or die("unable select database"); $current_url = base64_encode("http://".$_server['http_host'].$_server['request_uri']); $query = "select * products order category"; ...
Read more

javascript - jQuery "chosen": conflict with 'selected' attribute in option tag -

-
i'm having trouble getting jquery snippet work due 'conflict' jquery plugin 'chosen' . i'm using wordpress in case matters. i want set selected attribute in several <option> tags, using jquery( document ).ready(function() { var arr = ["1", "2"]; jquery("#location option").each(function () { if (jquery.inarray(jquery(this).val(), arr) != -1) { jquery(this).prop('selected', true); }; }); }); html output <select name="location[]" multiple="multiple" id="location" class="postform" style="display: none;"> <option value="-1">select location</option> <option class="level-0" value="1">location a</option> <option class="level-0" value="2">location b</option> <option class="level-0" value="3">location ...
Read more