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... =202) explain what you wanted the code to do,=203) 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]:
index # | [ListFields =db=3DvisitorSurvey.db]=[FieldName] | [/ListFields]=20
[founditems][index] | =[ListFields db=3DvisitorSurvey.db]==[interpret][[FieldName]][/interpret]= | =[/ListFields]
[/founditems]
[/search][/else][/if]----------- END seeSurveyResponses.dna ------------------------
Associated Messages, from the most recent to the oldest:
> 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... =202) explain what you wanted the code to do,=203) 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:
[loop start=3D1&end=3D10&advance=3D1]- [thisurl]?showResponsesOnThisDate=3D[Math =date]{[date]}-{00/[index]/0000}[/Math]">[Math =date]{[date]}-{00/[index]/0000}[/Math]
[/loop]
[/then][else][Search =db=3DvisitorSurvey.db&eqtheDatedatarq=3D[showResponsesOnThisDate]&astheDat=esort=3D1&theDatetype=3Ddate&astheTimesort=3D2&theTimetype=3Dtime]
[numfound] Responses on =[showResponsesOnThisDate]:
index # | [ListFields =db=3DvisitorSurvey.db]=[FieldName] | [/ListFields]=20
[founditems][index] | =[ListFields db=3DvisitorSurvey.db]==[interpret][[FieldName]][/interpret]= | =[/ListFields]
[/founditems]
[/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)