Trouble with Response.Write([long string here])

[myth0s]

(After thinking about it, maybe this should have been posted in the .NET forum...)

Hi,

I have a stored procedure in SQL Server that sends me a 3000+ char pre-formatted XML string. I use "FOR XML EXPLICIT" and it works really well when I do the query in Management Studio.

But, when it comes to output, something goes wrong. My output code is very basic, I don't know if it could be better. I use ExecuteScalar since the procedure returns the pre-formatted XML string in a 1X1 "table".

Response.Write( "<?xml version=""1.0"" encoding=""UTF-8"" ?>")
Response.Write( "<Listelivraiso ns>") 'This is the "root element
Response.Write( db.ExecuteScala r(cmdCalendrier _xml))
Response.Write( "</Listelivraisons >") 'End of the root

I can see string but the later half (or so) of it is missing.

Actually, if I look at the source of my XML page with IE, I can see that the file ends with :
<Livraison id="6"><JOB_NO> 68756</JOB_NO><CUST_C</Listelivraisons >

I really don't know why. When I execute the query with Management Studio, the "livraison" id 6 is complete and there's even another record of two after it. But it just won't show if I Response.Write.

I tried using DataReader and other things instead of ExecuteScalar, it didn't change a thing. I tried using Response.Output .Write, with no dice.


Should I be using a buffer or something??

[CroCrew]

Hello myth0s,

It somewhat sounds like you need to flush out the response. Are you looping your “response.write ”s? If you are then try flushing between loops using the “response.flush ” command.

Sorry for the short possible answer. But, I will look for a better one.

Hope this helped out~

[myth0s]

Hello myth0s,

It somewhat sounds like you need to flush out the response. Are you looping your “response.write ”s? If you are then try flushing between loops using the “response.flush ” command.

Sorry for the short possible answer. But, I will look for a better one.

Hope this helped out~

No, I'm not looping Response.Write since ExecuteScalar returns the string directly. (ExecuteScalar is "designed" to return the value of the first row of the first column, instead of a DataSet).

I have added Response.flush nonetheless, hoping it would help, but no. I have a vague felling that my string is too long or something. I used MS Word to count and the string always cuts off after exactly 2033 characters.....

[myth0s]

No, I'm not looping Response.Write since ExecuteScalar returns the string directly. (ExecuteScalar is "designed" to return the value of the first row of the first column, instead of a DataSet).

I have added Response.flush nonetheless, hoping it would help, but no. I have a vague felling that my string is too long or something. I used MS Word to count and the string always cuts off after exactly 2033 characters.....

Now that I have noticed that my string cuts off after 2033 characters, I have found this : http://www.informit.co m/articles/article.aspx?p= 25339&seqNum=4

I will let you know if it works :/

[myth0s]

Now that I have noticed that my string cuts off after 2033 characters, I have found this : http://www.informit.com/articles/art...25339&seqNum=4

I will let you know if it works :/

Should anyone find this page using google while searching why in the world their string was being trimmed down (incomplete data, missing data). Apparently, even if you use ExecuteScalar, the string is cut to 2033 characters.

The solution is in the link above. It works great with SQL Server returning "FOR XML" data.

I have changed my output code to

Dim db As Database = DatabaseFactory.CreateDatabase("SQLServer") 'I am using Enterprise Library from Microsoft
        Dim cmdCalendrier_xml As DbCommand = db.GetStoredProcCommand("production.lv_calendrier_xml")
        db.AddInParameter(cmdCalendrier_xml, "@date_activite_min", DbType.Date)
 
        Dim buffer As System.Text.StringBuilder = New System.Text.StringBuilder()
        buffer.Append("<?xml version=""1.0"" encoding=""UTF-8"" ?>")
        buffer.Append("<Listelivraisons>")
 
        Dim dataReader As IDataReader = db.ExecuteReader(cmdCalendrier_xml)
 
        While (dataReader.Read())
            buffer.Append(dataReader.GetString(0))
        End While
 
        buffer.Append("</Listelivraisons>")
        Response.Write(buffer.ToString)

Thanks for your help, CroCrew