Programmatically update List source function

[JPMPA]

Sorry to bother you all with my list questions. I have a list (alpha control type List) that has the source as custom and the underlying function is "xbasic_populate_my_list1"
It works fine. Now when I click a button I wish to change the source of the custom to another underlying function is "xbasic_populate_my_list2" Is it possible.
xBasic or javascript solution will work. Thanks!

[Davidk]

Re: Programmatically update List source function

Are all the fields the same between list1 and list2? Seems they'd have to be. And... if so... then I would use one XBasic source to return either list1 or list2 data.

[JPMPA]

Re: Programmatically update List source function

David, I just have one list 'list1', but have 2 xBasic functions 'xbasic_populate_my_list1' and 'xbasic_populate_my_list2'
When I designed the list 'list1', I set the source property as custom and give the xBasic function name 'xbasic_populate_my_list1'
Now, I wish to add a button whose code [xBasic or Javascript] will update the source xBasic function of list 'list1' from 'xbasic_populate_my_list1' to 'xbasic_populate_my_list2'
Is this possible? Thanks!

[Davidk]

Re: Programmatically update List source function

Understood... but my question wasn't phrased quite properly. You're returning data from 'xbasic_populate_my_list1' and 'xbasic_populate_my_list2'. Are the same fields being returned? Same number of columns and same field names from both xbasic functions?

[JPMPA]

Re: Programmatically update List source function

Yes David. They are exactly the same. Same number of columns and same field names from both xbasic functions.

[Davidk]

Re: Programmatically update List source function

Excellent... then instead of trying to figure out how to dynamically change the source of a list just call one xbasic function that combines the logic of your two functions. That's going to be much simpler in the end, easier for changes etc. The direct answer is... I have no idea if you can programmatically change the source - probably - this is Alpha - but I'm going to guess it's fraught with perils... which is a phrase you don't get to use much these days.

Your button push must have some login in it that decides which data function to run. Put that logic into one function and figure out your data from there.

[JPMPA]

Re: Programmatically update List source function

Thanks. I tried that but I was getting error message when the app starts up. This is because some of the fields are not defined (rendered) at that time the app is starting up. The message says that '"e.rv.V.R1.TEXTBOX1" is not defined' when the app is starting up in the example below. After the initial start up - it worked fine.
So I was thinking to use another function that shows default values from another xBasic function - or blanks. Later, a button would change the source to the following xbasic function - I thought. Maybe 1) somehow I should ignore this field not defined during application startup or 2) not let the list populate - let it be blank - later the button would populate it based in this field. I do not know how to do 1) or 2) above - help!

function xbasic_populate_my_list1 as c (e as p)
if e.rv.V.R1.TEXTBOX1 = "100" then
txt = <<%txt%
[
{firstname: 'Fred100', lastname: 'Smith100'} ,
{firstname: 'richard100', lastname: 'smith100'}
]
%txt%
else
txt = <<%txt%
[
{firstname: 'Fred200', lastname: 'Smith200'} ,
{firstname: 'richard200', lastname: 'smith200'}
]
%txt%
end if
xbasic_populate_my_list1 = txt

BTW: I have another post with similar issue - I will update that post with the link to this post if I get help resolving this issue.

[Davidk]

Re: Programmatically update List source function

I think you need to use the current syntax for REQUEST variables and also use the variable_exists function to help build the List.

Have a look...

http://www.youtube.com/watch?v=q0eLDfKxKl0

function xbasic_populate_my_list1 as c (e as p)
	
	
if variable_exists("Request.Variables.TEXTBOX1") then

	if Request.Variables.TEXTBOX1 = "100" then

txt = <<%longstring%
[
{firstname: 'Fred100', lastname: 'Smith100'} ,
{firstname: 'richard100', lastname: 'smith100'}
]
%longstring%

else

txt = <<%longstring%
[
{firstname: 'Fred200', lastname: 'Smith200'} ,
{firstname: 'richard200', lastname: 'smith200'}
]
%longstring%
end if

else

txt = <<%longstring%
[
{firstname: 'Fred100', lastname: 'Smith100'} ,
{firstname: 'richard100', lastname: 'smith100'}
]
%longstring%

end if

xbasic_populate_my_list1 = txt


end function

[JPMPA]

Re: Programmatically update List source function

David,

Thank you so much!!

It works great now.

function xbasic_populate_my_list1 as c (e as p)

if variable_exists("e.rv.V.R1.TEXTBOX1") then
if e.rv.V.R1.TEXTBOX1 = "100" then
txt = <<%txt%
[
{firstname: 'Fred100', lastname: 'Smith100'} ,
{firstname: 'richard100', lastname: 'smith100'}
]
%txt%
else
txt = <<%txt%
[
{firstname: 'Fred200', lastname: 'Smith200'} ,
{firstname: 'richard200', lastname: 'smith200'}
]
%txt%
end if
else
txt = <<%txt%
[
{firstname: '', lastname: ''}
]
%txt%
end if

xbasic_populate_my_list1 = txt

end function

[Davidk]

Re: Programmatically update List source function

Excellent... glad it worked out. As mentioned above... this is from the supplied notes in an Ajax Callback...

'Request - The Request object. Includes Request.Variables, which should be used instead of the older e.rv construct

Here's another method described by Selwyn... really great stuff... from the pre-release release notes... and there's a component available to download in the notes as well.

http://www.ajaxvideotutorials.com/V1...eFromSQL_1.swf
http://www.ajaxvideotutorials.com/V1...eFromSQL_2.swf

[JPMPA]

Re: Programmatically update List source function

Thanks. My logic may involve repeating fields too, so used the e.rv variables. I will followup with the documents you provided the link and will check out if the request variables let me access repeating container fields. Thanks again. Really appreciate your help!

[JPMPA]

Re: Programmatically update List source function

Thanks. I am now using Request Variables instead or e.rv variables (Request.Variables.V.R1.TEXTBOX1 instead of e.rv.V.R1.TEXTBOX1.) Thanks for pointing that out.

[kotinkarwak]

Re: Programmatically update List source function

David,
please expand a bit on the request variable part. I have followed the videos in this thread, first starting with Selwyn's to pupulate the list using xbasic and then went back to your video where you mention of a request var and you entering it at the URL. I have build the component as shown but not getting the result

my url defaults to

"http://localhost/LivePreview/Sakila_List01_PageLayoutLivePreview.a5w?231153652"

and I hence add the code as shown below but not getting the code to 'switch' to the portion as shown.

"http://localhost/LivePreview/Sakila_List01_PageLayoutLivePreview.a5w?231153652?TEXTBOX1=200"

function xbasic_populate_motorsport as c (e as p)
'debug(1)	
	
if variable_exists("Request.Variables.TEXTBOX1") then

	if Request.Variables.TEXTBOX1 = "100" then
		txt = <<%longstring%	
		[
		{driver: '1 Nico Rosberg', car: 'Mercedes'},
		{driver: '2 Kevin Magnussen', car: 'McLaren'},
		{driver: '3 Jenson Button', car: 'McLaren'},
		{driver: '4 Fernando Alonso', car: 'Ferrari'}
		]
		%longstring%
	else
		txt = <<%longstring%	
		[
		{driver: 'Valtteri Bottas', car: 'Williams'},
		{driver: 'Nico Hulkenberg', car: 'Force India'},
		{driver: 'Kimi Raikkonen', car: 'Ferrari'},
		{driver: 'Jean-Eric Vergne', car: 'Toro Rosso'}
		{driver: 'Daniil Kvyat', car: 'Toro Rosso'}
		{driver: 'Sergio Perez', car: 'Force India'}
		]
		%longstring%
	end if
	
else
	txt = <<%longstring%	
	[
	{driver: '-Nico Rosberg', car: 'Mercedes'},
	{driver: '-Kevin Magnussen', car: 'McLaren'},
	{driver: '-Jenson Button', car: 'McLaren'},
	{driver: '-Fernando Alonso', car: 'Ferrari'}
	]
	%longstring%

end if

xbasic_populate_motorsport = txt
end function

[Davidk]

Re: Programmatically update List source function

Your URL syntax is incorrect. Using your example I believe it would be...

"http://localhost/LivePreview/Sakila_List01_PageLayoutLivePreview.a5w?231153652&TEXTBOX1=200"

A variable string is characterized at the beginning by a question mark ? followed, usually, by a name=value pair. Then 2nd and subsequent variables are delimited by the & sign.

So... change your 2nd ? to & and you should be good.

[kotinkarwak]

Re: Programmatically update List source function

Thanks David, I now understand that part of the syntax.