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:

Moving records (2000) Getting total number of items ordered (1997) Simple way to create unique SKU (1997) Am I going senile? (Price recalc based on quantity) (1997) RE: Nesting [ListFiles] (1998) Requiring that certain fields be completed (1997) Online reference (1997) Showif probably dumb question (1997) Searching multiple Databases (1997) Zeroing out shipping costs (2000) Re[2]: Weird [blank] interpretation (1999) success - serial numbers and webmerch (1997) WebDNA Verison 4.5 will Not Restart! This SUCKS! (2002) Tax and Shipping Examples (1997) WebCat2b15MacPlugin - showing [math] (1997) [WebDNA] annoucement - WebDNA 8.0.2 (2015) A Global Variable (1997) WebCat2b13 Command Reference Doc error (1997) Help with Shipping Costs (1997) Running 2 two WebCatalog.acgi's (1996)