hi people :-)



What that mean ??



Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

Query cannot be updated because it contains no searchable columns to use 

as a key.

Line 108 error





this is a part of the script



---------------

kultu = 0



objsql.movefirst

objsql2.movefirst



do while nb > 0

kultu = kultu + 1



meno = request.form("menu"& kultu &"")







objsql("item") = meno

objsql.update   (this is the line 108)

objsql.movenext





kultu = kultu + 1

cont = request.form("content"& kultu &"")



objsql2("content") = cont

objsql2.update

objsql2.movenext





nb = nb - 1

loop



------------------



tank's

Do you have a primary key defined for the table in question?

Does the recordset contain the primary key?



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: "Max" <Twinsen24@h...>

Subject: [asp_database_setup] Microsoft OLE DB Provider for ODBC Drivers

(0x80004005) Query cannot be updated because...





: hi people :-)

:

: What that mean ??

:

: Microsoft OLE DB Provider for ODBC Drivers (0x80004005)

: Query cannot be updated because it contains no searchable columns to use

: as a key.

: Line 108 error

:

:

: this is a part of the script

:

: ---------------

: kultu = 0

:

: objsql.movefirst

: objsql2.movefirst

:

: do while nb > 0

: kultu = kultu + 1

:

: meno = request.form("menu"& kultu &"")

:

:

:

: objsql("item") = meno

: objsql.update   (this is the line 108)

: objsql.movenext

:

:

: kultu = kultu + 1

: cont = request.form("content"& kultu &"")

:

: objsql2("content") = cont

: objsql2.update

: objsql2.movenext

:

:

: nb = nb - 1

: loop

:

: ------------------



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~