Re: [WebDNA] Search on a database

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108750
interpreted = N
texte = --Apple-Mail=_4E451E7F-85FE-4DE5-AE8A-864B4390C4DE Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Pass the 'autonumber' parameter for your unique ID's in your databases [append db=3Dvisitors.db&autonumber=3DvisitorID]........[/append] [text]visitorUniqueID=3D[lastautonumber][/text] http://www.webdna.us/page.dna?numero=3D196 On Mar 1, 2012, at 10:00 PM, Lori Palmquist wrote: > Hi, >=20 > 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. >=20 > Is there a way to assign a more searchable ID number? The method I'm = using now to generate each ID number is:=20 >=20 > 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.=20 >=20 >=20 > ...rest of form.tpl >=20 > [showif = [url][visitorUniqueID][/url]=3D[url][raw][visitorUniqueID][/raw][/url]] > [text]visitorUniqueID=3D[cart][/text] > [/showif] > > >=20 >=20 > Here are some of the fields in visitorSurvey.db: >=20 > visitorID > theDatetheTimelearnMoredesignnamecityemail=09= >=20 > Help would be greatly appreciated. > Lori >=20 > =20 > =20 > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: = archives:http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_4E451E7F-85FE-4DE5-AE8A-864B4390C4DE Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Pass the 'autonumber' parameter for your unique = ID's in your databases

[append db=3Dvisitors.db&autonumber=3DvisitorID]....<your = params>....[/append]
[text]visitorUniqueID=3D[lastautonumber][/text]



http://www.webdna.us/p= age.dna?numero=3D196



On Mar 1, 2012, at 10:00 PM, Lori Palmquist = wrote:

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. 


...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:

visitorID theDatetheTimelearnMore= designnamecityemail

Help = would be greatly appreciated.
Lori

 
 

 

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . = To unsubscribe, E-mail to: archive= s:http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_4E451E7F-85FE-4DE5-AE8A-864B4390C4DE-- Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Search on a database (Govinda 2012)
  2. Re: [WebDNA] Search on a database (Lori Palmquist 2012)
  3. Re: [WebDNA] Search on a database (Govinda 2012)
  4. Re: [WebDNA] Search on a database (Lori Palmquist 2012)
  5. Re: [WebDNA] Search on a database (Govinda 2012)
  6. Re: [WebDNA] Search on a database (Lori Palmquist 2012)
  7. Re: [WebDNA] Search on a database (Govinda 2012)
  8. Re: [WebDNA] Search on a database (Lori Palmquist 2012)
  9. Re: [WebDNA] Search on a database (Govinda 2012)
  10. Re: [WebDNA] Search on a database (Lori Palmquist 2012)
  11. Re: [WebDNA] Search on a database (Govinda 2012)
  12. Re: [WebDNA] Search on a database (Govinda 2012)
  13. Re: [WebDNA] Search on a database (Lori Palmquist 2012)
  14. Re: [WebDNA] Search on a database (Govinda 2012)
  15. Re: [WebDNA] Search on a database (aaronmichaelmusic@gmail.com 2012)
  16. [WebDNA] Search on a database (Lori Palmquist 2012)
--Apple-Mail=_4E451E7F-85FE-4DE5-AE8A-864B4390C4DE Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii Pass the 'autonumber' parameter for your unique ID's in your databases [append db=3Dvisitors.db&autonumber=3DvisitorID]........[/append] [text]visitorUniqueID=3D[lastautonumber][/text] http://www.webdna.us/page.dna?numero=3D196 On Mar 1, 2012, at 10:00 PM, Lori Palmquist wrote: > Hi, >=20 > 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. >=20 > Is there a way to assign a more searchable ID number? The method I'm = using now to generate each ID number is:=20 >=20 > 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.=20 >=20 >=20 > ...rest of form.tpl >=20 > [showif = [url][visitorUniqueID][/url]=3D[url][raw][visitorUniqueID][/raw][/url]] > [text]visitorUniqueID=3D[cart][/text] > [/showif] > > >=20 >=20 > Here are some of the fields in visitorSurvey.db: >=20 > visitorID > theDatetheTimelearnMoredesignnamecityemail=09= >=20 > Help would be greatly appreciated. > Lori >=20 > =20 > =20 > =20 > --------------------------------------------------------- This message = is sent to you because you are subscribed to the mailing list . To = unsubscribe, E-mail to: = archives:http://mail.webdna.us/list/talk@webdna.us Bug Reporting: = support@webdna.us --Apple-Mail=_4E451E7F-85FE-4DE5-AE8A-864B4390C4DE Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii Pass the 'autonumber' parameter for your unique = ID's in your databases

[append db=3Dvisitors.db&autonumber=3DvisitorID]....<your = params>....[/append]
[text]visitorUniqueID=3D[lastautonumber][/text]



http://www.webdna.us/p= age.dna?numero=3D196



On Mar 1, 2012, at 10:00 PM, Lori Palmquist = wrote:

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. 


...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:

visitorID theDatetheTimelearnMore= designnamecityemail

Help = would be greatly appreciated.
Lori

 
 

 

--------------------------------------------------------- = This message is sent to you because you are subscribed to the mailing = list . = To unsubscribe, E-mail to: archive= s:http://mail.webdna.us/l= ist/talk@webdna.us Bug Reporting: support@webdna.us

= --Apple-Mail=_4E451E7F-85FE-4DE5-AE8A-864B4390C4DE-- aaronmichaelmusic@gmail.com

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:

Latest WebCat release version (1998) Problems appending to database (1997) Using [Showif] tag. Mac (1997) WebCat2b15MacPlugin - showing [math] (1997) Summing fields (1997) Bug alert! (1997) More on [lookup] (1999) [WebDNA] plupload ? (2012) Talk Archives Was: One Hour Email (2002) Retrieve deleted files (2001) OT: Collaborative Browsing (2000) Most Efficiant Way to do restricted Areas (1997) [writefile] (1997) [WebDNA] Escaping content for JSON (2016) Authenticate (1997) [WebDNA] Anyone used these people ? (2010) Word Breaks (1998) [ListFiles] & [loop] (1998) Replacing a price with text (1998) Cart Numbers (1997)