Re: [WebDNA] Help with ReplaceFoundItems

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103093
interpreted = N
texte = You're still not getting the concept of regular html forms. Once you get that right, I think you'll be fine. This: NOT this: By the way, no need for the [input] tags if you are passing a known, clean [sku] value that is a simple alphanumeric value. Quote marks though, yes, always. Another BTW, no need for subsequent [url] tags if again, it's a value you control and you know to be clean. [FormWasSubmitted]=T will suffice. Terry >Ok, I moved it to the local developer version, as doing this >remotely was becoming a pain... I had even set the db permissions to >777 .. > >So here is what I have in the db, to keep things as simple as >possible, and am only working with 2 fields until I can solve the >issue: > >SKUapp_name >1test >2test1 >3test2 >4test3 >5test4 > >The edit page has the only the following, so I'm able to flip back >and forth between replace, and replacefounditems: > > >[!] >[showif [URL][FormWasSubmitted][/URL]=T] >[Replace >db=form.db&eqSKUdatarq=[URL][SKU][/URL]]app_name=[URL][app_name][/URL][/Replace] > >

Success

>[/showif] >[commitdatabase db=form.db] >[/!] >[showif [URL][FormWasSubmitted][/URL]=T] >[search db=form.db&eqSKUdatarq=[SKU]] >[ReplaceFoundItems]app_name=[app_name][/ReplaceFoundItems] > >[numfound] >[/search] > >

Success

>[/showif] > > > >[commitdatabase db=form.db] > >
> >[search db=form.db&eqapp_namedatarq=[app_name]] >[showif [numfound]>0] >[founditems] > >
> > > > > > > >
Full Name
> >
> >[/founditems] >[/showif] >[/search] >------------------------------------------ >The results on the page for numfound is: >0 >Success > >----------------------------------------- > >But the resulting URL is showing the data being passed? > >http://192.168.2.2/forms/admin/edit.tpl?FormWasSubmitted=T&1=1&test=123456789 ><--HERE > >Permissions on the database is 777, but it still won't write. > >I'm soooooooooo confused ... what am I missing? > >Rob > > > > >On 3-Aug-09, at 11:08 AM, Govinda wrote: > >> and if you are now indexing your db record via a unique [sku] >>string, then you need to be passing that 'sku' value in your form. >> e.g. >> >> right? Otherwise how does your [search] know which record you are >>trying to find/edit? >> >> -- >> >> Also, while troubelshooting, inside your [search] context, put a >>[numfound] tag so you can see if you even find a record. >> >> On Aug 3, 2009, at 8:46 AM, Rob wrote: >> >>> Sorry ... was away for the weekend... >>> >>> Thank you for all the suggestions... >>> >>> Ok... tried the suggestions, and made sure the db was writeable, >>>but it doesn't seem to write to it... which is weird .. Currently, >>>I'm just working with the 3 fields until I get the procedure down. >>>I also added a hidden SKU field to give it a unique ID. >> >>> ... >>> >>> Are there any other reasons why it wouldn't write to the db? >>> >>> Rob >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: >archives: http://mail.webdna.us/list/talk@webdna.us >old archives: http://dev.webdna.us/TalkListArchive/ -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Help with ReplaceFoundItems (Rob 2009)
  2. Re: [WebDNA] Help with ReplaceFoundItems (Govinda 2009)
  3. Re: [WebDNA] Help with ReplaceFoundItems (Rob 2009)
  4. Re: [WebDNA] Help with ReplaceFoundItems ("Dan Strong" 2009)
  5. Re: [WebDNA] Help with ReplaceFoundItems (Terry Wilson 2009)
  6. Re: [WebDNA] Help with ReplaceFoundItems (Terry Wilson 2009)
  7. Re: [WebDNA] Help with ReplaceFoundItems (Rob 2009)
  8. Re: [WebDNA] Help with ReplaceFoundItems (Govinda 2009)
  9. Re: [WebDNA] Help with ReplaceFoundItems (Govinda 2009)
  10. Re: [WebDNA] Help with ReplaceFoundItems (Kenneth Grome 2009)
  11. Re: [WebDNA] Help with ReplaceFoundItems (Rob 2009)
  12. Re: [WebDNA] Help with ReplaceFoundItems (Govinda 2009)
  13. Re: [WebDNA] Help with ReplaceFoundItems (Kenneth Grome 2009)
  14. Re: [WebDNA] Help with ReplaceFoundItems (Govinda 2009)
  15. Re: [WebDNA] Help with ReplaceFoundItems (Govinda 2009)
  16. Re: New: Re: [WebDNA] Help with ReplaceFoundItems (Rob 2009)
  17. New: Re: [WebDNA] Help with ReplaceFoundItems (Donovan Brooke 2009)
  18. [WebDNA] Help with ReplaceFoundItems (Rob 2009)
You're still not getting the concept of regular html forms. Once you get that right, I think you'll be fine. This: [input][SKU][/input]"> NOT this: [input][SKU][/input]"> By the way, no need for the [input] tags if you are passing a known, clean [sku] value that is a simple alphanumeric value. Quote marks though, yes, always. Another BTW, no need for subsequent [url] tags if again, it's a value you control and you know to be clean. [FormWasSubmitted]=T will suffice. Terry >Ok, I moved it to the local developer version, as doing this >remotely was becoming a pain... I had even set the db permissions to >777 .. > >So here is what I have in the db, to keep things as simple as >possible, and am only working with 2 fields until I can solve the >issue: > >SKUapp_name >1test >2test1 >3test2 >4test3 >5test4 > >The edit page has the only the following, so I'm able to flip back >and forth between replace, and replacefounditems: > > >[!] >[showif [url][FormWasSubmitted][/URL]=T] >[Replace >db=form.db&eqSKUdatarq=[url][SKU][/URL]]app_name=[url][app_name][/URL][/Replace] > >

Success

>[/showif] >[commitdatabase db=form.db] >[/!] >[showif [url][FormWasSubmitted][/URL]=T] >[search db=form.db&eqSKUdatarq=[SKU]] >[replacefounditems]app_name=[app_name][/ReplaceFoundItems] > >[numfound] >[/search] > >

Success

>[/showif] > > > >[commitdatabase db=form.db] > >
> >[search db=form.db&eqapp_namedatarq=[app_name]] >[showif [numfound]>0] >[founditems] > >
> >[input][SKU][/input]"> > > > > > >
Full Name
> >
> >[/founditems] >[/showif] >[/search] >------------------------------------------ >The results on the page for numfound is: >0 >Success > >----------------------------------------- > >But the resulting URL is showing the data being passed? > >http://192.168.2.2/forms/admin/edit.tpl?FormWasSubmitted=T&1=1&test=123456789 ><--HERE > >Permissions on the database is 777, but it still won't write. > >I'm soooooooooo confused ... what am I missing? > >Rob > > > > >On 3-Aug-09, at 11:08 AM, Govinda wrote: > >> and if you are now indexing your db record via a unique [sku] >>string, then you need to be passing that 'sku' value in your form. >> e.g. [input][sku][/input]"> >> >> right? Otherwise how does your [search] know which record you are >>trying to find/edit? >> >> -- >> >> Also, while troubelshooting, inside your [search] context, put a >>[numfound] tag so you can see if you even find a record. >> >> On Aug 3, 2009, at 8:46 AM, Rob wrote: >> >>> Sorry ... was away for the weekend... >>> >>> Thank you for all the suggestions... >>> >>> Ok... tried the suggestions, and made sure the db was writeable, >>>but it doesn't seem to write to it... which is weird .. Currently, >>>I'm just working with the 3 fields until I get the procedure down. >>>I also added a hidden SKU field to give it a unique ID. >> >>> ... >>> >>> Are there any other reasons why it wouldn't write to the db? >>> >>> Rob >> >> --------------------------------------------------------- >> This message is sent to you because you are subscribed to >> the mailing list . >> To unsubscribe, E-mail to: >> archives: http://mail.webdna.us/list/talk@webdna.us >> old archives: http://dev.webdna.us/TalkListArchive/ > >--------------------------------------------------------- >This message is sent to you because you are subscribed to >the mailing list . >To unsubscribe, E-mail to: >archives: http://mail.webdna.us/list/talk@webdna.us >old archives: http://dev.webdna.us/TalkListArchive/ -- Terry Wilson | terry@terryfic.com | http://terryfic.com http://WhosComing.com - a simplified, affordable online reservation system http://TightJacket.com -- stylish protection for your laptop -------------------------------------------------------------------------- Attitude is the only difference between ordeal and adventure. Terry Wilson

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:

Deleting Orders (1997) executing via commandline (2003) hideif/showif causes error if wrapped around searches (2003) Looking for a host (1997) Location of Browser Info.txt file (1997) [url] issue (2000) Order not created error (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) Which GUI HTML editors work with WC ? (1997) How to Sort Summ data ? (1997) no global [username] or [password] displayed ... (1997) OT: Need some feedback, please. (2003) Not really WebCat- (1997) Separate SSL Server (1997) [WebDNA] To be or not to be friendly (URLs) (2011) redirect from the errorsMessages.db entry (1997) Norton Internet Security filtering out WebDNA processsed (2004) RE: Adding headers to email (1997) [ModDate] & [ModTime] ? (1997) SendMail - sending message to more than one person from (2006)