Re: database confused
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31625
interpreted = N
texte = That is what I thought about the data base being all in one line. however that is how it is and it is working.Could it be that text pad is re-writing the database when I open it.there are well over 100 records with a lot of info in it no way I can re-do the database.has anybody ever seen a database like that ???----- Original Message ----- From: Aaron Lynch
To: WebCatalog Talk Sent: Monday, May 08, 2000 3:26 PM Subject: Re: database confused on 5/8/00 3:07 PM, Art Vargas at art@thewwwstore.com wrote:> I am trying to work in a page that was created by some one else, the person > who did the page no longer works with us, so I am stuck trying to make any > corrections on the page. > It is extremely hard since I don't know the logic he used to do the coding > of the page, and I am new at this too so I need your help. > > the page is for an insurance company. The insurance company has a form from > where a user can sign up. Everything works fine. But, now I have to add > another field to the form, one that includes the name of the doctor, plus > all the information of the doctor i.e. address and phone number. > > people pay with check or credit card. The structure of the site for the > check option is something like this: > > main_page.tpl > - sign_up_page.tpl > - sign_up_2.tpl > > - check.html > > Main is the usual page ( default.tpl ) > sign_up_page.tpl has the form where people sign up for the service > (name and all pertinent information.) > sign_up_2.tpl has the information that the user entered and it > also appends all the information to the database (coverage.db) > check.html has the check (people get charged the money > here) > > I had to add the new field to sign_up_page.tpl > I added the code to sign_up_2.tpl so that the new information is also > appended to the database (coverage.db) > I also added the new field doctor to the database (coverage.db) > > Once I try to see if its working the server crashes once it tries to go from > sign_up_page.tpl to sign_up_2.tpl > > The data base is in this format: > > Database-coverage.db > > 1 sku (tab) lastname (tab) firstname (tab) name (tab) primary (tab) p-month > (tab) p-day (return) > 2 (tab) p-year (tab) spouse (tab) sp-month (tab) sp-day (tab) sp-year (tab) > child1 (return) > 3 (tab) c1-month (tab) doctor (return) > 4 > 5 (appended data goes here) > > those are the fields. > does that look right? > the fact that there are returns in between the fields and then a tab at the > beginning of line 2 and 3. I just added my field after the last field. > > Thank you > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > the fields should be one one line, seperated by tabs with one return at the endfieldfield2 datadata2 datadata2 datadata2 datadata2 datadata2like that. using a .hdr fiile is WAY better. check the docs on that... -- If you have any trouble sounding condescending, find a Unix user to show you how it's done. Scott Adams ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
That is what I thought about the data base being all in one line. however that is how it is and it is working.Could it be that text pad is re-writing the database when I open it.there are well over 100 records with a lot of info in it no way I can re-do the database.has anybody ever seen a database like that ???----- Original Message ----- From: Aaron Lynch To: WebCatalog Talk Sent: Monday, May 08, 2000 3:26 PM Subject: Re: database confused on 5/8/00 3:07 PM, Art Vargas at art@thewwwstore.com wrote:> I am trying to work in a page that was created by some one else, the person > who did the page no longer works with us, so I am stuck trying to make any > corrections on the page. > It is extremely hard since I don't know the logic he used to do the coding > of the page, and I am new at this too so I need your help. > > the page is for an insurance company. The insurance company has a form from > where a user can sign up. Everything works fine. But, now I have to add > another field to the form, one that includes the name of the doctor, plus > all the information of the doctor i.e. address and phone number. > > people pay with check or credit card. The structure of the site for the > check option is something like this: > > main_page.tpl > - sign_up_page.tpl > - sign_up_2.tpl > > - check.html > > Main is the usual page ( default.tpl ) > sign_up_page.tpl has the form where people sign up for the service > (name and all pertinent information.) > sign_up_2.tpl has the information that the user entered and it > also appends all the information to the database (coverage.db) > check.html has the check (people get charged the money > here) > > I had to add the new field to sign_up_page.tpl > I added the code to sign_up_2.tpl so that the new information is also > appended to the database (coverage.db) > I also added the new field doctor to the database (coverage.db) > > Once I try to see if its working the server crashes once it tries to go from > sign_up_page.tpl to sign_up_2.tpl > > The data base is in this format: > > Database-coverage.db > > 1 sku (tab) lastname (tab) firstname (tab) name (tab) primary (tab) p-month > (tab) p-day (return) > 2 (tab) p-year (tab) spouse (tab) sp-month (tab) sp-day (tab) sp-year (tab) > child1 (return) > 3 (tab) c1-month (tab) doctor (return) > 4 > 5 (appended data goes here) > > those are the fields. > does that look right? > the fact that there are returns in between the fields and then a tab at the > beginning of line 2 and 3. I just added my field after the last field. > > Thank you > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > the fields should be one one line, seperated by tabs with one return at the endfieldfield2 datadata2 datadata2 datadata2 datadata2 datadata2like that. using a .hdr fiile is WAY better. check the docs on that... -- If you have any trouble sounding condescending, find a Unix user to show you how it's done. Scott Adams ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Art Vargas
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[UPPERCASE] (1997)
Unix line endings (2003)
PCS Frames (1997)
Major Security Hole (1998)
Internal Include Call/Request (2003)
Multiple Selections in Pull-Down Menu (2000)
File Uploads... (1997)
Help! WebCat2 bug (1997)
A Global Variable (1997)
Problem (1997)
Unknown error: OrderNotCreated (1997)
[Announce] Newest Commerce Site based on WebCatalog (1997)
Requiring that certain fields be completed (1997)
[WebDNA] Reserved Cart Headers (2008)
FYI: virus alert (1996)
can WC render sites out? (1997)
unable to launch acgi in WebCat (1997)
[Sum] function? (1997)
anyone moved to v6? (2004)
[WebDNA] Copy database from domain 1 to domain 2 (2010)