New query binds won't execute

Using Microsoft ADO I created a prepared command. This creates a bind in Oracle. It works fine and is listed below:

SELECT * FROM daily_total_display WHERE lgon_id = :V001

Due to requirements I needed to add an ORDER BY to the command, so I changed the commandtext and run the app. The new query appears in v$sqltext and v$sqlarea as listed below:

SELECT * FROM daily_total_display WHERE lgon_id = :V001 ORDER BY :V002

When I run the app it still uses the 1st query even though I've made all the proper changes. It even threw errors initially when I forgot to fill the extra parm inside the ADO command. Any ideas how to delete the first command, or why it won't use the second command?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Apr 28 2000 - 00:00:00 CDT