BUG: database "creation"
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 54974
interpreted = N
texte = Macintosh Plugin version 4.5.1 I imagine that many people create initial databases locally by manipulating flat text files and then uploading them to the server. From that point on all database access is done through WebCat pages. There is a problem if your data is not in sync with your headers. Try this. Create a text file locally. (I'm using
, and to indicate the single characters) F1F2 12 34 Note that one each data line there is a blank field that is not defined in the headers. Upload the file to your server and then open it with any webdna database command. Close and commit the database and then examine it with a text editor. What you get is this: F1F2 12 34 I'm calling this a bug since WebDNA is specifically changing the data in the second field. I understand that there is an extra field in the original database, and maybe webDNA should ignore /that/ field. But it should never change the valid data. So now if you try and use the database you get messed up results. [text]myResult=not in database[/text] [search db=test.db&eqF1data=findall] [founditems] [showif [F2]=2] [text]myResult=#2 is at record [index][/text] [/showif] [/founditems] [/search] [myResult] This page will always display "not in database" ~joe -- _______________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access ~ WebCat programming ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- BUG: database "creation" ( Joe D'Andrea 2003)
|
Macintosh Plugin version 4.5.1 I imagine that many people create initial databases locally by manipulating flat text files and then uploading them to the server. From that point on all database access is done through WebCat pages. There is a problem if your data is not in sync with your headers. Try this. Create a text file locally. (I'm using , and to indicate the single characters) F1F2 12 34 Note that one each data line there is a blank field that is not defined in the headers. Upload the file to your server and then open it with any webdna database command. Close and commit the database and then examine it with a text editor. What you get is this: F1F2 12 34 I'm calling this a bug since WebDNA is specifically changing the data in the second field. I understand that there is an extra field in the original database, and maybe webDNA should ignore /that/ field. But it should never change the valid data. So now if you try and use the database you get messed up results. [text]myResult=not in database[/text] [search db=test.db&eqF1data=findall] [founditems] [showif [F2]=2] [text]myResult=#2 is at record [index][/text] [/showif] [/founditems] [/search] [myResult] This page will always display "not in database" ~joe -- _______________________________________________________________ Joseph D'Andrea ~ http://www.west21.com/ ~ JoeDan@West21.com WEST21.com Internet services for the 21st Century webhosting ~ co-location ~ wireless access ~ WebCat programming ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Joe D'Andrea
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:
[WebDNA] Strange happenings (2012)
The beginning (1997)
Loop context to replace items (1998)
syntax question, not in online refernce (1997)
WebDNA color code chart - oops (2002)
credit card - Revised (1997)
Math Enhancement Request (2004)
WebCommerce: Folder organization ? (1997)
Server crash (1997)
Sv: Search problems! (1999)
Bug alert! (1997)
Claris HomePage messes up the code (1997)
problems with 2 tags (1997)
[OT] Flash & WebDNA (2003)
Image Upload and Auto Resize? (2003)
Gold on the list ... Was Authorize.net? (2003)
carriage returns in data (1997)
Is there a max number of fields? (1998)
Formating Tables w/[founditems] (1998)
Re:WebCatalog/WebMerchant III (1998)