close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DataAssist passing values

Thread began 2/10/2013 5:10 pm by john70964 | Last modified 2/11/2013 4:29 pm by Jason Byrnes | 474 views | 6 replies |

john70964

DataAssist passing values

I have a detail page which shows a recordNumber and details.

I want to pass the RecordNumber and some details to a Next page which will insert those details into another db Table.

Can anyone say how this can be carried out please?

Many thanks

John

Sign in to reply to this post

john70964

I took this a little further and by going to webassist > cookies >set session value created the value
<?php
@session_start();
if ($_SERVER["REQUEST_METHOD"] == "POST") {
$_SESSION["BoatResultsSession"] = "".$row_DetailRS1['RecNo'] ."";
}
?>

I then included this session in the recordset of the insert page. The insert page opens but the url does not contain a RecNo (recordID) and the text field recno remains empty.

I am attaching the detail and the insert page in the hope for some guidance.
Many thanks
John

Sign in to reply to this post

Jason ByrnesWebAssist

you have bind the initial value of the form elements to the corresponding columns from the recordset.

for each form element, click the lightning bolt icon next to initial value in the properties inspector, and select the corresponding column from the recordset on your page.

Sign in to reply to this post

john70964

On the insert page I have placed one text field recNo where its initial value is bound to the corresponding field in the recordset, (as a test field).

I notice the results url is /BoatResultsDetail.php?recordID=9474
but the insert page url is /Enquiries/boatenquiry_insert.php but excludes reference to the recordID

Does this have a significance?

Thanks
John

Sign in to reply to this post

Jason ByrnesWebAssist

you have not set the detail page to pass the ID as a querystring, nor do i see anywhere on the insert page where the query string is being used.

Sign in to reply to this post

john70964

Thanks Jason
I am now passing the ID as a query string and am getting the recordID showing in the insertpage as Enquiries/boatenquiry_insert.php?RecNo=9474

In the insert page I am trying to insert fields (pull in) from the details page so that the field
SellerRecNo is now set to <?php echo $row_DetailRS1['RecNo']; ?> and my thinking is that it should show 9474 like wise other fields should show fields from the details page.

However the fields remain empty.

I am attaching an updated insert page, can see what may be incorrect please?

Sign in to reply to this post

Jason ByrnesWebAssist

1) The recordset is set to filter on the $_SESSION['BoatResultsSession'] variable, not the RecNO URL Variable.

2) The form elements are getting there values from the validated entries collection, not from the recordset.

Sign in to reply to this post

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...