Kind of lame, but here it is. I’ve been stumped all day. Can’t wait til I get this converted to SQL version, but thought I’d wait until 4.0 for that. (Fixed by then?) In the meantime…I am setting up a portal with ColdFusion. Yeah Yeah… Using access, I’m able to update a custom field (bool) but can’t find the correct syntax for ColdFusion. Access Syntax (works fine) UPDATE [Return Line] SET [Return Line].IntHere = -1 WHERE ((([Return Line].[Document No_])=“RA14792”) AND (([Return Line].[Line No_])=10000)); CF gets lexical errors if I use the [], so I escaped the spaces with quotes. Here’s the CF version: UPDATE “Return Line” SET IntHere = -1 WHERE “Document No_” = ‘RA14792’ AND “Line No_” = 10000 Seems to run all the way to the end, but then I get “driver does not support this function” I’m not Read Only, and Updates are allowed. However, the CF Select query below works just fine. SELECT “Return Line”.“Document No_”, “Return Line”.“Line No_”, “Return Line”.No_ FROM “Return Line” WHERE “Return Line”.“Document No_” = ‘RA14792’ AND “Return Line”.“Line No_” = 10000 Sure hope someone can help. I’ve already got WAY too much time messing with this C/ODBC issue. All Day, in fact.
Does ColdFusion go through OLEDB or ADO, because they often produce this kind of error? In general C/ODBC will not work through the OLEDB provider for ODBC data sources.
I’m using the ODBC to JDBC bridge from Easysoft to allow CF to ‘talk’ to the C/ODBC driver. Any select I run works fine. I actually don’t know if it’s OLEDB or ADO, if either. It’s JDBC I’m getting traces now on the working access update and the defective CF update. Always fun.