searching for the quotation mark

[daveigh]

i am currently setting up a forum with the feature of quoting a specific reply. my idea is using the InStr function:

response.Write InStr(rs("forum_reply_message"), """)

thru that i can count the number of characters and show & manipulate it, but i get a "Unterminated string constant" error. how can I search for double quotation marks inside a recordset value? i have tried using " but it won't work the same.

______________CRYOcoustic_____________

 

[tsuji]

>[tt]response.Write InStr(rs("forum_reply_message"), """)
[/tt]
[tt]response.Write InStr(rs("forum_reply_message"), "[highlight]""[/highlight]")[/tt]

 

[trollacious]

Either use four quotation marks in a row, or use Chr(34).

The reasoning behind the 4 quotes is this: The first one opens the string, the next 2 signify the quotation mark, and the last closes the string.

Lee

 

[trollacious]

Slow again!!!! #

Lee

 

[tsuji]

>Slow again!!!! #
Usually it's me.

 

[daveigh]

got it dudes, gonna try it now =)

______________CRYOcoustic_____________