[WebDNA] Search on a database

This WebDNA talk-list message is from

2012

It keeps the original formatting. numero = 108749
interpreted = N
texte = ---1540918134-827972870-1330657252=:60432Content-Type: text/plain; charset=us-asciiHi,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.Is there a way to assign a more searchable ID number? The method I'm using now to generate each ID number is: Or perhaps, would it be more efficient to search by date, and bring up all the responses that were received on a given date? If this would be better, please show the code for a search on date? I don't mind leaving the method of assigning unique ID numbers as it is. ...rest of form.tpl[showif [url][visitorUniqueID][/url]=[url][raw][visitorUniqueID][/raw][/url]][text]visitorUniqueID=[cart][/text][/showif]Here are some of the fields invisitorSurvey.db:visitorIDtheDatetheTimelearnMoredesignnamecityemailHelp would be greatly appreciated.Lori---1540918134-827972870-1330657252=:60432Content-Type: text/html; charset=us-ascii

Or perhaps, would it be more efficient to search by date, and bring up all the responses that were received on a given date? If this would be better, please show the code for a search on date? I don't mind leaving the method of assigning unique ID numbers as it is. 

</form>

Here are some of the fields in visitorSurvey.db:

Help would be greatly appreciated.

Lori