Guten Morgen zusammen,
ich habe ein paar Textfiles, die ich versuche upzudaten oder ganze Zeilen zu l�schen,
geht aber nicht
folgende Fehlermeldung:
ISAM unterst�tzt das L�schen von Daten in einer verkn�pften Tabelle nicht.
/sonstige/hs~text-test.asp, line 67
mein Zugriff und sql
<%@LANGUAGE=VBScript%>
<%
option explicit
response.expiresabsolute=dateadd("d",-1,now)
response.buffer=true
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Unbenannt</title>
</head>
<body>
<%
DIM db, rs, sprache, DB_Path, sql, i, lang, ids, db_table
DIM db_IDfield, db_field, newID
db_IDField = "ID"
db_field = "de"
db_table = "MyText.txt"
lang = "de"
sql = "Select " & db_IDField & ", " & lang & " from " & db_table
DB_Path = Server.Mappath("../textfiles/")
set rs = Server.CreateObject("ADODB.Recordset")
Set db = Server.CreateObject("ADODB.Connection")
db.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & db_path & "\;" &_
"Extended Properties=""text;HDR=Yes;FMT=Delimited;"";"
set rs = db.Execute(sql)
do while not rs.eof or rs.bof
sprache = sprache & rs.fields(lang).value & "|"
ids = sprache & rs.fields(db_IDField).value & "|"
rs.MoveNext
Loop
ids = Split(Replace(ids & "|" ,"||", ""), "|")
sprache = Split(Replace(sprache & "|" ,"||", ""), "|")
for i = 0 to Ubound(sprache, 1)
Response.Write sprache(i) & "<br>"
next
rs.close
sql = "Select * from " & db_table & " where " & db_IdField & " = 0"
rs.Open(sql), db, adOpenKeySet,adLockOptimistic,adCmdText
rs.AddNew
rs.fields("de") = "test"
rs.fields("id") = Ubound(ids, 1) + 1
rs.update
NewID = rs.Fields(db_IDField).value
Response.Write NewID & "<br>"
rs.close
sql = "Update " & db_table & " set " & db_field & " = 'Neuer Test' where " &_
db_IDField & " = " & NewID
sql = "Delete * from " & db_table & " where " & db_IDField & " = " & Ubound(ids, 1)
+ 1
Response.Write sql
set rs = db.Execute(sql)
rs.Close
db.Close
Set rs = nothing
Set db = nothing
Kann ich �ber FSO entsprechende �nderungen vornehmen?
Mit freundlichen Gr��en
Hotel Andr� M�nchengladbach
Andr� Scheres
http://hotelandre.de
http://partnerhotels.com
| [aspdecoffeehouse] als [email protected] subscribed
| http://www.aspgerman.com/archiv/aspdecoffeehouse/ = Listenarchiv
| Sie k�nnen sich unter folgender URL an- und abmelden:
| http://www.aspgerman.com/aspgerman/listen/anmelden/aspdecoffeehouse.asp
