Større svar felt
Når jeg bruger nedenståendee kode er den maximale tekststreng kun på 50 tegn (dvs den tekst som findes i databasen), hvordan bliver denne ændret til eks 500 tegn?Hvordan kan jeg gøre så afstanden mellem teksten variere i takt med database teksen variere?
Koden.:
<%
Set DataConn = Server.CreateObject(\"ADODB.Connection\")
DSN = \"DRIVER={Microsoft Access Driver (*.mdb)}; \"
DSN = dsn & \"DBQ=\" & server.mappath(\"profil.mdb\")
DataConn.Open DSN
Set oplevelse = Server.CreateObject(\"ADODB.RecordSet\")
SQL = \"Select * from [oplevelse] where Id = \" & request.querystring(\"Id\")
oplevelse.Open SQL, DataConn, 1, 3
%>
<table>
<tr><td><img src=\"images/blank.gif\" width=\"10\" height=\"5\" alt=\"\" border=\"0\"></td></tr>
<tr valign=\"top\">
<td><img src=\"images/blank.gif\" width=\"10\" height=\"20\" alt=\"\" border=\"0\"></td>
<td width=\"180\">
<%
Response.Write \"<br><Font face=\'verdana, helvetica, arial, times roman\' color=\'black\' size=\'6\'>\" & oplevelse.Fields(\"navn\") & \"´s</font><br>\"
Response.Write \" <Font face=\'verdana, helvetica, arial, times roman\' color=\'silver\' size=\'7\'>Oplevelse</font>\"
%>
</td>
<td width=\"240\">
<center><Img width=\"230\" height=\"139\" border=\"0\" Src=\"images/uploads/<% if isnull(oplevelse.Fields(\"billede\")) = true then response.write(\"intet.jpg\") else response.write(oplevelse.Fields(\"billede\")) %>\"></center>
</td>
</tr>
<tr valign=\"top\">
<td colspan=\"3\"><hr width=\"80%\"></td>
</tr>
<%
Response.Write \"<table width=\'580\' cellspacing=\'0\' cellpadding=\'2\'>\"
Response.Write \"<td>\"
Response.Write \"</td>\"
Response.Write \"<td width=\'50%\'>\"
Response.Write \"</td>\"
Response.Write \"<td>\"
Response.Write \"</td>\"
Response.Write \"<td width=\'50%\'>\"
Response.Write \"</td>\"
Response.Write \"<tr>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Alder idag:</b>\"
Response.Write \"</td>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"alder\") & \"</td>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Alder ved første Piercing:</b>\"
Response.Write \"</td>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"alder1\") & \"</td>\"
Response.Write \"</tr>\"
Response.Write \"<tr>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Arbejde:</b>\"
Response.Write \"</td>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"arbejde\") & \"</td>\"
Response.Write \"</tr>\"
Response.Write \"<tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Piercet i:</b>\"
Response.Write \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"placering\") & \"</td>\"
Response.Write \"</tr>\"
Response.Write \"<tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Piercet af:</b>\"
Response.Write \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"piercer\") & \"</td>\"
Response.Write \"</tr>\"
Response.Write \"<tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Behandling af \" & oplevelse.Fields(\"piercer\") & \":</b>\"
Response.Write \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"behandling\") & \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<tr>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>hygiejnen hos \" & oplevelse.Fields(\"piercer\") & \":</b>\"
Response.Write \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"hygiejne\") & \"</td>\"
Response.Write \"<tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Problemer med piercingen:</b>\"
Response.Write \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"problem\") & \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Gjorde det ondt at blive Piercet:</b>\"
Response.Write \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"smerte\") & \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"</tr>\"
Response.Write \"<tr>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Hvorfor valgte du at blive Piercet:</b>\"
Response.Write \"<br>\"
Response.Write \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"hvorfor\") & \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<td valign=\'top\' width=\'0\' nowrap>\"
Response.Write \"<b>Hvad sagde dine venner og Familie:</b>\"
Response.Write \"<br>\"
Response.Write \"</td>\"
Response.Write \"<td valign=\'top\' nowrap>\" & oplevelse.Fields(\"venomg\") & \"</td>\"
Response.Write \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
Response.Write \"<br>\"
Response.Write \"<br>\"
Response.Write \"<table width=\'580\' cellspacing=\'0\'>\"
Response.Write \"<tr>\"
Response.Write \"<b>Uddybelse:</b>\"
Response.Write \"<br>\"
Response.Write \"<td class=\'borderTB\'>\" & oplevelse.Fields(\"uddybende\") & \"</td>\"
Response.Write \"</tr>\"
Response.Write \"</table>\"
%>
