Sure!
Since I dont know how familiar you are to ASP we´ll take it step by step:
1. Run your query like this:
-----------------------------------------------
SQL = "Select firstname,lastname from People"
RS.Open SQL,Conn
2. Loop all the records until EOF is true (EOF = End Of File)...
Yeees, problem solved. Found it out myself when I had a look at the stored procedures...obviously the guy who wrote them (not me) never had in mind that the texts could be longer than 256 chars, because the procedures converted the fields to nvarchar(255). I changed the numbers and voila!
Thanks...
Thanks Deeba, that helped, but sadly not with the PDF-generating part which is the important thing in this case.
When I changed the result value in Query Analyzer it showed the whole texts, so that worked though.
How the rest works is like this:
1. An ASP-code is run executing a couple of...
Hi!
I´ve encountered a VERY annoying problem! I have an ASP-web using SQL Server 7. Now I´ve come across the problem with cut-off texts...on the webpage the texts are complete, but when I run a PDF-generating program that uses ASP and PDFlib with Stored Procedures it cuts off texts after 256...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.