|
| |
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
 |
Update statement - 4/24/2008 0:01:06
I'm doing something wrong here:
I want to add the date where the id = the form field id
myDSN ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("../fpdb/test.mdb")
set conntemp=server.createobject("adodb.connection")
conntemp.open myDSN
mySQL = "UPDATE part_tracker SET detail_comp = #" & Date() & "# WHERE ID = ::ID:: "
conntemp.execute(mySQL)
conntemp.close
set conntemp=nothing
i get this error: Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'ID = ::ID::'.
if i take away the :: it updates all rows
|
|
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
|
RE: Update statement - 4/24/2008 9:33:28
Perfect, thanks Roger.
| |
|
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
|
RE: Update statement - 4/24/2008 9:55:09
now i need one more field updated and am getting an error
mySQL = "UPDATE part_tracker SET detail_comp = #" & Date() & "#, detail_by = " & Request("employee") & " WHERE ID = " & Request("ID") conntemp.execute(mySQL)
I tried several variations and get this error: Syntax error (missing operator) in query expression 'employee1'.
| |
|
|
|
rdouglass
Posts: 9167
From: Biddeford, ME USA
Status: offline
|
RE: Update statement - 4/24/2008 10:00:32
quote:
detail_by = " & Request("employee") & "
Is that a text field? If so, it needs apostrophes like so:
...detail_by = '" & Request("employee") & "' ...
See 'em?
_____________________________
Don't take you're eye off your final destination.
ASP Checkbox Function Tutorial.
| |
|
|
|
Joey
Posts: 167
Joined: 5/15/2002
From:
Status: offline
|
RE: Update statement - 4/24/2008 10:07:16
Thanks again!
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
