|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Sql Update not working-HELP!!
Can anyone tell me why this update doesn't work? I think it's the punctuation but I don't know what to change. Updating an access database. All fields except empID are character. Please help!!
SQL = "UPDATE employees SET empname = '"& wrkname&"', &_ elogin = '"&wrklogin&"', emptype = '"&Request.Form("etype")&"', &_ empDefloc = '"&Request.Form("defsite")&"', &_ empemail = '"&Request.Form("eml")&"', &_ adminflag = '"&Request.Form("adminstat")&"', &_ epassword = '"&Request.Form("epw")&"' WHERE empId = '& Request.Form("ID")'" objCon.Execute SQL |
|
#2
|
|||
|
|||
|
Try this:
SQL = "UPDATE employees SET empname = '" & wrkname &_ "', elogin = '" & wrklogin &_ "', emptype = '" & Request.Form("etype") &_ "', empDefloc = '" & Request.Form("defsite") &_ "', empemail = '" & Request.Form("eml") &_ "', adminflag = '" & Request.Form("adminstat") &_ "', epassword = '" & Request.Form("epw")&_ "' WHERE empId = " & Request.Form("ID") Last edited by InsureDesign : April 13th, 2004 at 11:19 PM. |
|
#3
|
|||
|
|||
|
still doesn't work - any help VERY welcome
I tried adding the ampersand - still doesn't work-
SQL = "UPDATE Employees SET empname = '"& wrkname&"', &_ elogin = '"&wrklogin&"', emptype = '"&Request.Form("etype")&"', &_ empDefloc = '"&Request.Form("defsite")&"', &_ empemail = '"&Request.Form("eml")&"', &_ adminflag = '"&Request.Form("adminstat")&"', &_ epassword = '"&Request.Form("epw")&"' WHERE empId = '"& Request.Form("ID")&"'" error is: Unterminated string constant /web_sched/edtP2.asp, line 228 SQL = "UPDATE Employees SET empname = '"& wrkname&"', &_ ---------------------------------------------------------^ Last edited by mag : April 13th, 2004 at 11:08 PM. |
|
#4
|
|||
|
|||
|
I edited the other post should work.
|
|
#5
|
|||
|
|||
|
Thanks so much-it worked!
|
![]() |
| Viewing: ASP Free Forums > Database > SQL Development > Sql Update not working-HELP!! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|