# string parameter in sql query

**URL:** <https://forum.kirupa.com/t/string-parameter-in-sql-query/635528>\
**Category:** Uncategorized\
**Created:** [November 2, 2016, 3:43pm UTC](https://forum.kirupa.com/t/string-parameter-in-sql-query/635528 "2016-11-02T15:43:47Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ekoneo](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ekoneo/32/8893_2.png) [@ekoneo](https://forum.kirupa.com/u/ekoneo)\
**Post date:** [November 2, 2016, 3:43pm UTC](https://forum.kirupa.com/t/string-parameter-in-sql-query/635528/1 "2016-11-02T15:43:47Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Jonny\_Silva](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/jonny_silva/32/7836_2.png) [@Jonny\_Silva](https://forum.kirupa.com/u/Jonny_Silva)\
**Post date:** [November 2, 2016, 4:46pm UTC](https://forum.kirupa.com/t/string-parameter-in-sql-query/635528/2 "2016-11-02T16:46:31Z")

</div>

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

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

---

<div class="post-metadata">

**Author:** ![ekoneo](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/ekoneo/32/8893_2.png) [@ekoneo](https://forum.kirupa.com/u/ekoneo)\
**Post date:** [November 3, 2016, 5:28am UTC](https://forum.kirupa.com/t/string-parameter-in-sql-query/635528/3 "2016-11-03T05:28:16Z")

</div>

Thanks Jonny\_Silva. ’ and " are confusing problem 🙂