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.--------------------------------------------------------- =This message is sent to you because you are subscribed to the mailing =list...rest of =form.tpl[showif =[url][visitorUniqueID][/url]=3D[url][raw][visitorUniqueID][/raw][/url]][text]visitorUniqueID=3D[cart][/text][/showif]<input =name=3D"visitorUniqueID" type=3D"hidden" value=3D"[visitorUniqueID]" =/></form>Here are =some of the fields in visitorSurvey.db:visitorIDtheDatetheTimelearnMore=designnamecityemailHelp =would be greatly appreciated.Lori
. =To unsubscribe, E-mail to: archive=s:http://mail.webdna.us/l=ist/talk@webdna.us Bug Reporting: support@webdna.us
|
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.--------------------------------------------------------- =This message is sent to you because you are subscribed to the mailing =list...rest of =form.tpl[showif =[url][visitorUniqueID][/url]=3D[url][raw][visitorUniqueID][/raw][/url]][/showif]<input =name=3D"visitorUniqueID" type=3D"hidden" value=3D"[visitorUniqueID]" =/></form>Here are =some of the fields in visitorSurvey.db:visitorIDtheDatetheTimelearnMore=designnamecityemailHelp =would be greatly appreciated.Lori
. =To unsubscribe, E-mail to: archive=s:http://mail.webdna.us/l=ist/talk@webdna.us Bug Reporting: support@webdna.us
DOWNLOAD WEBDNA NOW!
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...