|
 |
asp_web_howto thread: my recordset is returning value with a single quote
Message #1 by delcyan@w... on Mon, 30 Sep 2002 17:06:14
|
|
Hello,
I would like to know how do I take care of return values from my database
with single quote.
I have an ASP page which returns a title and that title could have a
single quote in it. rsXML("TITLE") is what I am using to build my return
page. Here is my code:
strHTML = strHTML & "<input class=""editfld "" maxlength=""40""
size=""80"" id=""title"" name=""title"" value='" & rsXML("GTR_TITLE") & "'
readOnly>"
Thank you
Anthony
Message #2 by "Scott Heath" <scott@s...> on Mon, 30 Sep 2002 11:06:42 -0500
|
|
Anthony,
Can you give an example of the value of trsXML("TITLE")?
Scott
-----Original Message-----
From: delcyan@w... [mailto:delcyan@w...]
Sent: Monday, September 30, 2002 5:06 PM
To: ASP Web HowTo
Subject: [asp_web_howto] my recordset is returning value with a single
quote
Hello,
I would like to know how do I take care of return values from my
database
with single quote.
I have an ASP page which returns a title and that title could have a
single quote in it. rsXML("TITLE") is what I am using to build my return
page. Here is my code:
strHTML = strHTML & "<input class=""editfld "" maxlength=""40""
size=""80"" id=""title"" name=""title"" value='" & rsXML("GTR_TITLE") &
"'
readOnly>"
Thank you
Anthony
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #3 by "Anthony Delcy" <DELCYAN@w...> on Mon, 30 Sep 2002 12:09:54 -0400
|
|
Scott,
The value could be something like the following:
- Test's purposes
- Pile's results
Etc..
Thank you
Anthony
>>> scott@s... 09/30/02 12:06 >>>
Anthony,
Can you give an example of the value of trsXML("TITLE")?
Scott
-----Original Message-----
From: delcyan@w... [mailto:delcyan@w...]
Sent: Monday, September 30, 2002 5:06 PM
To: ASP Web HowTo
Subject: [asp_web_howto] my recordset is returning value with a single
quote
Hello,
I would like to know how do I take care of return values from my
database
with single quote.
I have an ASP page which returns a title and that title could have a
single quote in it. rsXML("TITLE") is what I am using to build my return
page. Here is my code:
strHTML =3D strHTML & "<input class=3D""editfld "" maxlength=3D""40""
size=3D""80"" id=3D""title"" name=3D""title"" value=3D'" & rsXML("GTR_TITLE
") &
"'
readOnly>"
Thank you
Anthony
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramme
r-20
to unsubscribe send a blank email to leave-asp_web_howto-1319541V@p...
com.
Message #4 by Vijay G <happygv@y...> on Mon, 30 Sep 2002 10:20:31 -0700 (PDT)
|
|
Hi Anthony,
Try using this.
<input type="text" name="SAMPLE" value="<%=rs1(FIELD_NAME).value%>">
In your code.... VALUE part in embedded in single quote, So, I hope once the value with single quote is given there, it ends the
value part half way.
Cheers!!!
Vijay G
delcyan@w... wrote:Hello,
I would like to know how do I take care of return values from my database
with single quote.
I have an ASP page which returns a title and that title could have a
single quote in it. rsXML("TITLE") is what I am using to build my return
page. Here is my code:
strHTML = strHTML & " [input] size=""80"" id=""title"" name=""title"" value='" & rsXML("GTR_TITLE") & "'
readOnly>"
Thank you
Anthony
---------------------------------
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
Message #5 by "Anthony Delcy" <DELCYAN@w...> on Mon, 30 Sep 2002 15:50:50 -0400
|
|
Vijay G
The entire thing goes in a string which build my html page.
Thank you
Anthony
>>> happygv@y... 09/30/02 01:20 >>>
Hi Anthony,
Try using this.
<input type=3D"text" name=3D"SAMPLE" value=3D"<%=3Drs1(FIELD_NAME).value%>"
>
In your code.... VALUE part in embedded in single quote, So, I hope once
the value with single quote is given there, it ends the value part half
way.
Cheers!!!
Vijay G
delcyan@w... wrote:Hello,
I would like to know how do I take care of return values from my
database
with single quote.
I have an ASP page which returns a title and that title could have a
single quote in it. rsXML("TITLE") is what I am using to build my
return
page. Here is my code:
strHTML =3D strHTML & " [input] size=3D""80"" id=3D""title"" name=3D""title
"" value=3D'" & rsXML("GTR_TITLE") & "'
readOnly>"
Thank you
Anthony
---------------------------------
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramme
r-20
to unsubscribe send a blank email to leave-asp_web_howto-1319541V@p...
com.
|
|
|
View Cart
