[thelist] Update on "Update Query not running"

[Scott Brady]

Chris Blessing:

> Forgive me for jumping in so late, but are you doing this directly through
> Access or through an external entity like an ASP page?  Have you tried
> response.write'ing the query out and then doing it manually through the
> query analyzer?

I'm doing it in ColdFusion.

I have output the generated query to the screen and copied it into an Access
query to see what happens.  It's not updating any rows that way, either. The
query runs, but it doesn't update any rows.

Scott
----------------------------------------------
Scott Brady
http://www.scottbrady.net/