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...RegardsRobOn 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]>>>>
>>>> [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.> ---------------------------------------------------------> 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:
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...RegardsRobOn 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]>>>>
>>>> [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.> ---------------------------------------------------------> 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
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...