[jQuery] Re: Classis ASP integrating Async Treeview Plugin using getJSON. Stops working when using response.write [variable name] instead of simple JSON string

I'd try:

Response.ContentType = "application/json"

right before the first writing

On Jan 28, 2:32 pm, Jason Knight <jason.t.kni...@gmail.com> wrote:
> Hi all,
>
> I've loved using jQuery these past few months, but I'm really pulling
> my hair our here.
>
> The following is the "endpoint" asp code that gets called to populate
> my treeview:
>
> <%
> rootid = request.querystring("rootid")
> json = ""
> set Conn = server.CreateObject("ADODB.Connection")
> Conn.Open strProvider
> if rootid = "source" then
>         json = "["
>         set RS = Server.CreateObject("ADODB.RecordSet")
>         Sql = "select categoryid,categoryname,(select count(*) from
> tblcategories where parentid = c1.categoryid) ChildCount from
> tblcategories c1 where parentid = 0"
>         session("errorsql") = sql
>         set Cmd = Server.CreateObject("ADODB.Command")
>         Cmd.CommandText = Sql
>         Cmd.ActiveConnection = Conn
>         rs.open Cmd
>         if not RS.EOF then
>                 GotRows = "y"
>                 arrResultSet = RS.GetRows()
>                 numRows = ubound(arrResultSet,2)
>                 For i = 0 to numRows
>                         categoryid = arrResultSet(0,i)
>                         categoryname = arrResultSet(1,i)
>                         childcount = cint(arrResultSet(2,i))
>                         json = json & "{'text': '" & categoryname & "','id':'" & categoryid
> & "'"
>                         if childcount > 0 then
>                                 json = json & ", 'hasChildren':true"
>                         end if
>                         json = json & "}"
>                         if i < numRows  then
>                                 json = json & ","
>                         end if
>                 Next
>         else
>                 GotRows = "n"
>                 json = json & "{'text': 'No Categories have been created'}"
>         end if
>         json = json & "]"
>         RS.close
> elseif isnumeric(rootid) and rootid <> "" then
>         json = "["
>         set RS = Server.CreateObject("ADODB.RecordSet")
>         Sql = "select categoryid,categoryname,(select count(*) from
> tblcategories where parentid = c1.categoryid) ChildCount from
> tblcategories c1 where parentid = ?"
>         session("errorsql") = sql
>         set Cmd = Server.CreateObject("ADODB.Command")
>         Cmd.Parameters.Append CreateIntParameter(Cmd, "rootid", rootid)
>         Cmd.CommandText = Sql
>         Cmd.ActiveConnection = Conn
>         rs.open Cmd
>         if not RS.EOF then
>                 GotRows = "y"
>                 arrResultSet = RS.GetRows()
>                 numRows = ubound(arrResultSet,2)
>                 For i = 0 to numRows
>                         categoryid = arrResultSet(0,i)
>                         categoryname = arrResultSet(1,i)
>                         childcount = cint(arrResultSet(2,i))
>                         json = json & "{'text': '" & categoryname & "','id':'" & categoryid
> & "'"
>                         if childcount > 0 then
>                                 json = json & ", 'hasChildren':true"
>                         end if
>                         json = json & "}"
>                         if i < numRows then
>                                 json = json & ","
>                         end if
>                 Next
>         else
>                 GotRows = "n"
>         end if
>         json = json & "]"
>         RS.close
> end if
> set Cmd = nothing
> set RS=nothing
> conn.close
> set conn=nothing
> response.write json
> %>
>
> This code produces the following JSON string viewable when I hit the
> page directly with the ?rootid=source parameter:
>
> [{'text': 'Cat1.0','id':'1'},{'text': 'Cat1.1','id':'2',
> 'hasChildren':true},{'text': 'Cat1.2','id':'3'}]
>
> Unless I've received a severe blow to the head, I recognize this as
> valid JSON and just what the treeview needs to produce a flat display
> of 3 nodes with the second having a '+' sign for expandability.
>
> Here's the frustrating part, when I past that string into the body of
> my asp page, comment out the response.write line, save, and run
> everything I get the simple tree that I'd expect.  When I remove the
> JSON string, and uncomment the response.write line, nothing happens.
>
> I've tried flushing the response object, ending the response object,
> clearing the response before writing to it, yet nothing seems to work.
>
> Please, please help!