string parameter in sql query

1

Hi all,
Anybody knows the answer of why this query doesnt work in asp?

userName = "eric"
RsLinksSQL = "SELECT * FROM links WHERE name =userName '"

If I use this it Works.
RsLinksSQL = “SELECT * FROM links WHERE name =‘eric’”

why string paremeter is problem for this query?

2

RsLinksSQL = "SELECT * FROM links WHERE name =userName '"

I think you forgot one quote. RsLinksSQL = "SELECT * FROM links WHERE name =userName ' ' "

3

Thanks Jonny_Silva. ’ and " are confusing problem :slight_smile: