Graphics

I've successfully Datalinq'd my statcrew .xml to my project in XPression, I am not familiar with scripting and was wondering if anyone had an existing script or knowledge on how to do the following:

I am trying to pull two pieces of data in to a single text box and separate it by a -.

An example would be, I am trying to pull fgm and fga fields to read within ONE text box as the following....30-40.

I am also confused how I would go about adding a character inside the datalinq'd textbox to read as percentages.

Any advice, videos, or assistance with scripts would be appreciated.

Use Visual Logic for that :



Set fga and fgm to "not visible" in the scene

#XPression

Thank you Vincent! This worked perfectly. Appreciate your help!

#XPression

Follow up question: If I wanted to generate a percentage instead of the data reading "2 - 3", I want it to read "66.6%". I haven't been able to figure out how to add the percentage sign at the end, and how to limit the decimal field to one decimal place. I'm generating the .666 number needed for my percentage by dividing "fgm" and "fga". I'm then multiplying that by 100.0 to have it read 66.666. Then taking the average value which leaves me at 66.666. My end goal would be to have it read 66.6%

Is there a .pdf or documentation on Visual Logic to assist?

#XPression

#XPression

I"m trying to Election Results using datalinq to a database, and I want to add a '%' to the end, among other things. I was looking at the visual logic above, and I was able to add the '%,' but then my decimal disappeared. Is there any way to:

Pull the data from datalinq, limit the decimal to one point, unless it's 100%, and add the '%' only if the number is greater than '0'?

On another note, is there a way to avoid creating a scene for every election race, for instance, the producer puts a Race ID number, or some other identifier into a text field, and it populates the data from the database that corresponds to that ID? There's another question on the forum that references this, but there was no answer given. That's at http://discussions.rossvideo.com/forum/default-forum-gc1/xpression-cg-and-graphics-system-gc12/8821-mssql-to-datalinq

Thanks!
#XPression