XML: a string literal was expected, but no opening quote character was found.

[sushweta8]

Hi,


I am using technology:ASP with backend: sql server

I'm trying to get the sql query results in XML on my asp page, after a while or so, but i get an alert box saying

XML: a string literal was expected, but no opening quote character was found.

Any help, guidance, suggestion or solution will be greatly appreciated!

Thanks in advance,

Sush

[dorinbogdan]

If this thread is not helpful please reply.

[dorinbogdan]

Also, check the XML to have always the attribute values quoted.
See this link.

[sushweta8]

Also, check the XML to have always the attribute values quoted.
See this link.

I have checked the quotes around the attributes in the XSL and they are all fine. So that doesn't seem to be the problem

[dorinbogdan]

How do you load the XML file or string?
Please include some sample code and XML data.

[sushweta8]

How do you load the XML file or string?
Please include some sample code and XML data.

ok, here is code, i have only removed "Get form variables" lines of code

<%
Response.Buffer = true
Response.Expires=-1444
Response.CacheControl = "no-cache"
Server.ScriptTimeout=10000
Response.CharSet="windows-1252"
Response.ContentType="text/xml"
 
Dim oXMLOutput,oElement,oRs,oCn,iCount,sValue, sCols, iArrayCount, bExists, bLogonPracticeExists
 
Set oCn = server.CreateObject("ADODB.Connection")
Set oRs = server.CreateObject("ADODB.Recordset")
set oXMLOutput=server.CreateObject("MSXML2.DOMDocument")
 
'connect to the database
oCn.Open Application("gsConnection")
 
'fetch all the records into the recordset
set oRs=oCn.Execute("gs_get_riskoverview_revised '" & sCriteria & "','" & sData & "','" & sNT_ID & "','" & sStage & "','" & dtStart & "','" & dtEnd & "'")
 
'sPage name is passed from the corresponding pages from where this page is called through XMLHTTP
 
select case sPage
 
case "Overview"
 
sCols="CURRENT_STAGE,SORT_STAGE,SALES_PROSPECT_CODE,PARTNER_NAME,MANAGER_NAME,RAF_STATUS,LATEST_RAF,COMBINED_OVERALL_RISK,RESEND,ACTIONS"
 
sCols=split(sCols,",")
 
end select
 
'load the dom object
oXMLOutput.loadXML("<ROWS/>")
 
'used for inserting an attribute which is not present in the database
bExists=0
 
'used for checking the existence of logon users practice
bLogonPracticeExists=0
 
do while not oRs.EOF
    Set oElement = oXMLOutput.createElement("ROW")
    oXMLOutput.selectSingleNode("//ROWS").appendChild oElement
    for iArrayCount=lbound(sCols) to ubound(sCols)
        for iCount=0 to oRs.Fields.Count-1
            if sCols(iArrayCount)=oRs.Fields(iCount).Name then
                if oRs.Fields(iCount).Value=NULL or IsNull(oRs.Fields(iCount).Value) then
                    sValue=""
                else
                    sValue=oRs.Fields(iCount).Value
                end if
                oElement.setAttribute oRs.Fields(iCount).Name,sValue
                bExists=1
                exit for
            end if
        next
        if bExists=0 then
            oElement.setAttribute sCols(iArrayCount),""
        end if
        'reset
        bExists=0
    next
 
    'check if the logon user practice is present in the recordset
    'if no then add it in the xml string    
    if sPage="PracticeLoc" or sPage="PracticeGlob" then
        if oRs("UNIT_CODE")=sPracticeCode then
            bLogonPracticeExists=1
        end if
    end if
    oRs.MoveNext
loop
 
'if the flag bLogonPracticeExists=0 then the recordset has not retrieved 
'the logon users practice hence added it to the xml string
if (sPage="PracticeLoc" or sPage="PracticeGlob") and bLogonPracticeExists=0 then
    Set oElement = oXMLOutput.createElement("ROW")
    oXMLOutput.selectSingleNode("//ROWS").appendChild oElement
    oElement.setAttribute "UNIT_CODE",sPracticeCode
    oElement.setAttribute "UNIT_NAME",sDescription
end if
 
%>
<?xml version="1.0" encoding="windows-1252"?>
<%
Response.Write oXMLOutput.xml
 
set oXMLOutput=Nothing
set oCn=Nothing
set oRs=Nothing
%>
 

[dorinbogdan]

Just for test, try to remove the line (the header should be already set):

%>
<?xml version="1.0" encoding="windows-1252"?>
<%
 

If no success, check carefully the formatting of oXMLOutput.xml string to be correct, because the server is not always adding quotes around the attributes.

[dorinbogdan]

Hi,
Did you succeed to solve the problem ?
If yes, please let me know, in order to close the thread.
Thanks,
Dorin.

[sushweta8]

Hi,
Did you succeed to solve the problem ?
If yes, please let me know, in order to close the thread.
Thanks,
Dorin.

No, I haven't been able to resolve this, the error occurs only when the number of rows returned by the sql query is more.