Re: [WebDNA] Help with ReplaceFoundItems

This WebDNA talk-list message is from

2009


It keeps the original formatting.
numero = 103099
interpreted = N
texte = Thank you Terry, and all. This was the primary problem: input name="[SKU]" .. its been a long time since I had to write a form.. :-( After it started passing data it was just a few more steps... the ReplaceFoundItems just doesn't seem to want to work, yet the formvariables were being passed, so i flipped it over to: [Replace db=form.db&eqSKUdatarq=[URL][SKU][/URL]]app_name=[URL] [app_name][/URL][/Replace] and it was total joy... :-) This: [ReplaceFoundItems]app_name=[app_name][/ReplaceFoundItems] only wanted to pass either [app_name], or when I removed the brackets, app_name, yet the entered data was being passed. Thank you for all the help everyone... this is definitely the most helpful list on the net... Regards Rob On 3-Aug-09, at 11:58 AM, Terry Wilson wrote: > 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] >> >>
>> >> >> >> >> >> > size="45"> >> >>
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. > --------------------------------------------------------- > 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/ 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)
Thank you Terry, and all. This was the primary problem: input name="[SKU]" .. its been a long time since I had to write a form.. :-( After it started passing data it was just a few more steps... the ReplaceFoundItems just doesn't seem to want to work, yet the formvariables were being passed, so i flipped it over to: [Replace db=form.db&eqSKUdatarq=[url][SKU][/URL]]app_name=[url] [app_name][/URL][/Replace] and it was total joy... :-) This: [replacefounditems]app_name=[app_name][/ReplaceFoundItems] only wanted to pass either [app_name], or when I removed the brackets, app_name, yet the entered data was being passed. Thank you for all the help everyone... this is definitely the most helpful list on the net... Regards Rob On 3-Aug-09, at 11:58 AM, Terry Wilson wrote: > 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]"> >> >> >> >> > size="45"> >> >>
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. > --------------------------------------------------------- > 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/ Rob

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:

Uh...can someone help me out with the b10? (1997) Help! WebCat2 bug (1997) Searching a field and returning the highest value (1997) Help! WebCat2 bug (1997) two unique banners on one page (1997) How to Display text in empty fields (1997) Server crash (1997) Sku numbers (1997) [WebDNA] Nginx (2010) Car Database (2002) Searching for a Blank Field (2000) Date/Time format problems (1997) Suggestion: appendfounditems (2002) Price Not Appearing (2000) RE: PIXO support (1997) Cart ID (1999) Error -108 (1997) WebCat editing, SiteGuard & SiteEdit (1997) required fields (1998) ShowIf helper? (1998)