1. data base keys
- Posted by George Walters <gwalters at sc.rr.com> Jul 31, 2001
- 438 views
I have written a program to import comma delimited ascii date from another OS and added the keys and records to the EU database system. The data appears to come back out fine, however the keys put in apparently have been modified by a trim function which removes all but one interior blank. Is this so? Or do I have a bug that I can't find? here's where I get the key key = db_record_key(cur_row) here's how I print it puts(html,"\""&key&"\"") here's what comes out " 1 1" it has had blanks trimm'ed out. this is what went into the data base. one blank before the 1st one and 4 blanks betweenthe 2 one's. " 1 1" does anyone have this problem, or know if I did something wrong? I check the incomming key here and it is correct. key = record[1..loc-1] puts(1,key&"\n") <------------ correct here comming in to the data base from the ascii file. and added to the database here a = insertRecord(key,outRecord) ..george
2. Re: data base keys
- Posted by Robert Craig <rds at RapidEuphoria.com> Jul 31, 2001
- 430 views
George Walters writes: > ... the keys put in apparently have been > modified by a trim function which removes > all but one interior blank. Is this so? > Or do I have a bug that I can't find? > here's how I print it > > puts(html,"\""&key&"\"") > here's what comes out > > " 1 1" > > it has had blanks trimm'ed out. > this is what went into the data base. one > blank before the 1st one and 4 blanks between the 2 one's. > > " 1 1" It looks like you are writing this to a .html file, and displaying it with a Web browser. In HTML, multiple blanks are equivalent to one blank, unless you force the issue by using ( ampersand nbsp semicolon ) I hope this shows up on the Web interface! You can also make a pre-formatted section using <pre> ... </pre> ( pre ... end-pre ) Regards, Rob Craig Rapid Deployment Software http://www.RapidEuphoria.com
3. Re: data base keys
- Posted by George Walters <gwalters at sc.rr.com> Jul 31, 2001
- 484 views
thanks, you're absolutely correct... I've printed them out directly in EU and they are correct...I had forgotten that browsers trim'd blanks... ..thanks.. ..george ----- Original Message ----- From: "Robert Craig" <rds at RapidEuphoria.com> To: "EUforum" <EUforum at topica.com> Subject: Re: data base keys > > George Walters writes: > > ... the keys put in apparently have been > > modified by a trim function which removes > > all but one interior blank. Is this so? > > Or do I have a bug that I can't find? > > > here's how I print it > > > > puts(html,"\""&key&"\"") > > > here's what comes out > > > > " 1 1" > > > > it has had blanks trimm'ed out. > > this is what went into the data base. one > > blank before the 1st one and 4 blanks between the 2 one's. > > > > " 1 1" > > It looks like you are writing this to a .html file, > and displaying it with a Web browser. > In HTML, multiple blanks are equivalent to one blank, > unless you force the issue by using > ( ampersand nbsp semicolon ) > I hope this shows up on the Web interface! > You can also make a pre-formatted section > using <pre> ... </pre> > ( pre ... end-pre ) > > Regards, > Rob Craig > Rapid Deployment Software > http://www.RapidEuphoria.com > > > > >