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:

Date Formats (1997) Location of Webcat site in folder hierarchy (1997) Re:2nd WebCatalog2 Feature Request (1996) Group Updates (1998) Mac webcatalog3_0_5b11 more dead lock throws (1999) PDF Tools (2006) Return records from another (1997) Nested vs conditional (1997) Price problem (1997) Help!!!! (1997) E-mailer error codes (1997) my price won't move (1997) Help name our technology! (1997) RE: I have observed and I am gone. (1998) Simple way to create unique SKU (1997) Help name our technology! I found it (1997) Possible Hijacking from Globix (2002) ShowNext (1997) ShowNext (1997) Text Area - Line Breaks (1998)