Avatar billede swing Nybegynder
09. november 2001 - 15:15 Der er 10 kommentarer og
1 løsning

Databasen er tom?

Jeg har en database med 3 tabeller, der er data i, men når jeg uploader databasen til mit hotel så er den ene tabel tom??

Kære Eksperter - HJÆLP!
Avatar billede cpufan Juniormester
09. november 2001 - 15:57 #1
hvad indeholder den tomme tabel, (altså inden den er tom?)
Det er muligvis fordi serveren ikke kan håndterer filerne - eller måske er det dit ftp-program.
Avatar billede swing Nybegynder
09. november 2001 - 16:08 #2
den \"tomme\"  tabel indeholder en række varer med angivelse navn, pris osv. Der er data i basen når jeg uploader den, men de forsvinder - tabellen er helt tom når jeg dowloader den igen.

Det har virket - men lige pludselig - poof!
jeg kan godt oprette en kategori uden problemer, men opretter jeg en vare - så er basen tom
Avatar billede terry Ekspert
09. november 2001 - 21:08 #3
I find it VERY hard to believe! Once you have database uloaded, what do you do to see that it is empty? Are you trying to read information from the table with ASP?
Try opening the database with FTP and then look at the table in question. Is it Empty?
Avatar billede swing Nybegynder
09. november 2001 - 21:33 #4
Terry>>
Jep it is empty, when I reed the information with asp AND when i download it with ftp
Avatar billede terry Ekspert
10. november 2001 - 10:07 #5
I still find it hard to believe! I very much doubt that uploading the database dletes the table, so it can only be one thing in my mind and thats your ASP code that is deleting the table.

If it is correct then I have no explanation as to why, but I would try to locate the problem in this order.

Are you 100% sure that you are downloading the correct dB. Make a copy of the table in you dB BEFORE you upload.
Can you OPON the database with FTP at its uploaded location (not download) and see if the tables exist? Dont do anything with ASP until you have done this. If they exist then it must be ASP that is causing the problem.
If they exist then use some ASP and then see how it looks. Does the copy get emptied too?

Avatar billede swing Nybegynder
10. november 2001 - 10:46 #6
Thanks Terry - that sounds like at very good way to solve the problem.
Avatar billede terry Ekspert
10. november 2001 - 10:49 #7
Hi swing, and thanks for the points :o) But you dont need to give me the points if you havent solved the problem.
Avatar billede swing Nybegynder
10. november 2001 - 12:14 #8
Well Terry - you came up with a solution, that was all I wanted :-)
Avatar billede terry Ekspert
10. november 2001 - 12:16 #9
what was the solution?
Avatar billede swing Nybegynder
10. november 2001 - 13:13 #10
ASP is deleting the content of the table
Avatar billede terry Ekspert
10. november 2001 - 16:41 #11
;o)
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Dyk ned i databasernes verden på et af vores praksisnære Access-kurser

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester