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:
RE: Writefile outside WebSTAR hierarchy? (1997)
WebCatalog for guestbook ? (1997)
db Translation (2002)
Price problem (1997)
process SSI (1998)
WebCatalog NT beta 18 now available (1997)
problems with 2 tags shakur (1997)
state? (2004)
WebSTAR plugin update (2004)
Date problems-more (1997)
Speed/performance issues using .hdr (1997)
security (https) w webcat (1999)
[TaxableTotal] - not working with AOL and IE (1997)
P1: How to make webcatalog more stable. - LONG (1999)
Latest beta slow on [order] and [purchase] (1997)
WebCommerce: Folder organization ? (1997)
Exclusive Lock error (2004)
Cookies, checking if's enabled... (2004)
special commerce fields (1997)
refreshing IE with posted .tmpl (1997)