Re: [WebDNA] Question on table search
This WebDNA talk-list message is from 2011
It keeps the original formatting.
numero = 107186
interpreted = N
texte = [table]s do need commas where you define the field names. (Or maybe =tabs work there too? I never tried that. Terry is that what you =meant?) Anyway the docs say to use commas there.. and that does work. =*BUT* (new topic) the table records should be written just like you find =them in any other webdna database! If you write them out (populate your =[table]) like you see in the docs, then you need to use tabs in the =right places.. to delimit the data from one field to another. If you =instead use [append] or [replace ...&append=3DT] to add records to your =table (populate your [table])... then webdna takes care of putting the =tabs in the right places for you.-GovindaOn 2011-08-09, at 2:50 PM,
=wrote:> Hello Govinda>=20> Yes, that was indeed the problem, the example has a comma(,) in the =table> description, but the data has a space( ) or a tab, which is why my =test did> not work.>=20> I got it working though, just to determine that I couldnt use the =solution> in this particular situation.>=20> Thanks for the help all.>=20> /Tommy> On Tue, 9 Aug 2011 11:07:40 -0400, Govinda => wrote:>>> Okay, the example is flawed.>>>=20>>> WHile I should have caugt that there is no , in the table =description -> I>>> pulled it directly from the dokumentation. I got it working by =adding a> ,>>> to the products table>>>=20>>> /Tommy>>=20>> Hi Tommy>>=20>> I had a hard time following your issue.. the way you described it.. =but> am>> *guessing* that at least one issue you had was that perhaps you did =not>> inset tabs between the fields in the data you loaded into the table. =If>> you copied and pasted from the docs then you may have missed that =point.>>=20>> ..but anyway I have had some strange/inconsistent experiences using> tables>> when I load them the way the docs suggest to (even properly). =Instead,> I>> recommend loading them with either [append], or [replace.. =&append=3DT].>> Like so:>>=20>> [table name=3Dproducts&fields=3DSKU,NAME][/table]>> [Append table=3Dproducts]SKU=3D1001&NAME=3DRed Widget[/Append]>> etc.>>=20>> -Govinda>>=20>> --------------------------------------------------------->> 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> ---------------------------------------------------------> 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
Associated Messages, from the most recent to the oldest:
[table]s do need commas where you define the field names. (Or maybe =tabs work there too? I never tried that. Terry is that what you =meant?) Anyway the docs say to use commas there.. and that does work. =*BUT* (new topic) the table records should be written just like you find =them in any other webdna database! If you write them out (populate your =[table]) like you see in the docs, then you need to use tabs in the =right places.. to delimit the data from one field to another. If you =instead use [append] or [replace ...&append=3DT] to add records to your =table (populate your [table])... then webdna takes care of putting the =tabs in the right places for you.-GovindaOn 2011-08-09, at 2:50 PM, =wrote:> Hello Govinda>=20> Yes, that was indeed the problem, the example has a comma(,) in the =table> description, but the data has a space( ) or a tab, which is why my =test did> not work.>=20> I got it working though, just to determine that I couldnt use the =solution> in this particular situation.>=20> Thanks for the help all.>=20> /Tommy> On Tue, 9 Aug 2011 11:07:40 -0400, Govinda => wrote:>>> Okay, the example is flawed.>>>=20>>> WHile I should have caugt that there is no , in the table =description -> I>>> pulled it directly from the dokumentation. I got it working by =adding a> ,>>> to the products table>>>=20>>> /Tommy>>=20>> Hi Tommy>>=20>> I had a hard time following your issue.. the way you described it.. =but> am>> *guessing* that at least one issue you had was that perhaps you did =not>> inset tabs between the fields in the data you loaded into the table. =If>> you copied and pasted from the docs then you may have missed that =point.>>=20>> ..but anyway I have had some strange/inconsistent experiences using> tables>> when I load them the way the docs suggest to (even properly). =Instead,> I>> recommend loading them with either [append], or [replace.. =&append=3DT].>> Like so:>>=20>> [table name=3Dproducts&fields=3DSKU,NAME][/table]>> [Append table=3Dproducts]SKU=3D1001&NAME=3DRed Widget[/Append]>> etc.>>=20>> -Govinda>>=20>> --------------------------------------------------------->> 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> ---------------------------------------------------------> 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
Govinda
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:
WebCatalog2 Feature Feedback (1996)
authorize net (2001)
Shipcost lookup? (1997)
Just Testing (1997)
[append] problem (1997)
JavaScript form question (2001)
Re:WebDNA Writer Needed (1997)
Register First (2000)
Instructions for Digest (1997)
WebDNA Solutions ... sorry! (1997)
WebCat virtual postcard is done! Thanks for the help! (1998)
Explorer 3.0/ Access Denied! (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
OS X Problem... (2000)
Upload Maximum (2003)
Dividers (2003)
Help name our technology! I found it (1997)
Bug Report, maybe (1997)
ShowNext (1997)
Databases inside [SHOWIF] (1998)