Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8

    Unanswered: update database from ASP

    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.
    Last edited by myle; 06-28-08 at 03:02.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    I'm assuming the commands you are executing are stored procedures; how long do these take to execute?
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Not Long at all
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    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!
    George
    Home | Blog

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    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.
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •