problem with sql statement - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

problem with sql statement

i am using access database and am having problem in writting a SQL query

like if i write in the manner

SELECT * FROM customer WHERE firstname = 'Diwakar'

now what i want is instead of directly giving the name supplying the content of textbox

Please help

Comments

  • doofusboydoofusboy Posts: 256Member
    : i am using access database and am having problem in writting a SQL query
    :
    : like if i write in the manner
    :
    : SELECT * FROM customer WHERE firstname = 'Diwakar'
    :
    : now what i want is instead of directly giving the name supplying the content of textbox
    :
    : Please help
    :

    Try something like this:

    Dim strSQL as String

    strSQL = "SELECT * FROM customer WHERE firstname = '" & Text1.Text & "';"
  • JonathanJonathan Posts: 2,914Member
    : Try something like this:
    :
    : Dim strSQL as String
    :
    [red]strSQL = Replace(strSQL, "'", "'")[/red]

    : strSQL = "SELECT * FROM customer WHERE firstname = '" & Text1.Text & "';"
    :

    Jonathan

    ###
    for(74,117,115,116){$::a.=chr};(($_.='qwertyui')&&
    (tr/yuiqwert/her anot/))for($::b);for($::c){$_.=$^X;
    /(p.{2}l)/;$_=$1}$::b=~/(..)$/;print("$::a$::b $::c hack$1.");

Sign In or Register to comment.