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:
forming a SKU (1999)
multiple record replace (2001)
Triggers-Deadlock (2000)
Searchable Talklist Archive (1998)
RE: what characters are replaced for tab and CR? (1998)
emailer (1997)
Max Record length restated as maybe bug (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
set header in DB (no cart) (2003)
Firesite cache vs webcat cache (1997)
Calendar using WebCatalog? (1997)
So, does anyone have developer editon running on Win XP (2006)
Banner DNA (1997)
Feature req. (2002)
Serving images from databases (1998)
Emailer again & again (1997)
Bug or syntax error on my part? (1997)
Questions on Mac WC 3.0.5b13 (2000)
grep twice or a better way.... (2007)
5.0 Pricing (2003)