I use an Old Access DataBase,
which has a Date field with space and a quote in the field name.

I use ColdFusion language as Dynamic Server.

Field name is : "date d'entrée",
1 space, 1 quote, 1 accentuated character.

In my SQL, I used [date d'entrée],

update employes
[date d'entrée]=#createODBCdate(form.ar_date)#
where [emp_id]=#get_last_rec.max_emp_id#

and I have an error on the Date update.
If I use a simple field name, I do not have that error.
But I must use this field name.(for the moment)

Thanks for any help to tell me how to point on this type of field name
via SQL.

Pierre.

Not an Access/ColdFusion guy, but did you try double-quotes ?

In Oracle and MSSQL, this works :

update t set "date d'entrée" = a_date_expression;

Good luck.

looks like you forgot the SET keyword


rudy
http://r937.com/

No, I just forgot it here in my quetsion,
but it is there in my real code.

Thanks.

Well ? Did you try using double-quotes ?