Problem s SQL sintaxis

[Ivan]

Nachi problema mi e slednia:

TRiabva da izpulnia UPDATE na edno pole v baza danni na Access prez asp stranica samo che poluchavam greshka za nepravilen sintax eto koda ako niakoi moje da pomogne...



set my_Conn = Server.CreateObject("ADODB.Connection")

my_Conn.Open strConnString

strSql = "SELECT count FROM DB_tblcounter "

set rs1= Server.CreateObject("ADODB.Recordset")

rs1.open strSql, my_Conn

users = rs1("count")

users= users + 1

strSql = "UPDATE DB_tblcounter SET count = users WHERE ID = 1"

my_Conn.execute strSql

Greshkata ia dava na "UPDATE DB_tblcounter SET count = users WHERE ID = 1" edinstvenoto koeto mi idva na um e che ima nesuvmestimost na tipove..



tablicata

predstavliava



ID count

1 10





http://www.rootbg.com

[kod]

dim db, strConn



strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\edikvosi\edikoiasi.mdb"



Set db = CreateObject("ADODB.Connection")

db.Open strConn



sql="update products set count=" & променлива_за_Count & " where id=" & променлива_за_ID



db.execute(sql)



Така трябва да стане.

[Ivan]

OTKRIH KUDE E TUPIA BUG BAZATA E PRAVENA NA ACCSES 2002 A DRIVERA PODURJA SAMO STARATA BAZA OT ACCSES 97 SEGA SHTE SI NAPRAVIA BAZA NA STARIA ACCSES ILI SHTE PROBVAM PREZ DSN !!!!



http://www.rootbg.com

[Ivan]

Stana po lesno triabvashe samo da smenia connect stringa

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\Installs\DataBase\COUNTER.mdb"

Mersi vse pak imash da piesh bira<img src=icon_smile_big.gif border=0 align=middle>



http://www.rootbg.com

[-CTPAX-]

Това дето си го написал горе твърдо няма да тръгне какъвто и кънекшън да слагаш. Трява да е "SET count = " & users & " WHERE ID = 1", а не "SET count = users WHERE ID = 1". Може да не дава грешка, но няма да работи :-))



<font size=1>P4 1.6@2.59 (16x162), EpoX 4BDA2+, Gigabyte GF2 GTS Pro, IBM 30GB, Sony 200GST 17", Logitech MouseMan Dual Optical</font id=size1>

[Ivan]

Tova veche go vidiah i kriss si zasluji birata, no drugia problem beshe v connectiona kum bazata shtot s



strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=c:\edikvosi\edikoiasi.mdb"



davashe greshka pri zapis v bazata...



strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=D:\Installs\DataBase\COUNTER.mdb"



dokato s c toia driver trugna bez problem...



http://www.rootbg.com