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:
[WebDNA] StandardConversions.db (2016)
SAVECART (1997)
Character limit in [Search]? (1998)
question: writing files textb in webmerch (1997)
[WriteFile] problems (1997)
[random] only for 1-100??? (1997)
$Replace with [founditems] (1997)
Running _every_ page through WebCat ? (1997)
WebCat2 - [format thousands] (1997)
[WebDNA] [OT] DNS Services (2010)
All choice in popups (1997)
WebCat2b15MacPlugin - showing [math] (1997)
RE: Template not found error messages (1997)
Javascript and Search Results (1998)
Does webcatalog recognise NULL values? (1998)
WebSTAR, OSX, WebDNA permissions problem ... (2005)
[WebDNA] WebDNA7 site randomly dropping tags (2011)
searchable list archive (1997)
Shhh... (2006)
RE: Languages (1997)