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:

    
  1. 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:

Help formatting search results w/ table (1997) Mozilla/4. and Browser Info.txt (1997) [WebDNA] Stop & Start WebDNA Remotely (2011) Exclamation point (1997) RSS parser in WebDNA? (2006) Date search and sendmail (1997) Superfilous Characters (1998) Too many lines too add in one go (2003) Search for dates greater than [date] (1997) A quickie question (1997) A question on sub-categories (1997) WebCatalog (1998) Date search - yes or no (1997) What is WebDNA (1997) Including a php script (2003) Fun with Dates - finally resolved but.... (1997) PIXO with cometsite ... and/or other plugins (1998) Variable security (2000) Mozilla/4. and Browser Info.txt (1997) determining plug-ins? (1998)