Re: [WebDNA] Search on a database

This WebDNA talk-list message is from

2012


It keeps the original formatting.
numero = 108753
interpreted = N
texte = > What I'd like to do: > Create a report of responses to my survey, based on date received, = i.e. see all responses that arrived on March 1. Have you *tried* any code? Can we see the attempt? ;-) One of the best ways to inspire good support on lists is to: 1) show code you attempted... =20 2) explain what you wanted the code to do,=20 3) and explain what the code actually does instead. Don't look down... it will spoil the learning process that will come = from this ^^^. Don't look down till you TRY it. ;-) -Govinda = --------------------------------------------------------------------------= --------------------------------------------------------------------------= -------------------------------------------- this is untested.. may need tweaking depending on typos, and/or how you = have things set up on your end. = --------------------------------------------------------------------------= ------------------------------------------------------------- ----------- START seeSurveyResponses.dna ------------------------  seeSurveyResponses.dna [if = ("[URL][showResponsesOnThisDate][/URL]"=3D"[URL][raw][showResponsesOnThisD= ate][/raw][/URL]")] [then] 

Links to see responses from any of the last = 10 days:

 [/then] [else] [Search = db=3DvisitorSurvey.db&eqtheDatedatarq=3D[showResponsesOnThisDate]&astheDat= esort=3D1&theDatetype=3Ddate&astheTimesort=3D2&theTimetype=3Dtime] 

[numfound] Responses on = [showResponsesOnThisDate]:

   [ListFields = db=3DvisitorSurvey.db]  [/ListFields]=20  [founditems]   = [ListFields db=3DvisitorSurvey.db] = = [/ListFields]  [/founditems] 
index # = [FieldName] 
[index] = [interpret][[FieldName]][/interpret] =
[/search] [/else] [/if] ----------- END seeSurveyResponses.dna ------------------------ 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)
> What I'd like to do: > Create a report of responses to my survey, based on date received, = i.e. see all responses that arrived on March 1. Have you *tried* any code? Can we see the attempt? ;-) One of the best ways to inspire good support on lists is to: 1) show code you attempted... =20 2) explain what you wanted the code to do,=20 3) and explain what the code actually does instead. Don't look down... it will spoil the learning process that will come = from this ^^^. Don't look down till you TRY it. ;-) -Govinda = --------------------------------------------------------------------------= --------------------------------------------------------------------------= -------------------------------------------- this is untested.. may need tweaking depending on typos, and/or how you = have things set up on your end. = --------------------------------------------------------------------------= ------------------------------------------------------------- ----------- START seeSurveyResponses.dna ------------------------  seeSurveyResponses.dna [if = ("[url][showResponsesOnThisDate][/URL]"=3D"[url][raw][showResponsesOnThisD= ate][/raw][/URL]")] [then] 

Links to see responses from any of the last = 10 days:

 [/then] [else] [Search = db=3DvisitorSurvey.db&eqtheDatedatarq=3D[showResponsesOnThisDate]&astheDat= esort=3D1&theDatetype=3Ddate&astheTimesort=3D2&theTimetype=3Dtime] 

[numfound] Responses on = [showResponsesOnThisDate]:

   [ListFields = db=3DvisitorSurvey.db]  [/ListFields]=20  [founditems]   = [ListFields db=3DvisitorSurvey.db] = = [/ListFields]  [/founditems] 
index # = [FieldName] 
[index] = [interpret][[FieldName]][/interpret] =
[/search] [/else] [/if] ----------- END seeSurveyResponses.dna ------------------------ Govinda

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:

Using Plug-In while running 1.6.1 (1997) WCS Newbie question (1997) keep W* in front applescript? (1998) problems with 2 tags (1997) Don't know if this is a sily question... (2003) Num Sort Descending (OT) (2004) Re:2nd WebCatalog2 Feature Request (1996) Revisit: speed test (2002) Trouble with Netscape (1998) OT - Future Filemaker (2000) RE: Error: template (1997) Stumped (1999) Date subtraction (2002) Privacy Issue (LEGIT QUESTION) (2003) 2.0 Info (1997) More on the email templates (1997) Referrer field to header field conversion (1997) [ConvertChars] problem (1997) Emailer problems. (1998) WebCatalog 3.0.8 Mac OS (2000)