Get a row value form dbrepeater

[fredrm]

Hi folks,

I'm having some headaches with the dbrepeater.

The problems is... I have a dbrepeater with 2 labels.

One label is showing the dbresults and the other is a lablel with caption Select that onclick it will get the code of the selected row for and use it on another sql_query.

Thanks!

[405hp]

I haven't messed with it much but these snippets will get the caption of a button or label in the dbrepeater.

//converting browser differences target= firefox or IE

function Button1JSClick($sender, $params)

{

?>
var target = event.target || event.srcElement;
alert(target.value);

<?php

}
//click on label and get caption
function Label1JSClick($sender, $params)
{

?>
var target = event.target || event.srcElement;
alert(target.innerHTML);
<?php

}

From that you will have to make your determinations.

[fredrm]

not solved... because i wanna get the value of that sql row... not the value of the label...

[405hp]

Then you must make the value of the label equal to something that allows you to determine your sql row.

[lifeform]

It would be nice to be able to use something like the Tag property of the label component to store the record id of each record in the dbrepeater. That way the caption can display something appropriate (in my case a person's name) rather than just an id number. The problem is, I can't figure out how to access the label's tag from the client side.

I suppose I could make the label's caption something like "Bloggs, Fred [32441]" and use javascript to parse the string for the number in brackets, but it's easy enough to confuse my users without displaying strange numbers in front of them.

Does anyone know how to access the tag property from javascript?

[405hp]

The tag property is php only. It doesn't transfer to the javascript side at all.

There are multiple ways of doing something like that though.

Examples:
You can create a js object (key:value pairs) that stores your needed info.
You can use hiddenFields that have the same naming conventions so you can access them.
If you are using true js objects (like textfield or bitbutton) you can create a tag on the fly after it has been created. echo "textfield1.mynewproperty=32441;";

[lifeform]

Hi 405hp, and thanks for your post. Yes, I'm using hidden fields for other areas where I want to transfer data between the client and server side, but the problem here is that the label is in a dbrepeater. As far as I understand it, that means it's not possible to access the label directly. Until I saw your post earlier in this thread, I didn't even know you could use something like

var target = event.target || event.srcElement;

to get the caption value.

The problem with key, value pairs is that I need the caption to display the value, which in the case of names is not guaranteed to be unique. If I display the key, then I'll just confuse my users, although it would function perfectly.

Do you know if there's a way to add a property to a label inside a dbrepeater in php that's available to javascript when it gets to the client side?

[405hp]

Originally Posted by lifeform

The problem with key, value pairs is that I need the caption to display the value, which in the case of names is not guaranteed to be unique. If I display the key, then I'll just confuse my users, although it would function perfectly.

Make the key=value and value=key then to use it
key=jsobject.labelcaption

[lifeform]

Thanks again, but I'm not quite with you. In the dbrepeater, I display the name (and then some other fields) and there could be a hundred or so in the list. The data comes from a query like "SELECT id, CONCAT(lastname,', ',firstname) AS fullname FROM customers", so the key is the id and the value is fullname, and there are 100 or so of the key/value pairs.

The label caption is set by the DataSource and DataField properties of the dbrepeater to "fullname" so that the names are displayed.

Using your code, I can do something like this on the label's JS OnClick event:

var target = event.target || event.srcElement;
alert(target.innerHTML);

That gives me the fullname, but what I need is the id. If I set the caption value to be id, then the dbrepeater will obviously display a list of numbers rather than names.

How could I get the id?

[405hp]

OK, visualize this pseudo code:
On the server in php code you either store an array as the labels are created or just run a loop with sql query later.

Either way in one of the forms later events (onaftershow?) do a loop output of the value:key pairs.

PHP Code:

echo '<script>';
echo 'myinfo=[];';
loop control
{
echo "myinfo.$value=$key;";
//this is the same as
//echo "myinfo.Bloggs_Fred=32441;";
}
echo '</script>'; 


Then in the jsonclick event extract the name from the labels value convert it to last_first and access it

var convertedname=string_manipulated(target.innerHTML );
alert(myinfo.convertedname);
//this is the same as
//alert(myinfo.Bloggs_Fred); //which displays 32441