Jump to content

gene7135

Members
  • Posts

    5
  • Joined

  • Last visited

gene7135's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. It Works!!!What is weird, I was able to use the same syntax (w/o brackets) to insert new records into the Access DB and query from. I just used the same syntax to update a 2nd field called 'Middle' and did not need brackets.For Some reason Updating a record has different rules.Like you mentioned this must be because 'First' is a reserved word.Thanks For Your Help!I appreciate it!
  2. I double CheckedLine 27 is: conn.Execute SQLThe SQL Vaiable is built from sql="UPDATE members SET " sql = sql & "First = 'Granville' WHERE ID=1"I verified the Field names and Table name are all correct. I have built many Access Update pages before and never had a problem such as this. I am not one to give up. There has to be an answer.
  3. Tried that. same error.[Output]UPDATE members SET First = 'Granville' WHERE ID=1 Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /Phillips/Tree/change_member.asp, line 27 [/Output]Seems like such a simple problem.Any Other Ideas?
  4. Hi there,I have what seems like a ver simple problem, but have gotten no where trying to fix this on my own.I am trying to update a record within an Access DB. <%ID = request("ID")First = request("First")set conn=Server.CreateObject("ADODB.Connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open "c:/websites/woodshack459/jetboatservices.com/fpdb/family.mdb"sql="UPDATE members SET "sql = sql & "First = 'Granville' WHERE ID='1'"Response.Write "<BR>" & SQLconn.Execute SQLResponse.Write "Record " & ID & " Updated!"conn.closeSet conn = Nothing%> I recieve the following syntax error when I execute it.The SQL Statement is also printed to the screen for debugging.Any Help would be great!!Thanks Gene UPDATE members SET First = 'Granville' WHERE ID='1' Microsoft JET Database Engine error '80040e14' Syntax error in UPDATE statement. /Phillips/Tree/change_member.asp, line 39
×
×
  • Create New...