Re: [WebDNA] Adding hearder fields to a DB

This WebDNA talk-list message is from

2017


It keeps the original formatting.
numero = 113385
interpreted = N
texte = 978 This is a multi-part message in MIME format. --------------030004090401060104040704 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit thats what I usually do, but as I"m getting the files dynamically every night from an other server I need a trigger working... > Kenneth Grome > 17 janvier 2017 19:51 > Don't use [addfields] inside a founditems context. Use it > separately. > > BTW I have never used it so I don't even know if it works. > Normally I just flushdatabases then add new fields manually. > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us > Lawrence Banahan > 17 janvier 2017 19:02 > An other question, maybe silly again... > > As far as I know we can add new fields to a database. (the header fields) > Reading the doc have been trying this : > > [search db=Table_HN.txt&neMATRICULEdata=findall] > [FoundItems][AddFields > db=CAR_GLOB.txt]Boat_length=[LONG]&Boat_width=[bau]&Boat_deep=[Tirant][/AddFields] > > [/FoundItems][/search] > > it make sens to me that it would add always the same value, and it is > adding the same value in all the database... > > How do you add fields when you need at the top of a db? > > Can we use mydb.hdr when we use mydb.txt? > > Thanks! > --------------030004090401060104040704 Content-Type: multipart/related; boundary="------------070905040208000509070703" --------------070905040208000509070703 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit thats what I usually do, but as I"m getting the files dynamically every night from an other server I need a trigger working...

17 janvier 2017 19:51
Don't use [addfields] inside a founditems context. Use it
separately.

BTW I have never used it so I don't even know if it works.
Normally I just flushdatabases then add new fields manually.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us

Lawrence Banahan
17 janvier 2017 19:02
An other question, maybe silly again...

As far as I know we can add new fields to a database. (the header fields)
Reading the doc have been trying this :

[search db=Table_HN.txt&neMATRICULEdata=findall]
[FoundItems][AddFields db=CAR_GLOB.txt]Boat_length=[LONG]&Boat_width=[bau]&Boat_deep=[Tirant][/AddFields]
[/FoundItems][/search]

it make sens to me that it would add always the same value, and it is adding the same value in all the database...

How do you add fields when you need at the top of a db?

Can we use mydb.hdr when we use mydb.txt?

Thanks!

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --------------070905040208000509070703 Content-Type: image/jpeg; x-apple-mail-type=stationery; name="compose-unknown-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="compose-unknown-contact.jpg" /9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEC AQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgIC AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAAR CAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUK BwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAA AAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oA DAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJ VIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4 v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx +a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mR UfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbab eg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbz hbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUi yeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37y zqnlfp6FrqbwawG8/9k= --------------070905040208000509070703 Content-Type: image/jpeg; x-apple-mail-type=stationery; name="postbox-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="postbox-contact.jpg" /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgK CgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkL EBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAAR CAAZABkDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD45+H+uan4r13x/wDE7xnb6d4guNI8Kxah v1LSYLt7zWL1IIbcMXQs372ZmC5wAgAAUAA5lBXbsZ1E5OMV1Z9ZWUvgb4I/Cfwf8OP2zP8A hFbHQ9TuIfEtnpel+DLaZnuBlpYpVgKyKVDosjFRkPtDDBA4cJj6WYSmqas1pc7a+Dq4NQlJ 3T6f5H2p+zn498GfFP4aaPP8Mvh9p1n4eUNFYyQ6dJYx2MEMihUZJEVkLIdyGMsuOh4oaqTT hGV2mik6amp1ItJp+fQT/hbfi3/oMXH5D/Cuq0v6f/AMOWPc+MP+Cbvw0tm/Z7+JfxY1DTEu nOqaJHbRPCJPOXTY4Z9gzwuZZEy3baa480k1hZpb2/M3wMFPEw5trnM/Hz9lr4ifHzxT4e8S 3mrtoHhlLZgLa+Y3F3AXdSwi+crIJGLMGJUKAAc8KPm8Bm9HLacqNryb36P19D6fNMseMrKc JaJWt/l6n1F+wP8AGXWJ9N8S/APxHpsBg+FqR2t9rovBJbqA5hhsnyqjzgYyWYHYdrbQRg19 LgqEaFOVe9lJ3s/Pf5HzeNrOtXjSir2Vr+n6mL/wnfgX/oZdK/8AApf8a0+s0P50Y+yr9mZ/ 7FHxI174c+ALr9mfxJ8FJtZutJlmfV7jS9Ut91x9qG/bJDP5fzBCqEByfl7HNd1WhCtS9o3p Lujzli1hsQsNZ8ytZrbyZ1/xY8Z3vw68JHxHo0F9pGt6Prdi9ppGt6cYRc6clwnmxrM+YGdo vlGHOBkjJwR8jgsihHEOrOSlq7L/AD6n1WIzRuiopWVtSt8EPDsXwx/Z68B2t5oI03WPiHf3 XivxPcuuJ7xg7zjz29cyW4AP3RketepnNVww8lFauyRx5bTjKtzS6as8U/4Qrxn/ANEt1L/w Uy//ABNeP9Uq/wAn4Hd9Zh/N+JT+MX/J63xO/wCv+y/9I4q+xf8ABXzPkqn+9/JfqZXxg/5E i8/6+LT/ANKI682O7PYw/wASMX4Gf8l+0n/sLn/0bDW8/wDl0Jf8vD9Xq7DiP//Z --------------070905040208000509070703-- --------------030004090401060104040704-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Adding hearder fields to a DB (Lawrence Banahan 2017)
  2. Re: [WebDNA] Adding hearder fields to a DB (Kenneth Grome 2017)
  3. [WebDNA] Adding hearder fields to a DB (Lawrence Banahan 2017)
978 This is a multi-part message in MIME format. --------------030004090401060104040704 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit thats what I usually do, but as I"m getting the files dynamically every night from an other server I need a trigger working... > Kenneth Grome > 17 janvier 2017 19:51 > Don't use [addfields] inside a founditems context. Use it > separately. > > BTW I have never used it so I don't even know if it works. > Normally I just flushdatabases then add new fields manually. > > Regards, > Kenneth Grome > WebDNA Solutions > http://www.webdnasolutions.com > Web Database Systems and Linux Server Administration > > --------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us > Bug Reporting: support@webdna.us > Lawrence Banahan > 17 janvier 2017 19:02 > An other question, maybe silly again... > > As far as I know we can add new fields to a database. (the header fields) > Reading the doc have been trying this : > > [search db=Table_HN.txt&neMATRICULEdata=findall] > [founditems][AddFields > db=CAR_GLOB.txt]Boat_length=[LONG]&Boat_width=[bau]&Boat_deep=[Tirant][/AddFields] > > [/FoundItems][/search] > > it make sens to me that it would add always the same value, and it is > adding the same value in all the database... > > How do you add fields when you need at the top of a db? > > Can we use mydb.hdr when we use mydb.txt? > > Thanks! > --------------030004090401060104040704 Content-Type: multipart/related; boundary="------------070905040208000509070703" --------------070905040208000509070703 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit thats what I usually do, but as I"m getting the files dynamically every night from an other server I need a trigger working...

17 janvier 2017 19:51
Don't use [addfields] inside a founditems context. Use it
separately.

BTW I have never used it so I don't even know if it works.
Normally I just flushdatabases then add new fields manually.

Regards,
Kenneth Grome
WebDNA Solutions
http://www.webdnasolutions.com
Web Database Systems and Linux Server Administration

---------------------------------------------------------
This message is sent to you because you are subscribed to
the mailing list <talk@webdna.us>.
To unsubscribe, E-mail to: <talk-leave@webdna.us>
archives: http://mail.webdna.us/list/talk@webdna.us
Bug Reporting: support@webdna.us

17 janvier 2017 19:02
An other question, maybe silly again...

As far as I know we can add new fields to a database. (the header fields)
Reading the doc have been trying this :

[search db=Table_HN.txt&neMATRICULEdata=findall]
[founditems][AddFields db=CAR_GLOB.txt]Boat_length=[LONG]&Boat_width=[bau]&Boat_deep=[Tirant][/AddFields]
[/FoundItems][/search]

it make sens to me that it would add always the same value, and it is adding the same value in all the database...

How do you add fields when you need at the top of a db?

Can we use mydb.hdr when we use mydb.txt?

Thanks!

--------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting: support@webdna.us --------------070905040208000509070703 Content-Type: image/jpeg; x-apple-mail-type=stationery; name="compose-unknown-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="compose-unknown-contact.jpg" /9j/4AAQSkZJRgABAQEARwBHAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEC AQEBAQEBAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/2wBDAQEBAQEBAQICAgICAgIC AgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgL/wAAR CAAZABkDAREAAhEBAxEB/8QAGAAAAwEBAAAAAAAAAAAAAAAABgcICQr/xAA0EAABAwMCAgUK BwAAAAAAAAACAQMEBQYRABITIQcUMUF2CBUXIjI2N0JRtVRWkZOV0dL/xAAYAQEAAwEAAAAA AAAAAAAAAAADAAEEAv/EACQRAAICAAQGAwAAAAAAAAAAAAABAhEDMrHREyExM0FxgfDx/9oA DAMBAAIRAxEAPwDuEt+gW/ULet6oVC3rfqNQqFv0OfPn1GhUqfOmzZtKZlS5UqZMaNwzNwiJ VIl7eXLCaZIGwBl3TY8epPx2+jy2ZNPjvkwc9uhW8j7nCPhvOsQliYIeS7cvCpp8o50qwrC4 v3lsNSDbdmTEhvs2tahxpfV3WnmbbozJEw/gwdadbYExVRXKEKoSdvJcaOSqxE7/AAiX0gXx +a69/JSf9alIlste0VzaNpeFrcT9KKymotyiaZ0KRCnzacoE7Kjzn4gi2KqUh3jqDHDHv4mR UfruTWlMzlVUKIVNp9GguEJnAh0+IZjyAiisgyRDnu5azS8miKqjOTVkKqS/psG37fo1Fbab eg25b8eZPeFJBBJSjMG5HjMeyihnaauZwe4OGiju13GAcpOwBeN+U8/IkGbsiS8b7ryogmbz hbyc9REROfZhERO5ETShjPtvpGqTUyLErytS4siSwx5x2tRH4hPOI0DkjZtaJtFxuVEbIUUi yeNujlBUJGbJN6nM/Cyf2Hf60YgjvKA+NPSP4gT7axpcPtr51YWJnYn9dnAQWl722p4ot37y zqnlfp6FrqbwawG8/9k= --------------070905040208000509070703 Content-Type: image/jpeg; x-apple-mail-type=stationery; name="postbox-contact.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="postbox-contact.jpg" /9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgK CgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkL EBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAAR CAAZABkDAREAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD45+H+uan4r13x/wDE7xnb6d4guNI8Kxah v1LSYLt7zWL1IIbcMXQs372ZmC5wAgAAUAA5lBXbsZ1E5OMV1Z9ZWUvgb4I/Cfwf8OP2zP8A hFbHQ9TuIfEtnpel+DLaZnuBlpYpVgKyKVDosjFRkPtDDBA4cJj6WYSmqas1pc7a+Dq4NQlJ 3T6f5H2p+zn498GfFP4aaPP8Mvh9p1n4eUNFYyQ6dJYx2MEMihUZJEVkLIdyGMsuOh4oaqTT hGV2mik6amp1ItJp+fQT/hbfi3/oMXH5D/Cuq0v6f/AMOWPc+MP+Cbvw0tm/Z7+JfxY1DTEu nOqaJHbRPCJPOXTY4Z9gzwuZZEy3baa480k1hZpb2/M3wMFPEw5trnM/Hz9lr4ifHzxT4e8S 3mrtoHhlLZgLa+Y3F3AXdSwi+crIJGLMGJUKAAc8KPm8Bm9HLacqNryb36P19D6fNMseMrKc JaJWt/l6n1F+wP8AGXWJ9N8S/APxHpsBg+FqR2t9rovBJbqA5hhsnyqjzgYyWYHYdrbQRg19 LgqEaFOVe9lJ3s/Pf5HzeNrOtXjSir2Vr+n6mL/wnfgX/oZdK/8AApf8a0+s0P50Y+yr9mZ/ 7FHxI174c+ALr9mfxJ8FJtZutJlmfV7jS9Ut91x9qG/bJDP5fzBCqEByfl7HNd1WhCtS9o3p Lujzli1hsQsNZ8ytZrbyZ1/xY8Z3vw68JHxHo0F9pGt6Prdi9ppGt6cYRc6clwnmxrM+YGdo vlGHOBkjJwR8jgsihHEOrOSlq7L/AD6n1WIzRuiopWVtSt8EPDsXwx/Z68B2t5oI03WPiHf3 XivxPcuuJ7xg7zjz29cyW4AP3RketepnNVww8lFauyRx5bTjKtzS6as8U/4Qrxn/ANEt1L/w Uy//ABNeP9Uq/wAn4Hd9Zh/N+JT+MX/J63xO/wCv+y/9I4q+xf8ABXzPkqn+9/JfqZXxg/5E i8/6+LT/ANKI682O7PYw/wASMX4Gf8l+0n/sLn/0bDW8/wDl0Jf8vD9Xq7DiP//Z --------------070905040208000509070703-- --------------030004090401060104040704-- . Lawrence Banahan

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:

Okay, I give up... (1999) FileMaker Pro (1999) PCS Emailer's role ? (1997) Sorting error (1997) SEARCHES (2000) Tracking inbound links for discounts (1997) More on the email templates (1997) SMSI FTP - calander system (2002) HELP WITH DATES (1997) Tab Charactor (1997) [FoundItems] solved - thanks (1997) Associative lookup style? + bit more (1997) Danger of [newcart] (1999) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Country & Ship-to address & other fields ? (1997) Showif with an or (2003) hmmm (2006) Roundup function? (1997) RE: WebCatalog NT beta 18 now available (1997) Emailer (WebCat2) (1997)