Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Update form Not updating

Update form Not updating

Thread began 3/29/2011 7:36 pm by dave315749 | Last modified 4/04/2011 11:59 am by Jason Byrnes | 2793 views | 7 replies |

3/29/2011 7:36 pm | #1 dave315749

Update form Not updating

In a previous form it was discussed that you could have the update recordset run automaticly by submitting the form on page load. This works great in the browser but not in a CRON JOB.

How would i have this form automaticly submit using something other than javascript? from my reseach it looks like php and curl? Can you give me a direction to look to or what to do ?

1. Page works great when browsing to that page it loads and then submits.
2. page does not work when using a cron job, it does not submit the form.

Cron command is : /usr/bin/curl script.php

previous post i was talking about:

use javascript to submit the form on page load. edit the body tag to:
<body onLoad="document.form1.submit();">

and use the currant page submit trigger.

Also the reason why i have to do this is because the multiple record update code has to be at the top of the page. (so i have to submit the form) It does not work ( update on page load) if i put that code at the bottom of the page AFTER the repeat region.. Anything i am missing? or that code has to be at the top of the page?

3/30/2011 7:45 am | #2 Jason ByrnesWebAssist

this page talks about using cURL to submit a form post in a cron job:
setting-up-a-cron-job-to-update-you-website-using-curl

the reason that using the before page load trigger does not work in the update is that the form post does not exist on page load, the form post does not exist untill the form is posted.

3/30/2011 11:18 pm | #3 dave315749

I do understand that, but

1. why does the code not work if i pull the on page load insert into database code and paste it at the bottom of the page, where it will load AFTER the form has been loaded.?
2. Any way to modify the code so this would work?

3/31/2011 8:29 am | #4 Jason ByrnesWebAssist

using the onpage load trigger wont work because the form has not posted yest.

the insert behavior is expecting to get data from the form post.

moving the insert to be after the form does not mean that the form has been posted.

to do this in a cron job, you cant rely on the post data.

where are the form elements getting the values?

A recordset?

if this is the case, create a single insert behavior that uses the recordset values, and add a loop so it will loop through the recordsset instead of using the form.

3/31/2011 11:48 am | #5 dave315749

Ok kinda following you, if i move the insert to be after the form and then post to that page using the cronjob that may work?

What do you mean by " to do this in a cron job, you can rely on the post data."

The elements are getting their values from the repeated form fields.. not the recordset itsself. I have heard of a look, but don tknow how at the moment, would it work with the form or would i need to do the recordset?

thanks again for your help, love the extensions!

3/31/2011 12:02 pm | #6 Jason ByrnesWebAssist

no, putting it after the form will have no effect, the form is still not posted

Where are the form elements getting their values, that is the question.

you wont be able to user the post for this, you will need to use a diferant way to get the values to the insert.

the problem is that the cron job just loads the page into the servers memory, not into a web browser.

the servers memory has no way of processing javascript the same way a web browser would.

you cant rely on the form post because the form is never going to post.

4/04/2011 11:55 am | #7 dave315749

Ok, how about if i use the web assist insert code, and insert comes from the records set NOT THE FORM, i could put this inside of the repeat region and then it would loop and insert on each repeated result and set the trigger to page load.. would this insert a single record for each time it loads ?

4/04/2011 11:59 am | #8 Jason ByrnesWebAssist

if you put the insert in the repeat region, it will insert a record for each result returned in the recordset each time the page loads.

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.