Putting a parameter in search query

[cary1234]

Hello, I have a query in my sql builder like this

SELECT    *
FROM            canvasstable
WHERE        (Material_Description LIKE '%a%')

That code is 100% working. My problem is I cant change it to something like this

SELECT    *
FROM            canvasstable
WHERE        (Material_Description LIKE '%' + @parameters +'%')

I also tried something like this

WHERE        (Material_Description LIKE CONCAT(@param, '%') AND = CONCAT('%', @param)

Please Help I really need it as much as possible. This is for our system.

[make me rain]

1) Is it MySQL,
2) Is it is in STORED PROCEDURE
3) are you trying to pass the SQL via front end

the simple way is pass the parameter value with %

some thing like this

SELECT * FROM TABLE WHERE TABLE.CRITERIA LIKE @PARAM;

IF in side the UD_SP then
@PARAM = CONCAT('%',YOUR_PARAMETER,'%')
IF you are executing the SQL from front end ( via ADO ) then also the thing is same

[techgnome]

try this:

(Material_Description LIKE ('%' + @parameters +'%'))

-tg

[cary1234]

Thanks tg

1) Is it MySQL,
2) Is it is in STORED PROCEDURE
3) are you trying to pass the SQL via front end

IF you are executing the SQL from front end ( via ADO ) then also the thing is same

1. Yes
2. No
3. I think no, not sure.

I'm using creating it in this




then calling it in the event of the textbox textchange.

Thanks TG I really need it as much as possible because the defense of our system will be on monday, now it is friday 1:00am in the philippines.

[techgnome]

I can tell from the screen shot there that you didn't followclose enough... the parenthesis should be AFTER the like... not before...

-tg

[cary1234]

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

(Material_Description LIKE ('%' + @parameters +'%'))

doesnt work


Everytime I enter in the query builder this code

(Material_Description LIKE ('%' + @parameters +'%'))

Then by pressing execute query the query automatically becomes like this, and error are popping.

(Material_Description LIKE '%' + @parameters + '%')

[cary1234]

Oops, sorry make_me_rain i though you are techgnome. Im just in a hurry.

this answer is for you.

1) Is it MySQL,
2) Is it is in STORED PROCEDURE
3) are you trying to pass the SQL via front end

IF you are executing the SQL from front end ( via ADO ) then also the thing is same

1. Yes
2. No
3. I think no, not sure.

I'm creating it in this




then calling it in the event of the textbox textchange.

[make me rain]

This is a query builder IDE!!, just as QBE in access,
lets say like this

Dim SQL As String = _
        "SELECT Material_Description FROM yourTable WHERE yourTable.Material_Description " _
        & " LIKE @PARAM"
 
        Dim Input_Param As String = "% " & "Some Parameter" & " % "

do not go for the QBE

[cary1234]

    Dim SQL As String = _
            "SELECT Material_Description FROM yourTable WHERE yourTable.Material_Description " _
            & " LIKE @PARAM)"
     
            Dim Input_Param As String = "% " & "Some Parameter" & " % "

I will type those codes inside the event in vb.net??? I cant understand how to use those code. haha! Thanks make me rain.

[make me rain]

i didn't fallow you CARY, what you said & what you are trying for,
Ok any how good night, see u later

[cary1234]

Hmm.. Strange.. Anyways thanks make me rain. Good night! Catch u later!

[cary1234]

Anybody here? Help urgently needed. Please.