Hi everyone,

I have a peculiar problem where I have field called briefdesc in my table which contains description of a product. The description contains dimensions given in inches like 8" x 8" .I am retrieving the value of this field and sending it as a querystring in a hyperlink where there are other querystring values also.My problem is whenever the field is returning a value which has " in the string I'm getting a Javascript error message that there is an unterminated string and the hyperlink is not working. My hyperlink is like below:

----

<a href="javascript://" onclick="open_page(<%=rsproduct("id")%>,'<%=rsprod uct("name")%>','<%=rsproduct("briefdesc")%>','<%=r sproduct("minprice")%>','<%=rsproduct("image")%>', '<%=session("user")%>')" style="text-decoration:none">

-----

Whenever there is an error the querystring values after briefdesc cannot be read.

Is there any way out where I can handle ["] and somehow pass the querystring values or is there a method to trap the ["] from the sql query itself and store in a variable??


Any help will be great..
Thanks in advance.

Hi Arnab,

You can apply function while getting value from briefdesc. e.g.
<%=rsproduct("briefdesc")%> will be <%=StoreText(rsproduct("briefdesc"))%>

And function will be like:
'-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Function StoreText(theText)
    StoreText = ""
    on error resume next
    StoreText = CStr(theText)
    if (len(StoreText) > 0) Then
      StoreText = Replace(StoreText, """", "&quot;", 1, -1, 1)
      StoreText = Replace(StoreText, "'", "''", 1, -1, 1)
      StoreText = Replace(StoreText,"<","&lt;", 1, -1, 1)
      StoreText = Replace(StoreText,">","&gt;", 1, -1, 1)
      StoreText = Replace(StoreText, vbCrLf, "<BR>", 1, -1, 1)
    end if
End Function
--------------



Rupen Anjaria.:)
------------------
We CAN'T avoid problems, but can solve it.

Thanks Rupen,

That worked just as I had wanted.You saved me a headache. Thanks again.!!!