[update sql]

[Jc_]

sto diventando vecchio.
non mi aggiorna i dati nel database.
nemmeno mi ricordo se ho scritto bene l'istruzione sql.
mi ci date una controllata?
thx raga

<script runat="server">
Sub upload(sender as object, e as eventargs)

Dim connessione as new OleDbConnection("Provider=Microsoft.jet.oledb.4.0;" & "Data Source="+Server.MapPath("../battlefield/database/db1.mdb"))

dim idtrovato as string = request.QueryString("ID")

Dim Sql as string

Sql = "UPDATE FILES SET FILE = ' " & filenome.text & " ' , dimensione = ' " & filedimensione.text & " ' , descrizione = ' " & filenamedescrizione.text & " ' WHERE ID = ' " & idtrovato & " ' "

Dim Adapter as new OleDbDataAdapter(SQL,connessione)

result.text = "Ok i've just updated"

End Sub
</script>

[zampa28]

<script runat="server">
Sub upload(sender as object, e as eventargs)

Dim connessione as new OleDbConnection("Provider=Microsoft.jet.oledb.4.0;" & "Data Source=" & Server.MapPath("../battlefield/database/db1.mdb"))

dim idtrovato as string = request.QueryString("ID")

Dim Sql as string

Sql = "UPDATE FILES SET FILE = ' " & filenome.text & " ' , dimensione = ' " & filedimensione.text & " ' , descrizione = ' " & filenamedescrizione.text & " ' WHERE ID = ' " & idtrovato & " ' "

Dim MyCommand as new OleDbCommand(SQL,connessione)

Connessione.open
   MyCommand.ExecuteNonQuery
Connessione.close
result.text = "Ok i've just updated"

End Sub
</script>

[Jc_]

ho sempre amato quest'uomo.

:mavieni:

[Jc_]

<script runat="server">
Sub upload(sender as object, e as eventargs)

Dim connessione as new OleDbConnection("Provider=Microsoft.jet.oledb.4.0;" & "Data Source=" & Server.MapPath("../battlefield/database/db1.mdb"))

Dim Sql as string

SQL = "UPDATE FILES SET FILE = ' " + filenome.text + " ' , DIMENSIONE = ' " + filedimensione.text + " ' , DESCRIZIONE = ' " + filenamedescrizione.text + " ' WHERE ID = " & request.QueryString("ID") & " "

Dim MyCommand as new OleDbCommand(SQL,connessione)

Connessione.open()

   MyCommand.ExecuteNonQuery

Connessione.close
result.text = "Ok i've just updated"

End Sub
</script>

così va