|
 |
asp_web_howto thread: Blk Squares in my text file.
Message #1 by "Charles deRees" <Charliederees@h...> on Sat, 22 Sep 2001 20:59:43
|
|
I get blk squares at the end of every line within the text file I create
within an ASP script.... Does anyone know how I can get rid of them ?
Charlie
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 24 Sep 2001 16:06:26 +1000
|
|
You've probably somehow managed to insert ACSII characters for which there
is no corresponding "display" character in the font being used to display
the document...
Run charmap.exe to see what I mean. How to get rid of them probably depends
on how you're creating this document in the first place, but without some
code...
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Charles deRees" <Charliederees@h...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Monday, September 24, 2001 7:37 AM
Subject: [asp_web_howto] Blk Squares in my text file.
: I get blk squares at the end of every line within the text file I create
: within an ASP script.... Does anyone know how I can get rid of them ?
:
: Charlie
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by "Charles deRees" <charliederees@h...> on Mon, 24 Sep 2001 20:41:28 +0000
|
|
Thanks for the reply, here's some of my code :
' Write inital XML File header
%>
<% objTextFile.WriteLine "<?xml version = " & chr(34) & "1.0" & chr(34) &
"?>" + vbCRLF %>
<% objTextFile.WriteLine " <PDCatalog xmlns:PDCatalog = " & Chr(34) &
"PDCatalog.dtd" & Chr(34) &">" + vbCRLF %>
<% strXML = "" %>
<% strXML = strXML + vbCRLF %>
<% objTextFile.WriteLine strXML %>
<% objTextFile.WriteLine strXML %>
<% objTextFile.WriteLine "" + vbCRLF %>
<% objTextFile.WriteLine " <Product>" + vbCRLF %>
<%
' Build recordset to cycle through and write from
strSQL = "SELECT tblResults.Id, tblResults.Date,
tblEventLocations.Locations,.......Etc
Set rstDBEdit01 = Server.CreateObject("ADODB.Recordset")
rstDBEdit01.Open strSQL, ConnectionString, adOpenForwardOnly,
adLockReadOnly, adCmdText
' Set Result counter
ResultCounter = 1
%>
<% objTextFile.WriteLine " <Name>180501</Name>" + vbCRLF %>
<% objTextFile.WriteLine " <Category>Tweseldown</Category>" + vbCRLF %>
<% Do While Not rstDBEdit01.EOF %>
<% objTextFile.WriteLine " <Horse" & ResultCounter & ">" & "Horse NAME" &
"</Horse" & ResultCounter & ">"+ vbCRLF
objTextFile.WriteLine " <Rider" & ResultCounter & ">" &
rstDBEdit01.Fields("Rider").Value & "</Rider" & ResultCounter & ">"+ vbCRLF
objTextFile.WriteLine " <Class" & ResultCounter & ">" &
rstDBEdit01.Fields("Class").Value & "</Class" & ResultCounter & ">"+ vbCRLF
objTextFile.WriteLine " <Dressage" & ResultCounter & ">" &
rstDBEdit01.Fields("Dressage").Value & "</Dressage" & ResultCounter & ">"+
vbCRLF
objTextFile.WriteLine " <SJ" & ResultCounter & ">" &
objTextFile.WriteLine ""+ vbCRLF
rstDBEdit01.MoveNext
ResultCounter = ResultCounter + 1
Loop
objTextFile.WriteLine ""+ vbCRLF
objTextFile.WriteLine " </Product>"+ vbCRLF
objTextFile.WriteLine " <Product>" + vbCRLF
objTextFile.WriteLine " <Name>19/05/01</Name>"+ vbCRLF
objTextFile.WriteLine " <Category>Burnham Market</Category>"+ vbCRLF
objTextFile.WriteLine ""+ vbCRLF
objTextFile.WriteLine " </Product>" + vbCRLF
objTextFile.WriteLine " </PDCatalog>" + vbCRLF
Charlie,
>From: "Ken Schaefer" <ken@a...>
>Reply-To: "ASP Web HowTo" <asp_web_howto@p...>
>To: "ASP Web HowTo" <asp_web_howto@p...>
>Subject: [asp_web_howto] Re: Blk Squares in my text file.
>Date: Mon, 24 Sep 2001 16:06:26 +1000
>
>You've probably somehow managed to insert ACSII characters for which there
>is no corresponding "display" character in the font being used to display
>the document...
>
>Run charmap.exe to see what I mean. How to get rid of them probably depends
>on how you're creating this document in the first place, but without some
>code...
>
>Cheers
>Ken
>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "Charles deRees" <Charliederees@h...>
>To: "ASP Web HowTo" <asp_web_howto@p...>
>Sent: Monday, September 24, 2001 7:37 AM
>Subject: [asp_web_howto] Blk Squares in my text file.
>
>
>: I get blk squares at the end of every line within the text file I create
>: within an ASP script.... Does anyone know how I can get rid of them ?
>:
>: Charlie
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
|
|
|
View Cart
