Jerryb
|
| Posted: 05/08/2003, 3:10 PM |
|
I am using CCS 2, with .asp and Access. I have a table that I need to take the data, move it to another table then delete the data from the original table. Inside access I made an append query to move the data, then a delete query to delete the data from the original table.
But how do I do this from an asp page? I also have made a macro inside access to run the two queries, but I don't see how to run the query or macro from the asp pages.
Or maybe there is another way to do this altogether? I've been pounding my head all week on this, with no luck. I don't know a lot of coding, but I am a quick learner. This is my second project with CCS, the first was with php and MySQL, and I knew nothing about either when I started.
Preferably what I need to do is have a page that shows the data from the original table, then have a button that will append and delete. So when the page refreshes the table will be empty and ready to start over.
If someone could be of some help or point me in the right direction, it would be much appreciated!
Thanks
JerryB
|
|
|
 |
Deryl
|
| Posted: 05/09/2003, 6:53 AM |
|
Jerry,
Try putting in some custom code to run the SQL queries in the ASP similar to the following:
Dim Connection
Set Connection = New clsYourConnectionNameInCodeCharge
Connection.Open
Connection.Execute ("UPDATE AccessControl SET LoginCount = LoginCount + 1 WHERE [Username] = '" & .login.Value & "'")
Connection.Close
Set Connection = Nothing
Hope that helps.
Deryl
|
|
|
|
JerryB
|
| Posted: 05/09/2003, 3:02 PM |
|
Thanks, but even that is a little bit above my head. Know of a good place to show me how to do what you are saying? Or recommend a good book?
Again, thanks for the help
JerryB
|
|
|
|
|
