Hallo Stefan,
Na ja, kein ODBC? Ist zwar nicht meinbe ST�RKE, aber vieleicht hilft dir
das?
DEINE ANWEISUNG
strConnection = "Driver={Microsoft Access Driver (*.mdb)};DBQ="
strConnection = strConnection & Server.MapPath("chat.mdb")
strConnection = strConnection & ";DriverId=25;FIL=MS
Access;MaxBufferSize=512;PageTimeout=5;"
Set conn = CreateObject("ADODB.Connection")
conn.Open strConnection
Set rs = CreateObject ("ADODB.Recordset")
Set rs.ActiveConnection = conn
rs.Cursortype = 1
rs.Locktype = 3
rs.Source "SELECT * FROM online WHERE User =" & Request.Cookies("nick") <--
Falsch, ja genau
rs.Source "SELECT * FROM online WHERE User =" & Request.Cookies("nick")&""
<-- Besser, vieleicht?
rs.Open
rs.fields("Farbe") = strFarbe
rs.Update
rs.Close
MEIN Vorschlag
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("chat.mdb"))
set rs = Server.CreateObject("ADODB.recordset")
rs.Open "SELECT * FROM online WHERE User =" & Request.Cookies("nick")",
conn, 3, 1, 1
| Oft Gefragtes: http://www.aspgerman.com/aspgerman/faq/
| [aspdebeginners] als [email protected] subscribed
| http://www.aspgerman.com/archiv/aspdebeginners/ = Listenarchiv
| Sie knnen sich unter folgender URL an- und abmelden:
| http://www.aspgerman.com/aspgerman/listen/anmelden/aspdebeginners.asp
