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:

    
  1. Re: [WebDNA] Question on table search (Govinda 2011)
  2. Re: [WebDNA] Question on table search ( 2011)
  3. Re: [WebDNA] Question on table search (Govinda 2011)
  4. Re: [WebDNA] Question on table search ("Terry Wilson" 2011)
  5. Re: [WebDNA] Question on table search ( 2011)
  6. Re: [WebDNA] Question on table search ( 2011)
  7. Re: [WebDNA] Question on table search ( 2011)
  8. Re: [WebDNA] Question on table search (Banahan 2011)
  9. Re: [WebDNA] Question on table search ( 2011)
  10. Re: [WebDNA] Question on table search (Banahan 2011)
  11. [WebDNA] Question on table search ( 2011)
[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:

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)