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. -Govinda On 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. -Govinda On 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:
Anyone get WebDNA working on a windows XP Home box? (2006)
Image upload (2000)
Protect vs Authenicate (1997)
WebCat for Unix?? (1997)
FlushDatabase Suggestion (1998)
Cart # Starting at 1000 (2000)
Date problem still... (2004)
Emailer setup (1997)
Multi-processor Mac info ... (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[OT] Currency feed (2005)
Summary search -- speed (1997)
Re:Searching for ALL / empty form field (1997)
WebCatalog NT beta 18 problem (1997)
Strange search... (2001)
Nested tags count question (1997)
[/application] error? (1997)
RE: Missing contexts on NT (1997)
redirect with frames (1997)
flushdatabases (2000)