Re: [WebDNA] Search on a database
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108751
interpreted = N
texte = > I have created a survey form that sends its data to a db file. I would = like to query the db to retrieve each person's responses to all the = questions. A unique ID number from 12 to 16 digits is assigned to each = visitor. I'm having a hard time figuring out how to retrieve the data = using the search context. My sense is that something like a sku or ID = number that is not random, but consecutive is the way to go. [snip] Lori, can you explain more what is the issue? Aaron's quick suggestion = does meet your criteria of=20 [snip] "My sense is that something like a sku or ID number that is not random, = but consecutive is the way to go." [snip] ...BUT I don't think that is going to help you. Regardless of whether someone's "response" (record stored in your = 'visitorSurvey.db') is uniquely indexed by a "random string" handle = (field), or a "consecutive number" handle... the ease with which you = can search for a particular record, or a range of records... should be = the same easy task. So, let me ask again, where exactly are you stumped? Are you unclear = how to just search for some records (some "responses" to your survey)? = If you answer yes to that last question, then what do you want to do = exactly, search for a particular record, or search for a range of = records? If you answer "range of records" to that last question, then - = what range? ...those records that were saved on a *given date*? ...or = all those records that were the data submitted *by a particular user*? = Or... ? Or help us understand what you want to do, in english, that you do not = know how to do. -Govinda=
Associated Messages, from the most recent to the oldest:
> I have created a survey form that sends its data to a db file. I would = like to query the db to retrieve each person's responses to all the = questions. A unique ID number from 12 to 16 digits is assigned to each = visitor. I'm having a hard time figuring out how to retrieve the data = using the search context. My sense is that something like a sku or ID = number that is not random, but consecutive is the way to go. [snip] Lori, can you explain more what is the issue? Aaron's quick suggestion = does meet your criteria of=20 [snip] "My sense is that something like a sku or ID number that is not random, = but consecutive is the way to go." [snip] ...BUT I don't think that is going to help you. Regardless of whether someone's "response" (record stored in your = 'visitorSurvey.db') is uniquely indexed by a "random string" handle = (field), or a "consecutive number" handle... the ease with which you = can search for a particular record, or a range of records... should be = the same easy task. So, let me ask again, where exactly are you stumped? Are you unclear = how to just search for some records (some "responses" to your survey)? = If you answer yes to that last question, then what do you want to do = exactly, search for a particular record, or search for a range of = records? If you answer "range of records" to that last question, then - = what range? ...those records that were saved on a *given date*? ...or = all those records that were the data submitted *by a particular user*? = Or... ? Or help us understand what you want to do, in english, that you do not = know how to do. -Govinda=
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:
Include remote? (1998)
Finding max value for a field (1997)
GuestBook example (1997)
Sort Order on a page search (1997)
Re[2]: Search Engines (2000)
sql context issues (2001)
[WebDNA] WebDNA crash and now emailer not working (2009)
More on IE5 (2000)
Cancel Subscription (1996)
Not seeing cart info on Invoice.tmpl (was PROBLEM) (1997)
customer info (2001)
Plugin or CGI or both (1997)
Can't use old cart file (was One more try) (1997)
Auto-increment number, but only up to 100 then start overat 1 (2002)
RE: is sku a REQUIRED field on NT (1997)
Country & Ship-to address & other fields ? (1997)
Help name our technology! I found it (1997)
Using [redirect] in the middle of a page? (1999)
WebCatalog on Linux (2000)
Email...Thanks (1997)