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
Hi,
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.
[WebDNA] Search on a database (Lori Palmquist 2012)
---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
Hi,
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.
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...