Results 1 to 12 of 12

Thread: Putting a parameter in search query

Threaded View

  1. Oct 6th, 2011, 12:32 PM #7
    cary1234
    cary1234 is offline

    Thread Starter
    Addicted Member
    Join Date
    Oct 2009
    Posts
    253

    Re: Putting a parameter in search query

    Oops! Sorry for that. I just intended to show you the way of how I use the query to answer your question number 3 "3) are you trying to pass the SQL via front end"

    The screenshot you see is the query that I'm experimenting.

    By the way
    Code:
    (Material_Description LIKE ('%' + @parameters +'%'))
    doesnt work


    Everytime I enter in the query builder this code

    Code:
    (Material_Description LIKE ('%' + @parameters +'%'))
    Then by pressing execute query the query automatically becomes like this, and error are popping.

    Code:
    (Material_Description LIKE '%' + @parameters + '%')
    Last edited by cary1234; Oct 6th, 2011 at 12:33 PM. Reason: Forgot something
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width