B
Bart Plessers \(artabel\)
Hello,
I have problems with the quotation mark and strings in my asp script.
I made a general FORM (myform.asp) to read out data from a dbase
Some vars are defined in the FORM:
SQL_DBASE
SQL_SELECT
SQL_TABLE
SQL_CONDITION
In the script, this information is glued together as a SQL expression:
SQL = "SELECT " & SQL_SELECT & " FROM " & SQL_TABLE & " WHERE " &
SQL_CONDITION & " ;"
and a table is generated from this SQL statement
However,
I want to call this form also with an external link and pars some
parameters,
example:
<a href="myform.asp?var01=string01">Mylink</a>
When this link is activated, the form myform.asp is called with querystring
var01=string01
and SQL_CONDITION becomes:
SQL_CONDITION = "MyField = '" & Request.QueryString("var01") & "'"
However
The SQL_CONDITION shows NOT up correctly in my form, it becomes
MyField =
in stead of
MyField = "string01"
The problem is that the '-character is not converted to a "-character
anybody?
any help is appreciated
bartp
I have problems with the quotation mark and strings in my asp script.
I made a general FORM (myform.asp) to read out data from a dbase
Some vars are defined in the FORM:
SQL_DBASE
SQL_SELECT
SQL_TABLE
SQL_CONDITION
In the script, this information is glued together as a SQL expression:
SQL = "SELECT " & SQL_SELECT & " FROM " & SQL_TABLE & " WHERE " &
SQL_CONDITION & " ;"
and a table is generated from this SQL statement
However,
I want to call this form also with an external link and pars some
parameters,
example:
<a href="myform.asp?var01=string01">Mylink</a>
When this link is activated, the form myform.asp is called with querystring
var01=string01
and SQL_CONDITION becomes:
SQL_CONDITION = "MyField = '" & Request.QueryString("var01") & "'"
However
The SQL_CONDITION shows NOT up correctly in my form, it becomes
MyField =
in stead of
MyField = "string01"
The problem is that the '-character is not converted to a "-character
anybody?
any help is appreciated
bartp