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:
PayFlow Pro - Changing the Amount that was Authorized (2003)
[protect] (2000)
Resume Catalog ? (1997)
Re:Running 2 two WebCatalog.acgi's (1996)
Error Lob.db records error message not name (1997)
Missing something simple?? (1998)
WebCat hosting providers? (1997)
Frames and WebCat (1997)
Bug Report, maybe (1997)
OK to delete records while finding them? (2000)
Redhat 7.3 (2002)
[/application] error? (1997)
WebCat/CyberStudio Compatibility (1998)
Problems getting parameters passed into email. (1997)
WebDNA-Talk Digest mode broken (1997)
URGENT! ACGI Stopped!!!! (1997)
shoppingcart reload qty (1997)
best way to store prefs (1998)
Help! WebCat2 bug (1997)
Has anyone used WebCatalog with CGatePro? (2000)