Re: [what] [am] [I] [missing]?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51093
interpreted = N
texte = Ok, for the archives...If anybody ends up needing a Rating System and wants to use my code (below) be sure to change the ¬Found=NOT_FOUND in the [lookup] to ¬Found=0 and then change the following [showif] from [showif [exists]=NOT_FOUND] to [showif [exists]=0] and remove the [math] context within the [showif].Otherwise you will lose your first vote (I don't know why).-Dan------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656------------------------------------------------------------On Sat, 2003/06/14 08:40:11 -0700 Dan Strong
wrote:>Duh...>>Forgot to add ampersands to my append context...>--------------------------------->[append db=^article_ratings/article_ratings.db][!]>[/!]article=[thisArticle][!]>[/!]&vote1=0[!]>[/!]&vote2=0[!]>[/!]&vote3=0[!]>[/!]&vote4=0[!]>[/!]&vote5=0[!]>[/!][/append]>--------------------------------->>And it turns out it WAS writing to the .db, but for some reason I just didn't see it (don't >ask....)>>Thanks anyway for anyone who's wheel started turning on this.>>-Dan 'ampersand' Strong>------------------------------------------------------------>http://www.StrongGraphicDesign.com>(208) 319-0137 | Toll-free p/f 877-561-1656>------------------------------------------------------------>>>>>On Sat, 2003/06/14 08:30:48 -0700> Dan Strong wrote:>>OK, it's got to be something simple -- probably syntax related -- that is causing this logic to >>just plain not work. When I hit the submit button it goes to the page, but doesn't write to the >>.db or anything...>>>>Can anybody see anything obvious that I am missing?>>>>FORM:>>-------------------------------------------------------------->>>>-------------------------------------------------------------->>>>article_vote.html:>>-------------------------------------------------------------->>[!] -- ## Check to see if article record already exists in database -- [/!]>> [text show=f]exists=[lookup >>db=^article_ratings/article_ratings.db&lookinfield=ARTICLE&value=[thisArticle]&returnfield=[rating]¬Found=NOT_FOUND][/text]>>[!] -- ## END Check to see if article record already exists in database -- [/!]>>>>[!] -- ## If article already exists in database, then add vote. If not, create record, then add >>vote -- [/!]>>>> [showif [exists]=NOT_FOUND]>> [append db=^article_ratings/article_ratings.db][!]>>[/!]article=[thisArticle][!]>>[/!]vote1=0[!]>>[/!]vote2=0[!]>>[/!]vote3=0[!]>>[/!]vote4=0[!]>>[/!]vote5=0[!]>>[/!][/append]>>>>[math show=f]exists=0[/math]>> [/showif]>>>>[replace db=^article_ratings/article_ratings.db&eqARTICLEdata=[thisArticle]&[rating]type=num][!]>>[/!][rating]=[math][exists]+1[/math][!]>>[/!][/replace]>>>>[!] -- ## END If article already exists in database, then add vote. If not, create record, then >>add vote -- [/!]>>-------------------------------------------------------------->>>>article_ratings.db:>>-------------------------------------------------------------->>ARTICLEVOTE1VOTE2VOTE3VOTE4VOTE5>>-------------------------------------------------------------->>>>Thanks in advance,>>>>-Dan>>------------------------------------------------------------>>http://www.StrongGraphicDesign.com>>(208) 319-0137 | Toll-free p/f 877-561-1656>>------------------------------------------------------------>>>>------------------------------------------------------------->>This message is sent to you because you are subscribed to>> the mailing list .>>To unsubscribe, E-mail to: >>To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://webdna.smithmicro.com/>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list .>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Ok, for the archives...If anybody ends up needing a Rating System and wants to use my code (below) be sure to change the ¬Found=NOT_FOUND in the [lookup] to ¬Found=0 and then change the following [showif] from [showif [exists]=NOT_FOUND] to [showif [exists]=0] and remove the [math] context within the [showif].Otherwise you will lose your first vote (I don't know why).-Dan------------------------------------------------------------http://www.StrongGraphicDesign.com(208) 319-0137 | Toll-free p/f 877-561-1656------------------------------------------------------------On Sat, 2003/06/14 08:40:11 -0700 Dan Strong wrote:>Duh...>>Forgot to add ampersands to my append context...>--------------------------------->[append db=^article_ratings/article_ratings.db][!]>[/!]article=[thisArticle][!]>[/!]&vote1=0[!]>[/!]&vote2=0[!]>[/!]&vote3=0[!]>[/!]&vote4=0[!]>[/!]&vote5=0[!]>[/!][/append]>--------------------------------->>And it turns out it WAS writing to the .db, but for some reason I just didn't see it (don't >ask....)>>Thanks anyway for anyone who's wheel started turning on this.>>-Dan 'ampersand' Strong>------------------------------------------------------------>http://www.StrongGraphicDesign.com>(208) 319-0137 | Toll-free p/f 877-561-1656>------------------------------------------------------------>>>>>On Sat, 2003/06/14 08:30:48 -0700> Dan Strong wrote:>>OK, it's got to be something simple -- probably syntax related -- that is causing this logic to >>just plain not work. When I hit the submit button it goes to the page, but doesn't write to the >>.db or anything...>>>>Can anybody see anything obvious that I am missing?>>>>FORM:>>-------------------------------------------------------------->>>>-------------------------------------------------------------->>>>article_vote.html:>>-------------------------------------------------------------->>[!] -- ## Check to see if article record already exists in database -- [/!]>> [text show=f]exists=[lookup >>db=^article_ratings/article_ratings.db&lookinfield=ARTICLE&value=[thisArticle]&returnfield=[rating]¬Found=NOT_FOUND][/text]>>[!] -- ## END Check to see if article record already exists in database -- [/!]>>>>[!] -- ## If article already exists in database, then add vote. If not, create record, then add >>vote -- [/!]>>>> [showif [exists]=NOT_FOUND]>> [append db=^article_ratings/article_ratings.db][!]>>[/!]article=[thisArticle][!]>>[/!]vote1=0[!]>>[/!]vote2=0[!]>>[/!]vote3=0[!]>>[/!]vote4=0[!]>>[/!]vote5=0[!]>>[/!][/append]>>>>[math show=f]exists=0[/math]>> [/showif]>>>>[replace db=^article_ratings/article_ratings.db&eqARTICLEdata=[thisArticle]&[rating]type=num][!]>>[/!][rating]=[math][exists]+1[/math][!]>>[/!][/replace]>>>>[!] -- ## END If article already exists in database, then add vote. If not, create record, then >>add vote -- [/!]>>-------------------------------------------------------------->>>>article_ratings.db:>>-------------------------------------------------------------->>ARTICLEVOTE1VOTE2VOTE3VOTE4VOTE5>>-------------------------------------------------------------->>>>Thanks in advance,>>>>-Dan>>------------------------------------------------------------>>http://www.StrongGraphicDesign.com>>(208) 319-0137 | Toll-free p/f 877-561-1656>>------------------------------------------------------------>>>>------------------------------------------------------------->>This message is sent to you because you are subscribed to>> the mailing list .>>To unsubscribe, E-mail to: >>To switch to the DIGEST mode, E-mail to >>Web Archive of this list is at: http://webdna.smithmicro.com/>>------------------------------------------------------------->This message is sent to you because you are subscribed to> the mailing list .>To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Dan Strong
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:
Need relative path explanation (1997)
Sendmail & Time Issue (2001)
[WebDNA] Page display is screwed up ... (2016)
Umm...about those log files? (Off Topic) (1997)
[shownext max=?] armed (1997)
Setting up the server (1997)
default value from Lookup (was Grant, please help me) (1997)
Need a silver bullet (2004)
Rookie Hacker? (1998)
PCS Emailer's role ? (1997)
best way to limit # of attempts to login to protected page? (2000)
Combining Searches (1998)
Price Not Appearing (2000)
CSS positioning!!! (2001)
NetForms for mail, sorry (1998)
RE: Help name our technology! (1997)
Error:Too many nested [xxx] contexts (1997)
Frames and WebCat (1997)
international time (1997)
Almost a there but..bye bye NetCloak (1997)