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: > >SKU app_name >1 test >2 test1 >3 test2 >4 test3 >5 test4 > >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] > >
> >[search db=form.db&eqapp_namedatarq=[app_name]] >[showif [numfound]>0] >[founditems] > > > >[/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:
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: > >SKU app_name >1 test >2 test1 >3 test2 >4 test3 >5 test4 > >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] > >
> >[search db=form.db&eqapp_namedatarq=[app_name]] >[showif [numfound]>0] >[founditems] > > > >[/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
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...