rbaldwin
Posts: 172
|
| Posted: 05/19/2004, 5:21 AM |
|
I would like to see the SQL statement that is about to be invoked just prior to the UPDATE.
|
 |
 |
rbaldwin
Posts: 172
|
| Posted: 05/19/2004, 7:40 AM |
|
Found it myself.
response.write RFP_CADBusAccounts.Command.SQL & " WHERE " & RFP_CADBusAccounts.Command.Where
|
|
|
|
sewells
Posts: 13
|
| Posted: 06/13/2004, 9:20 PM |
|
if you run msde locally and execute the profiller you can see all the sql commands as your application runs. I use this frequently to ensure my SQL statements are lean and only pulling the required data only. CCS tends to want to do select * when only a couple fields are actally required.
|
|
|
|
|
