|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
|
|||
|
|||
|
Update query
I know this is really stupid but i'm having trouble with update info to my database.
this is the piece of code i'm using <% username = Session("username") dim firstname firstname = Request.Form("firstname") Set DatConn= Server.CreateObject("ADODB.Connection") DataConn.Open "DSN=database" SQLask = "UPDATE [details] SET [details].[firstname]=' " & firstname & " ' WHERE [details].[username] like '%" & username & "%';" DataConn.Execute SQLask DataConn.Close Set DataConn= Nothing %> The error i'm getting is "Operation must use an updateable query." Can someone tell me where I'm going wrong. thanks sf |
|
#2
|
||||
|
||||
|
This error usually means that you're using an Access Database that doesn't not have the correct write permissions setup. The IUSR_machinename user must have write permission, as must any users using an NT account on the machine.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > General SQL Development > Update query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|