Search the Database with asp

[Beracosta]

Hi everybody! I want to have a search function on my page. The user types whatever he/she wants to find in a text box and the hits the button. I've tried everything to make this work and i thought that this would work:

"SELECT * FROM Varor WHERE KortBeskrivning LIKE '" & strSearch & "'"

but it doesn't... any ideas?

/Björn

 

[swilliams]

Put an asterix on the front / end of the variable, depending on how you want the search to work:
asterix at the front will search for any record where the field ends with the string held in the variable;
asterix at the end will search for any records where the field begins with the string held in the variable;
asterix at the front and at the end will search for records where the field contains the string held in the variable.

"SELECT * FROM Varor WHERE KortBeskrivning LIKE '*" & strSearch & "*'"
Simon

 

[Beracosta]

it dosen't work.it just doesnä't display any thing!

pls help!

 

[swilliams]

There must be something else wrong with your code, then, because the statement I previously posted works. Can you post the rest of your code??
Simon

 

[Beracosta]

should i'll post the whole search page? it isn't so much code...

 

[Beracosta]

i think i solved it now. i haven't tried it yet but i think i should use % instead of *....

 

[swilliams]

My syntax was for Access - if you are using SQL Server 7, then you should use % instead of * - good old Microsoft!!!
Simon

 

[chiph]

swilliams -

The percent sign as used for a wildcard character is part of the SQL standard. MSAccess uses the asterisk, which is non-standard behavior.

Chip H.

 

[swilliams]

What I meant is that we get used to one way of doing things and the same vendor goes and changes it.... At least there seems to be a valid reson for changing things this time, though.
Simon