syntax error, I don't see one :S

Question

Apparently i'm getting a syntax error, but I don't see any issues with my code! ``` if rs.EOF then 'User doesn't exist, create the record query = currentDate&",'" query = query + password & "','" query = query + "user', '" query = query + email & "', '" query = query + fname & "', '" query = query + sname & "'" handle = add_to_database("users","jdate,password,perms,email,fname,sname",query) response.write handle else response.write "Error: User already exists, please use a different email address" end if ``` Here is the add_to_database function ``` function add_to_database(where,column,values) 'Create query sql = "INSERT INTO " & where & " (" & column & ") VALUES (" & values & ")" on error resume next 'Add images to database conn.Execute sql,recaffected if err<>0 then add_to_database = err.description &":"&sql&"
" end if 'Destroy connection sql = "" end function ``` This is the error that is written to the page ``` Syntax error in INSERT INTO statement.:INSERT INTO users (jdate,p…

Accepted Answer

The `users` table includes a field named `password`. But `password` is a reserved word, so can confuse the db engine when it finds it in a query. Rename that field if possible. If you must keep the name as is, enclosed it in square brackets to signal the db engine it is an object name.

```
handle = add_to_database("users","jdate,[password],perms,email,fname,sname",query)
```

syntax error, I don't see one :S

Solution

Problem