Space in textbox

[Tommy666]

Hello everybody.
I hope you can help me.
When I get the date out of the database onto the website, there are no spaces used.
So if i need to see for example: 1234 AB, I only see 1234.
Can somebody help me to solve this problem?

[Tommy666]

here some code:

<%

Dim strConnect
strConnect = "Driver={SQL Server}; Server=***, ***; Database=***; UID=***; PWD=***;"

Dim conn
conn = Server.CreateObject("ADODB.connection")
conn.connectionstring = strConnect
conn.open()

Dim strSql
strSql = "EXECUTE TOM_HAAL_ZAKELIJKE_GEGEVENS @OrganisatieID='952'"

Dim rsClienten
rsClienten = conn.Execute(strSql)

Dim dataArr
dataArr = rsClienten.getRows

Dim i as integer

For i = 0 To 18
Response.Write(dataArr(i, 0))%> <br> <%
next
%>

<p>Functie contactpersoon</p>

<select name="Functie contactpersoon">
<option selected>Directie
<option>Administratie
<option>Administratief
<option>Administratief medewerker
<option>Algemeen
<option>Beleidsmedewerker
<option>Commercieel
<option>Consultant
<option>Management
<option>Overig
<option>Onbekend
</select><br/><br/>

<input type="button" value="Toon contactgegevens" onclick="VulAdresvelden()"><br><br>

Naam organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(0,0)%>><br><br>
Straat:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(1,0)%>><br><br>
Huisnummer:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(2,0)%>><br><br>
Postcode:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(3,0)%>><br><br>
Plaats:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(4,0)%>><br><br>
Provincie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(5,0)%>><br><br>
Land:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(6,0)%>><br><br>
Telefoon organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(7,0)%>><br><br>
Fax organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(8,0)%>><br><br>
E-mail organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(9,0)%>><br><br>
Website organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(10,0)%>><br><br>
Aanhef:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(11,0)%>><br><br>
Voornaam:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(12,0)%>><br><br>
Tussenvoegsel:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(13,0)%>><br><br>
Achternaam:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(14,0)%>><br><br>
Telefoon:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(15,0)%>><br><br>
Mobiel:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(16,0)%>><br><br>
Fax:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(17,0)%>><br><br>
Telefoon prive:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(18,0)%>><br><br>

[Tommy666]

Hello everybody.
I hope you can help me.
When I get the date out of the database onto the website, there are no spaces used.
So if i need to see for example: 1234 AB, I only see 1234.
Can somebody help me to solve this problem?

This is the code
<%

Dim strConnect
strConnect = "Driver={SQL Server}; Server=; Database=; UID=; PWD=;"

Dim conn
conn = Server.CreateObject("ADODB.connection")
conn.connectionstring = strConnect
conn.open()

Dim strSql
strSql = "EXECUTE TOM_HAAL_ZAKELIJKE_GEGEVENS @OrganisatieID='952'"

Dim rsClienten
rsClienten = conn.Execute(strSql)

Dim dataArr
dataArr = rsClienten.getRows

Dim i as integer

For i = 0 To 18
Response.Write(dataArr(i, 0))%> <br> <%
next
%>

<p>Functie contactpersoon</p>

<select name="Functie contactpersoon">
<option selected>Directie
<option>Administratie
<option>Administratief
<option>Administratief medewerker
<option>Algemeen
<option>Beleidsmedewerker
<option>Commercieel
<option>Consultant
<option>Management
<option>Overig
<option>Onbekend
</select><br/><br/>

<input type="button" value="Toon contactgegevens" onclick="VulAdresvelden()"><br><br>

Naam organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(0,0)%>><br><br>
Straat:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(1,0)%>><br><br>
Huisnummer:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(2,0)%>><br><br>
Postcode:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(3,0)%>><br><br>
Plaats:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(4,0)%>><br><br>
Provincie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(5,0)%>><br><br>
Land:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(6,0)%>><br><br>
Telefoon organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(7,0)%>><br><br>
Fax organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(8,0)%>><br><br>
E-mail organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(9,0)%>><br><br>
Website organisatie:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(10,0)%>><br><br>
Aanhef:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(11,0)%>><br><br>
Voornaam:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(12,0)%>><br><br>
Tussenvoegsel:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(13,0)%>><br><br>
Achternaam:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(14,0)%>><br><br>
Telefoon:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(15,0)%>><br><br>
Mobiel:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(16,0)%>><br><br>
Fax:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(17,0)%>><br><br>
Telefoon prive:&nbsp &nbsp &nbsp <input type=text value= <%=dataArr(18,0)%>><br><br>