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:
Signal Raised Error (Part III) (1997)
Understanding texta (1997)
browser info.txt and SSL (1997)
RAM variables (1997)
Netscape v. IE (1997)
show all problem (1997)
Apache and Applescript (2004)
SV: Mass Mail (2000)
calculating ShipCost depending on weight (1997)
Wrapping text (1998)
Bad Cookie / Internet Option / Internet Explorer (2004)
includes and cart numbers (1997)
Sorting (1998)
How to append text after the sign & (1997)
suffix mapping for NT? (1997)
printing twice? and fix (1997)
Disconts (2004)
[dos] command and [math] (1998)
[WebDNA] Email Problem (2009)
Duplicates (1998)