tlhawkins
Posts: 16
|
| Posted: 06/28/2006, 3:43 PM |
|
I'm adding some logging to several pages and I want to log the "Sender.Connection.lastSQL" variable into the database so I can track down exactly what's happening in the DB.
This seems like a good idea and I don't get any errors but the code in the AfterExecuteUpdate never seems to execute.
the BeforeExecuteUpdate executes, but the lastSQL is not available at that time.
I'm using tbl_list and tbl_maint pages, when finished updating a record it returns to the list page with no error but the logging never occurs.
any ideas?
|
 |
 |
tlhawkins
Posts: 16
|
| Posted: 06/28/2006, 4:00 PM |
|
ok,
the event is executing... the problem is with the .lastSQL.
Now that I search I can't figure out here in the world I got that from.
Is there some way from an event to get the SQL from the event. For instance in the AfterUpdate get the SQL that was used in the Update?
Thanks
|
|
|
|
tlhawkins
Posts: 16
|
| Posted: 06/29/2006, 9:08 AM |
|
well,
I managed to figure it out myself.
I ended up adding the logging in to the Command Class where each query runs through. I just log the SQL, the UserID and the IP address of the user.
If anyone has a better method please let me know.
I would also like to be able to log the page name that the query was executed from. Is there a variable available for that through CCS, or would I be better off using request.servervariables("SCRIPT_NAME")
thanks
|
|
|
|
|
