Re: database confused
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31626
interpreted = N
texte = on 5/8/00 3:32 PM, Art Vargas at art@thewwwstore.com wrote:> 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 > end > > fieldfield2 > datadata2 > datadata2 > datadata2 > datadata2 > datadata2 > > like 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 > Well, your text editor is probably wrapping the text. That's different. Textpad might well be mangling the returns... Go to tucows and download a copy of ultraedit. -- ------------------------------------------------------------- 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:
on 5/8/00 3:32 PM, Art Vargas at art@thewwwstore.com wrote:> 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 > end > > fieldfield2 > datadata2 > datadata2 > datadata2 > datadata2 > datadata2 > > like 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 > Well, your text editor is probably wrapping the text. That's different. Textpad might well be mangling the returns... Go to tucows and download a copy of ultraedit. -- ------------------------------------------------------------- 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 adding stuff to the shopping cart. (1997)
Anyone have an invoicing system? (1999)
Emailer setup (1997)
WebCatalog f2 Installation (1997)
NT b19 sends extra MIME headers (1997)
Autonumber (2003)
Single Link browsing (1997)
PIXO (1997)
[blank] (2005)
Trying to loop for letters (1999)
WebDNA won't start on Apache/iTools7 (2003)
WebCatalog2 Feature Feedback (1996)
authenticating a second user (1997)
WebCommerce: Folder organization ? (1997)
Freeze (2003)
WebCatalog Use Question (1997)
wierd [cart] action! (1997)
small job/demo setup (1999)
Date/Sort/Read Date Format? (1999)
[WebDNA] 6.2 Monitor (2012)