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 acopy 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:

Re: database confused (Aaron Lynch 2000)
Re: database confused (Art Vargas 2000)
Re: database confused (Aaron Lynch 2000)
database confused (Art Vargas 2000)

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 acopy 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!

Re: database confused

2000

Top Articles:

Related Readings: