update database from ASP

myle · #1 (**permalink**) 06-28-08, 01:33

I have

Code:

Set DB = server.CreateObject("adodb.connection")
db.Provider ="MSDataShape"
db.open(connstring)

which work works and I have this

Code:

Set rs = db.Execute("Cleanup") 'delete query to clean data
Set rs = db.Execute("AddPagesnumbers") 'append query to GROUP the data
db.Close

if I run it get no error but if I open the database there no data if I close it and open it again the data there
open it the sec time I see the data
like there a time delay on see the data

anyway of refrenshing the tables I have updated.

as I want then read the data from the freshly updated tables and post them on A NEW Page.

gvee · #2 (**permalink**) 06-28-08, 08:02

I'm assuming the commands you are executing are stored procedures; how long do these take to execute?

myle · #3 (**permalink**) 06-28-08, 20:31

Not Long at all

gvee · #4 (**permalink**) 06-29-08, 07:38

Your ASP code is very funny... You don't execute update or delete statements with a recordset object, just directly against the connection will do.

Why don't you opena recordset of the updated items as soon as you've run your update command? See if the data has changed - I bet you will find it has!

myle · #5 (**permalink**) 06-29-08, 16:42

they are stored querys in the database
What happen is a CSV file is uploaded which is replace with a file already there which is a link table.
"Cleanup" delete the data from a table
"AddPagesnumbers" append the CSV file base on a join from an other table

the reason for doing this is the iis server goes into over drive if i read the CSV link file
Its the easyest way i found to get exturnall data into a database.
yes I have the script check the CSV file I do 2 checks
1 is it a CSV ext
2 it read the first line making shore it has the right head info ie feild names
other wise it delete the file and no update done.

Internet Services

Web Development

Digital Marketing

Consumer Tech