Re: [WebDNA] Search on a database
This WebDNA talk-list message is from 2012
It keeps the original formatting.
numero = 108752
interpreted = N
texte = ---1964014314-1427138982-1330703408=:86689 Content-Type: text/plain; charset=us-ascii Thank you, Aaron, for the 'autonumber' parameter. This clears up a couple of questions I've had. Govinda, You're right. There is more to the story. What I'd like to do: Create a report of responses to my survey, based on date received, i.e. see all responses that arrived on March 1. Right now, I'm viewing the db every day from my FTP program to see who responded, and how they answered the questions. Lori. >> 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 > [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--------------------------------------------------------- ---1964014314-1427138982-1330703408=:86689 Content-Type: text/html; charset=us-ascii
Thank you, Aaron, for the 'autonumber' parameter. This clears up a couple of questions I've had.
Govinda,
You're right. There is more to the story.
What I'd like to do:
Create a report of responses to my survey, based on date received, i.e. see all responses that arrived on March 1. Right now, I'm viewing the db every day from my FTP program to see who responded, and how they answered the questions.
Lori.
>> 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
[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---------------------------------------------------------
---1964014314-1427138982-1330703408=:86689--
Associated Messages, from the most recent to the oldest:
---1964014314-1427138982-1330703408=:86689 Content-Type: text/plain; charset=us-ascii Thank you, Aaron, for the 'autonumber' parameter. This clears up a couple of questions I've had. Govinda, You're right. There is more to the story. What I'd like to do: Create a report of responses to my survey, based on date received, i.e. see all responses that arrived on March 1. Right now, I'm viewing the db every day from my FTP program to see who responded, and how they answered the questions. Lori. >> 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 > [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--------------------------------------------------------- ---1964014314-1427138982-1330703408=:86689 Content-Type: text/html; charset=us-ascii
Thank you, Aaron, for the 'autonumber' parameter. This clears up a couple of questions I've had.
Govinda,
You're right. There is more to the story.
What I'd like to do:
Create a report of responses to my survey, based on date received, i.e. see all responses that arrived on March 1. Right now, I'm viewing the db every day from my FTP program to see who responded, and how they answered the questions.
Lori.
>> 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
[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---------------------------------------------------------
---1964014314-1427138982-1330703408=:86689--
Lori Palmquist
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:
Sendmail Excel attachment (2003)
AAAH: stupid sendmail (2001)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Reminder... (2003)
2.0 Beta (1997)
[shownext max=?] armed (1997)
Suggestions on best way to work with yyyy/mm/dd (1997)
http or https? (2001)
NT b19 sends extra MIME headers (1997)
WebCatalog2 for NT Beta Request (1997)
[subtotal] and others (1997)
WebCat2final1 crashes (1997)
[WebDNA] Adding Graphics to Directory (2009)
TaxTotal Problem (1997)
Re:no template caching (1997)
Error Messages Returned to User (1997)
autosensing lanague selection (1997)
Field name-subcategory (1997)
OT:Stock Quotes (2000)
bye bye tax rate (1998)