Getting ObjectRSearch to write text

[ladyck3]

Now this may seem weird...but from this forum I found out something spectactular, how to make the field output read currency by using FormatCurrency and defining 2 decimal places. But here is my problem now:

<td><span class="style1"><%= objRSsearchrelHLtbl.Fields("FAQ_List_Bookmark_Page").Value %></span></td>

The problem with this field output is that the field is actually a javascript which link to an image for the user to click on.

I want the actual output from my EXPORT TO EXCEL form to export the TEXT ONLY... so when I view the excel doc, I see the actual script.

I have the same problem with two other fields which are actual IFRAMES... I need to see the Iframe tags with all of the data within.... how can I also get that to export as text?

I am totally ignorant about this stuff and I tried using rather than FormatCurrency to use FormatText but of course that did not work.

PLEASE HELP!



LadyCK3
aka: Laurie

 

[Sheco]

First thing to do is determine what the plain HTML would be to create the required result. Once you have this it will be easier to construct some ASP for building the HTML.

 

[ladyck3]

These are two examples.... one is an IFRAME tag the other is JAVASCRIPT. I need the results to be exported to Excel in their 'text' format, not in the result such as the javascript showing the button.

IFRAME (this may cause problems with the code here right)

(Information has been changed for confidentially purposes)

<iframe src="

https://www.test.com/web/Misc/faq/aaa_customer_form.asp"

width=100% Marginwidth=0 Marginheight=0 Frameborder=0 Scrolling=Yes></iframe>

The Javascript is:

<a href="javascript:window.external.AddFavorite('

http://www.test.com/customer/usa/jsp/faqs/faqs_view.jsp?SITE_ID=22

ID=557_SUB_ID=558_ID=1299_ID=125378', 'Your FAQ List')"><img src="

http://www.google.com/images/logo.jpg"

border="0" width="199" height="66"></a>


These are text fields in my db and when they appear in a search, the do show the iframes and the resulting button in the javascript... that's fantastic because I can test my links.....

But when I EXPORT to excel, I want the full text link... from < to > with all of the information...

So does this help? I hope so!!!




LadyCK3
aka: Laurie