[thelist] Update Query not running

Scott Brady evolt at scottbrady.net
Tue Jan 22 14:33:06 CST 2002


Tab wrote:

> well another reason printing your sql string with the values plugged in
> can be useful is that you can then copy the string from the browser and
> paste it into your database's debugger and sometimes that will give you
> some more clues about what's going on.

Plugging in the generated values into an Access query basically got me "You
are about to update 0 records.  Continue?"

The select query still works in Access, so I'm really not sure what's going
on there.

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






More information about the thelist mailing list