Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

with your original query, I'm willing to bet it was having the error here....

<CFQUERY NAME="CHUpdate" DATASOURCE="inout">
UPDATE users
SET Name='#Form.Name#',
in='#Form.in#', <!--- with the use of "in" it's thinking it's part of a statement rather than a column name --->
out='#Form.out#',
destination='#Form.destination#'
WHERE ID=#val(URL.ID)#
</CFQUERY>

you'd see IN used normally in a where clause example: WHERE id IN (1,2,3)
to get around column names such as "in" you would put brackets around it example [in] so it knows it's not a function of the statement.

0

austintreAuthor Commented: 2006-10-26

You were correct. It was because I had named a field the same as a SQL syntax word.