Another session variables question

[den1s]

Hi All.

I have a straight forward question on session variables.

After running an a5w page with a search grid, i am presented with the results. I have created a link on the results, so that when the link is selected a (new) page is opened with more details on this item.

My problem is im not sure if i am getting the session variables process right.

I have placed the following code in my searchasset.a5w page with the search grid. I was hoping this would set the session variable for the field asset_id.

session.vasset_id = "asset_id"

then

In the link address on the searchassets grid component i have placed the following code;

itas_history.a5w?itas_history_filter=asset_id={asset_id}

This opens the correct a5w page and filters to the asset_id.

What i now need to do is when the itas_history.a5w page is open and you enter a record, the asset_id field for this new record will be populated with the asset_id of the item selected.

I have put the following code in the beforevalidatenewrecords event;

DataSubmitted.asset_id = session.vasset_id

This will put the value of the session.vasset_id in the asset_id field.

So i know i am nearly there. My BiG question is how do i create the session.vasset_id variable in the first place so the rest of my code works.

[Edward Larrabee]

This statement doesn't work:

session.vasset_id = "asset_id"

If you were setting the session variable in a grid event, you would have to use the syntax described in Using Grid Events.

[den1s]

Thanks Edward. I have read the document and i am even more confused. I have spend 2 days trying to get this to work and i think i am going in circles. Can you give me an idea of the syntax i need to get this to work please. Im sure its very straight forward but i just cannot seem to get my head around this one.

I tried typing in this in the BeforeValidateNewRecords.

Args.DataSubmitted.R1.ASSET_ID=session.vasset_id

but i get the following error when i try to view the session.vasset_id variable on a new page;

500 Internal Server Error
Script Error
Error:Script: /addnote.a5w line:36
? session.vasset_id
Property not found
session.vasset_id subelement not found.

[den1s]

BUMP!. Really stuck here guys. Please help!

[Edward Larrabee]

Try this code:

if eval_valid("session.vasset_id") then
Args.DataSubmitted.R1.ASSET_ID=session.vasset_id
end if

If the error goes away, it means that session.vasset_id does not exist.

[den1s]

I will explain what i am doing. I will be as precise as possible as i am desperate to get this one resolved.

I have a grid called SEARCHASSETS.a5wcmp.
Within this grid i have the asset_id field, which is a read only label field.
In the BeforeValidateExistingRecords i have placed the code you just gave me

if eval_valid("session.vasset_id") then
Args.DataSubmitted.R1.ASSET_ID=session.vasset_id
end if

I was hoping the above code would create the session.vasset_id variable.

I have a search part on this grid which basically searches the data from the assets table. I have placed a link field on each line of the search results which when pressed will do the following

ithistory.a5w?ithistory_filter=asset_id={asset_id}

This opens the ithistory.a5w page and displays only the records where the asset_id is equal to the item originally selected.

In the ithistory page (which is a note log of maintenance calls placed the particular asset) i have a button called ADD NEW NOTE. When this button is pressed, i have a Add Record Only grid open which allows me to add another note.

DATE - TYPE - NOTE

I have the following code which auto populates some fields in this grid.

function BeforeValidateNewRecords as v (DataSubmitted as P, Args as p, PageVariables as p)
with PageVariables
DataSubmitted.company_id = session.vcompany_id
DataSubmitted.ASSET_ID = session.vasset_id
DataSubmitted.date = now()
end with
end function

The line below isnt working as i cannot seem to create the session.vasset_id variable.

DataSubmitted.ASSET_ID = session.vasset_id

I get the following error when i click on the button to open the add notes grid

Error executing BeforeValidateNewRecords event handler: command: DataSubmitted.ASSET_ID = session.vasset_id Property not found session.vasset_id subelement not found.

Please help.

[Edward Larrabee]

Remember that a session variable does not exist until after it is created with either (1) a dim statement or an (2) assignment and (3) the page has been submitted back to the server at least once.

[den1s]

Its all a huge learning curve for me thanks for all your advise Edward.

At which point in my application is it best to create the session.vasset_id and how would you reccomend i do that. One example syntax would be very helpful.

[Ren� Stout]

Denis,

I don't know if this helps you: I did the following and it seems to work:

In a grid I created a computed link like:

pagename.a5w?session.member={Member_Id}

From that moment on, I can use the variable session.member.

Good luck!

[Edward Larrabee]

I suggest that you go to the webhelp and look in the index under Session Variable. You will see a number of examples.

[Edward Larrabee]

I just did an experiment. This creates a session variable. The code is in the BeforeSearch event of the grid:

function BeforeSearch as v (SearchDataSubmitted as P, Args as p, PageVariables as p)
with PageVariables
	session.lastname = SearchDataSubmitted.LASTNAME 
end with
end function

This code in the BeforeValidateNewRecords event writes this value to the lastname field of the new record.

function BeforeValidateNewRecords as v (DataSubmitted as P, Args as p, PageVariables as p)
with PageVariables
	DataSubmitted.LASTNAME = session.lastname
end with
end function

[den1s]

Thanks Rene for your example. I have tried this and yes it does work, but my only problem with this is that it appears in the URL, and i found users can change the value to view other records. When i attempted to use __protected__ variable in this type of command, it appeard not to recognise the __protected__ variable.

Also thank you Edward. Very helpful. I have implemented your example and it works to a degree... The variable session.LASTNAME is captured on the search part only and if say you entered SM instead of SMITH for the search, the value SM becomes the vallue in the session.LASTNAME. How can I get this to take the whole value from the LASTNAME field in the table, .i.e. SMITH.