Re: [WebDNA] Search on a database
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108756
interpreted = N
texte = > Govinda, >=20 > 1. I would like to see all of the fields' values displayed because I = don't know who is responding to this survey, or when, or even the = answers to any of the questions I've asked. I'm not looking for a = certain value in each field, I'm looking for the values in general. >=20 > 2. I don't understand the function pipe character. >=20 > Lori Good.. now we'll get somewhere. 0.) A webdna "context" is composed of 3 parts: - the opening "tag" (e.g. "[search ...]"),=20 - the closing tag (e.g. "[/search]") - and the stuff in between those. 1.) when you search a db, what you put inside the opening [search ...] = (<--- in here) tag is what determines *which records will be found* by = the search. =20 BUT, In order to determine which part(s) of the found record(s) get = displayed on the page, then you focus on what is inside the = [founditems]...[/founditems] context. So in your case you want the [search] parameters (what is in here: = [search ...] (<--- in here)) to be very brief.. probably just comparing = against a single field... but you want to be sure to list all fieldnames = (in square brackets) inside the [founditems]...[/founditems] context, = which is nested inside the [search]...[/search] context, so that you can = see ALL the field values of any found records. 2.) The pipe character does not serve any function at all, in the = situation we are talking about. It is for display purposes only. You = can leave it off completely, or replace it with another character that = you like better (anything other than square brackets). The reason I said to put the pipe was just to remind you where the = square bracket was, before you removed it, when you (if you tried what I = suggested) copied your real full search context and pasted that copy = adjacent to (just before) your real full search context (with the = square brackets *removed* from the [search] and [founditems]). =20 play with everything.. and keep rattling off every little thing that you = do not get.. =20 -G=
Associated Messages, from the most recent to the oldest:
> Govinda, >=20 > 1. I would like to see all of the fields' values displayed because I = don't know who is responding to this survey, or when, or even the = answers to any of the questions I've asked. I'm not looking for a = certain value in each field, I'm looking for the values in general. >=20 > 2. I don't understand the function pipe character. >=20 > Lori Good.. now we'll get somewhere. 0.) A webdna "context" is composed of 3 parts: - the opening "tag" (e.g. "[search ...]"),=20 - the closing tag (e.g. "[/search]") - and the stuff in between those. 1.) when you search a db, what you put inside the opening [search ...] = (<--- in here) tag is what determines *which records will be found* by = the search. =20 BUT, In order to determine which part(s) of the found record(s) get = displayed on the page, then you focus on what is inside the =
[founditems]...[/founditems] context. So in your case you want the
[search] parameters (what is in here: = [search ...] (<--- in here)) to be very brief.. probably just comparing = against a single field... but you want to be sure to list all fieldnames = (in square brackets) inside the
[founditems]...[/founditems] context, = which is nested inside the
[search]...[/search] context, so that you can = see ALL the field values of any found records. 2.) The pipe character does not serve any function at all, in the = situation we are talking about. It is for display purposes only. You = can leave it off completely, or replace it with another character that = you like better (anything other than square brackets). The reason I said to put the pipe was just to remind you where the = square bracket was, before you removed it, when you (if you tried what I = suggested) copied your real full search context and pasted that copy = adjacent to (just before) your real full search context (with the = square brackets *removed* from the
[search] and
[founditems]). =20 play with everything.. and keep rattling off every little thing that you = do not get.. =20 -G=
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:
Still Stumped on ShowNext...HELP! (1997)
orders (1998)
[OT] MySQL Expert Needed (2004)
Problem with date and ranges (2002)
Problem with [isFile] [isFolder] (wc 3.0.4, iis 4) (1999)
Please.. copies of Digest for 7/29 and 7/30? (1997)
RE: How to verify email address (1997)
Download URL & access on the fly ? (1997)
[OT] RSS Feeds (2007)
Keep away (1997)
WebCatalog for guestbook ? (1997)
SKU (1997)
RAM variables (1997)
There's a bug in the math context ... (1997)
I'm new be kind (1997)
WebCommerce: Folder organization ? (1997)
Error.html (1997)
'does not contain' operator needed ... (1997)
searchable list archive (1997)
Just Testing (1997)