Re: [what] [am] [I] [missing]?
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 51091
interpreted = N
texte = 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/
Associated Messages, from the most recent to the oldest:
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/
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:
OT: advice on Wintel server options (1998)
Practice runs ? (1997)
SiteGuard Admin Feature ? (1997)
Uploading files with 3.0/4.0 (2000)
Sorting error (1997)
Setting up WebCatalog with Retail Pro data (1996)
WebCat2 - Getting to the browser's username/password data (1997)
suggestion (1997)
WebDNA and PostGres SQL (2005)
WebStar Secure on other machine (1997)
Internal Include Call/Request (2003)
RE: [WebDNA] Installing WebDNA on VPS (2008)
Cancel Subscription (1996)
Append again (1999)
Emailer setup (1997)
practicing safe queries.. (2000)
Dismissing dialogs (was 2.1b3 --> way slow) (1997)
t or f (1997)
Any Unix/Linux version to come? (1999)
WC 4.0 (2000)