Re: database confused

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31624
interpreted = N
texte = 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 Associated Messages, from the most recent to the oldest:

    
  1. Re: database confused (Aaron Lynch 2000)
  2. Re: database confused (Art Vargas 2000)
  3. Re: database confused (Aaron Lynch 2000)
  4. database confused (Art Vargas 2000)
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 Aaron Lynch

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:

problems with 2 tags (1997) RE: Can't get appendfile to work (1997) referrer and no caches (1997) Help with (2003) Heads up: WebCatalog 4 drops MacTCP, 68K (2000) Bug Report, maybe (1997) Cache Access Error (2000) Bug? (1997) Mozilla/4. and Browser Info.txt (1997) Problems reading files created by WC (1997) Off Topic: SNMP over TCP/IP (1998) [WebDNA] [showif] problem (2009) HELP WITH DATES (1997) Setting up the server (1997) Word-And searches (2000) WebCat2b13MacPlugIn - More limits on [include] (1997) Encryption of E-mail (1998) Browser Reloads and AddlineItem (1997) IF/THEN, SHOWIF, and/or HIDEIF (2007) Bulletin Board (1998)