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:
WebMerchant Question (2000)
Email Formatting and Encryption (1998)
[search] & [encrypt]/[decrypt] (2001)
Searching two databases (2001)
Announce: Bug fix talk list (1999)
PSC recommends what date format yr 2000??? (1997)
[defined]ish (1997)
[WebDNA] Why doesn't this returnraw redirect to the new page? (2009)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
error: Too many nested [xxx] contexts (1997)
Robert Minor duplicate mail (1997)
details (2003)
FYI: Error message (1996)
RAM variables (1997)
More on the email templates (1997)
Searching multiple fields (1997)
[protect admin] (1997)
Extended [ConvertChars] (1997)
DB not found error (2004)
select multiple (1997)