Re: append db weirdness
This WebDNA talk-list message is from 1999
It keeps the original formatting.
numero = 24230
interpreted = N
texte = At 12:26 PM 11/11/99, you wrote: >Has anybody had problems with values not appearing in a db? I have a new db >that I am trying to append to, and when I open it, it appears blank, though >there are lines where the data should be appearing. By line I mean a line >return of empty data. In the show databases command, the database appears >and it states that it has x number of lines of data.When this happens there is usually something in the append that causes it to break. When I have append weirdness in my code I start breaking it up. Try appending half of the values, then the other half. If the first half make it in the DB but the second half do not, you know the problem is in the first values someplace. Keep chopping parameters out and see if you can find the one that is causing the problem. Another trick is to display the append in the page so you can see what the values are resolving to. If you have an append statement:[append db=some.db]name=[value]&name2=[value2][/append]Put just the parameters in the page: name=[value]&name2=[value2]Also, make sure you are URLizing the values before hey go into the DB. ------------------------- Technical Support Smith Micro, Internet Solutions Division Formerly, Pacific Coast Software -------------------------------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go 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
Associated Messages, from the most recent to the oldest:
| |
- Re: append db weirdness (SmithMicro Tech Support 1999)
|
At 12:26 PM 11/11/99, you wrote: >Has anybody had problems with values not appearing in a db? I have a new db >that I am trying to append to, and when I open it, it appears blank, though >there are lines where the data should be appearing. By line I mean a line >return of empty data. In the show databases command, the database appears >and it states that it has x number of lines of data.When this happens there is usually something in the append that causes it to break. When I have append weirdness in my code I start breaking it up. Try appending half of the values, then the other half. If the first half make it in the DB but the second half do not, you know the problem is in the first values someplace. Keep chopping parameters out and see if you can find the one that is causing the problem. Another trick is to display the append in the page so you can see what the values are resolving to. If you have an append statement:[append db=some.db]name=[value]&name2=[value2][/append]Put just the parameters in the page: name=[value]&name2=[value2]Also, make sure you are URLizing the values before hey go into the DB. ------------------------- Technical Support Smith Micro, Internet Solutions Division Formerly, Pacific Coast Software -------------------------------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go 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
SmithMicro Tech Support
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:
Forms Search Questions (1997)
WebCat for mass emailings (1997)
[listfiles] problems (1997)
Only charge card when product shipped ? (1997)
webcat and OS 8 (1997)
Shopping Cart Problems (2000)
Pipes instead of tabs (1998)
Re:Virtual hosting and webcatNT (1997)
Setting shipCost -- thanks! (1999)
Updating Prices in Online Database (1999)
Newbie Tax Question (1997)
Auth.net and SIM (2003)
Speed Optimization - Mac (1997)
WebCatalog stalls (1998)
Max Record length (1997)
[search] sort problem (2003)
WebCat2b15MacPlugin - [protect] (1997)
math on date? (1997)
WebCatalog2 Feature Feedback (1996)
Requiring that certain fields be completed (1997)