G'day,

My asp code for normal HTML output is derived from this sort of thing
<% Do While Not rstSearch.EOF %>
    <%= rstSearch.Fields (1) %>
    <%= rstSearch.Fields (2) %>
    <%= rstSearch.Fields (3) %>
    <%= rstSearch.Fields (4) %>
  <%
    iRecordsShown = iRecordsShown + 1
rstSearch.MoveNext
Loop
'done - close table

I need to format the results of my asp query to pass it to a java applet

So I want process the output in a format called TABLE_CONTENT
with one record per line which looks like this


var TABLE_CONTENT = [
["dayz1", "ADAMS", 88, 23746],
["rhit1s", "ADAMS", 74, 293772],
["kokain", "AGEEV", 67, 348304],
["agauth", "AGEEV", 48, 0],
];


Main probs I have are quotes around the str data and the ] before the last comma in each record

ANY errors and the whole thing just does not work

any help with code snippet would be most helpful

Thanks

Topshed

Please check the following code snippet

s1 = "dayz1"
s2 = "ADAMS"
s3 = 88
s4 = 23746
s5 = "[""" & s1 & """, """ & s2 & """, " & s3 & ", " & s4 & "],"

In the end you can remove the last comma using:
s6 = left(s5,len(s5)-1)

Hope this helps

Om Prakash

Thank you,

That helped tremendously

Topshed