Do I need to use the connector?

Suite and Optimus Suite 5
#1

Hello,

I have asp code that is currently loading in a treegrid by calling an asp page that returns XML. My problem is that while it looks great, I need to format some columns by turning one into a link and other into an tag. My understanding is that I can only format the data prior to displaying it by using the beforerender method and that method is only available on the connector object. Are my assumptions correct so far?

If so, I need to totally change my asp code to use the connector object. I tried to use the render_sql method to call an Oracle stored procedure. Then I use the mygrid.loadXML(“mcmgetdata_connector.asp”) method to invoke it. Unfortunately I get an Invalid XML error when I load the page. Here is my mcmgetdata_connector.asp code:

<%
connDataSource=“CMSP”
connUserID=“login”
connPassword=“password”

objConnectionString = “Provider=OraOLEDB.Oracle.1;Password=” & connPassword & “;Persist Security Info=True;User ID=” & connUserID & “;Data Source=” & connDataSource

Dim res, strSQL
Set res = CreateObject(“ADODB.Connection”)
res.ConnectionString = objConnectionString
res.Open

Dim grid
Set grid = new Connector
grid.init TypeTreeGrid, res, “Oracle”, TypeUnspecified, TypeUnspecified
strSQL = “{ CALL bonus_sprocs.SelDirectReports2(50005,‘2010’) }”
grid.render_sql strSQL,“emp_id”,“last_name,first_name,salary_value,bonus_value_usd,bonus_value_usd_prev,direct_reports”,“”,“parentId”
%>

Thank you.
Melissa

#2

connector logic is very simple, it outputs just the same XML data, just includes extra HTML in it, you can reflect the same

Instead of
data
you can output

<![CDATA[ data ]]>

The main benefit of connectors is data saving, in case of loading they not differ a lot from simple db-to-xml script. ( and event in DB saving part - it can be recreated through custom script with not so big efforts )

#3

Thank you.
I was missing the CDATA part.

I will likely need connectors, but haven’t gotten to any data saving part yet. I will likely have issues with that as well. :smiley:

Thanks for your help.
Melissa