Replace problem

Kan du ikke smide noget mere kode... Det er som regel fordi den kører Replace igen og at der af en eller anden grund ikk er noget i dit Recordset

Det fejlmeddelelsen siger er, at der ikke er et felt i dit recordset som hedder Text.

Min connection string ser sådan ud:

<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sti & ""

SQLstmt = "SELECT * FROM news WHERE id = " & Request("id")

Conn.Execute (SQLstmt)

Set rs = conn.Execute(SQLstmt)

newstext = Replace(rs("Text"),"<br>",vbCrLf)
%>

Men det har vist nok virket før

Kører du et gennem et loop eller har du nogle steder hvor rs("Text") er tom..? Hvis det svinger kan du altid gøre dette:

If not rs("text") = "" Then
newstext = Replace(rs("Text"),"<br>",vbCrLf)
End If

kitchain --> Jeg har chekket databasen, Text kolonnen er der skam.

nogetfx --> Giver det samme resultat

Kan du smide hele koden..?

<script language="javascript" type="text/javascript">
function apply(obj,val) {
    document.all[obj].focus();
    document.selection.createRange().text = val
}
</script>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sti & ""

SQLstmt = "SELECT * FROM news WHERE id = " & Request("id")

Conn.Execute (SQLstmt)

Set rs = conn.Execute(SQLstmt)

If not rs("text") = "" Then
newstext = Replace(rs("Text"),"<br>",vbCrLf)
End If
%><div align="left">
  <table border="0" width="100%" height="628">
    <tr>
      <td width="20%" height="17"></td>
      <td height="17"><font face="Verdana" size="1"><b>Rediger Preview/Review</b></font></td>
    </tr>
    <tr>
      <form method="POST" action="admin_config_article_save.asp">
      <input type="hidden" name="mode" value="update">
      <td width="20%" height="23"><font face="Verdana" size="1">Titel</td>
      <td height="23"><font size="1" face="Verdana"><input type="text" name="Titel" size="20" value="<%=rs("Titel")%>" onChange="document.opret.Box.value='Images/views/'+this.value+'/';document.opret.Pic1.value='Images/views/'+this.value+'/';document.opret.Pic2.value='Images/views/'+this.value+'/';document.opret.Pic3.value='Images/views/'+this.value+'/';document.opret.Pic4.value='Images/views/'+this.value+'/';document.opret.Pic5.value='Images/views/'+this.value+'/';document.opret.Pic5.value='Images/views/'+this.value+'/';document.opret.Pic6.value='Images/views/'+this.value+'/'" />
      </font>  </td>
    </tr>
    <tr>
      <td width="20%" height="246"><font face="Verdana" size="1">Text</td>
      <td height="246">
        <p><font face="Verdana" size="1"><textarea rows="15" name="Text" cols="40"><%=newstext%></textarea></font></p>
              </td>
    </tr>
    <tr>
      <td width="20%" valign="top" align="left" height="26">&nbsp;</td>
      <td height="26">
<font face="Verdana" size="1">
<img src="bold.gif" onclick="apply('Text','<b>')"/>Fed&nbsp;
<img src="bold.gif" onclick="apply('Text','</b>')"/>Fed slut<br>
<img src="image.gif" onclick="apply('Text','<img src=http://www.nintendo4you.dk/images/views/>')"/>Indsæt Billede&nbsp;
<img src="url.gif" onclick="apply('Text','<a href=></a>')"/>Indsæt Hyper-Link</font>
      </td>
    </tr>
    <tr>
      <td width="20%" height="23"><font face="Verdana" size="1">Type</td>
      <td height="23"
    <p>
    <font size="1" face="Verdana">
    <select size="1" name="type">
    <option value="preview" <% if rs("type") = "preview" then Response.Write "selected" end if %>>Preview</option>
      <option value="review" <% if rs("type") = "review" then Response.Write "selected" end if %>>Review</option>
    </select> </font>
    </p>
    </td>
    </tr>
    <tr>
      <td width="20%" height="23"><font face="Verdana" size="1">System</td>
      <td height="23"
    <p>
    <font size="1" face="Verdana">
    <select size="1" name="System">
    <option value="N64" <% if rs("System") = "N64" then Response.Write "selected" end if %>>Nintendo 64</option>
      <option value="GameCube" <% if rs("System") = "GameCube" then Response.Write "selected" end if %><B></B>>GameCube</option>
      <option value="GB" <% if rs("System") = "GB" then Response.Write "selected" end if %>>GameBoy/Pockey/Color</option>
      <option value="GBA" <% if rs("System") = "GBA" then Response.Write "selected" end if %>>GameBoy Advance</option>
      <option value="SNES" <% if rs("System") = "SNES" then Response.Write "selected" end if %>>Super Nintendo</option>
      <option value="NES" <% if rs("System") = "NES" then Response.Write "selected" end if %>>NES</option>
    </select> </font>
    </p>
    </td>
    </tr>
    <tr>
      <td width="20%" align="left" height="23"><font face="Verdana" size="1">Box Art</font></td>
      <td height="23">
        <p><font size="1" face="Verdana">
        <input type="text" name="Box" size="50" value="<%=rs("Box")%>"></font></p>
      </td>
    </tr>

    <tr>
      <td width="20%" height="15">&nbsp;</td>
      <td height="15"></td>
    </tr>

    <tr>
      <td width="20%" height="19"><font face="Verdana" size="1">Karakter Grafik</font></td>
      <td height="19"><font size="1" face="Verdana">
      <input type="text" name="karakterGrafik" value="<%=rs("karakterGrafik")%>" size="2"></font></td>
    </tr>

    <tr>
      <td width="20%" height="19"><font face="Verdana" size="1">Karakter Lyd</font></td>
      <td height="19"><font size="1" face="Verdana">
      <input type="text" name="karakterLyd" value="<%=rs("karakterLyd")%>" size="2"></font></td>
    </tr>

    <tr>
      <td width="20%" height="19"><font size="1" face="Verdana">Karakter
      GamePlay</font></td>
      <td height="19"><font size="1" face="Verdana">
      <input type="text" name="karakterGamePlay" value="<%=rs("karakterGamePlay")%>" size="2"></font></td>
    </tr>

    <tr>
      <td width="20%" height="19"><font face="Verdana" size="1">Karakter Holdbarhed</font></td>
      <td height="19"><font size="1" face="Verdana">
      <input type="text" name="karakterHoldbarhed" value="<%=rs("karakterHoldbarhed")%>" size="2"></font></td>
    </tr>

    <tr>
      <td width="20%" height="19"><font face="Verdana" size="1">Karakter Overall</font></td>
      <td height="19"><font size="1" face="Verdana">
      <input type="text" name="karakterOverall" value="<%=rs("karakterOverall")%>" size="2"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">&nbsp;</td>
      <td height="26">&nbsp;</td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Screenshot 1</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Pic1" size="50" value="<%=rs("Pic1")%>"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Screenshot 2</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Pic2" size="50" value="<%=rs("Pic2")%>"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Screenshot 3</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Pic3" size="50" value="<%=rs("Pic3")%>"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Screenshot 4</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Pic4" size="50" value="<%=rs("Pic4")%>"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Screenshot 5</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Pic5" size="50" value="<%=rs("Pic5")%>"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Screenshot 6</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Pic6" size="50" value="<%=rs("Pic6")%>"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">&nbsp;</td>
      <td height="26">&nbsp;</td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Udvikler</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Udvikler" value="<%=rs("Udvikler")%>" size="20"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Udgiver</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Udgiver" value="<%=rs("Udgiver")%>" size="20"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="22">
      <font face="Verdana" size="1">Genre</font></td>
      <td height="22"><font size="1" face="Verdana">
      <input type="text" name="Genre" value="<%=rs("Genre")%>" size="20"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Spillere</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Spillere" value="<%=rs("Spillere")%>" size="20"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Alders Grænse</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Alder" value="<%=rs("Alder")%>" size="20"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">
      <font face="Verdana" size="1">Releasedato</font></td>
      <td height="26"><font size="1" face="Verdana">
      <input type="text" name="Releasedate" value="<%=rs("Releasedate")%>" size="20"></font></td>
    </tr>

    <tr>
      <td width="20%" valign="top" align="left" height="26">&nbsp;</td>
      <td height="26"><font face="Verdana" size="1"><input type="submit"></font></td>
    </tr>
  </table>
  </form>
</div>
<center>
<font face="Verdana" size="1">
<a href="admin.asp">Tilbage til Admin</a>
<br>&nbsp;
</font>
</center>
<%
conn.Close
Set conn = nothing
Set SQLstmt = nothing
%>

Hvilken linie er nr. 58 ??

Fejlen betyder du bruger rs("kolonnenavn") hvor kolonnenavn ikke findes i recordsetet. Det kan så enten skyldes kolonnenavn ikke findes i databasen eller det kan skyldes du ikke har med taget det i en SELECT'en i SQL sætninge: "SELECT id,navn FROM xxx" og så udskriver rs("dato") så kommer fejlen.

Du bruger følgene kolonnenavn omkring linie 58:  rs("type") så måske type ikke findes??

I stedet for SELECT * FROM ...., så skriv de felter du gerne vil have ud. Det gør det selvfølgelig heller ikke bedre at både Text og Type er reserverede ord.