I need to fill a database using microsoft access and sql in an asp page.
I need to check that the input is not exsit yet, so I use the following to create sql sentence:
tempsql = select * from table where filed= '"
tempsql = tempsql & request.form("name")
tempsql = tempsql & "'"
My problem is that I have to allow the input to include the sign ' ... it doesnt agree to acept it because of the field =' '...
In which other form can I get that input?