Graphics

Hi all,

Putting another question out here for the forum. We are becoming more comfortable with the DataLinq Server and understand it is possible to key data without a numerical string but with text. For example, if I build an ADODB database from an Excel Spreadsheet with a list of people with PNGs and data am I able to call on that database information without a number, and perhaps preferably, with the first initial and last name (i.e. HHANSON) ?

Any input would be helpful!

Yes, you can actually execute a full SQL query to find the data you want.. For example, in the Table field in the TextObject Datalinq you could put `"SELECT HEADSHOT FROM ROSTER WHERE LASTNAME='%lastname%'"`

You can get some assistance and ideas from this video: http://xpression.rossvideo.com/videos/Datalinq_SQL_Queries/Datalinq_SQL_Queries.html

#XPression

Fantastic! Would I need to somehow convert over to an SQL Database, or could I use the SQL features within Excel to make the query possible?

#XPression

The ADODB datalinq accesses the Excel sheet as if it were a database and that is what allows the SQL queries to work. You do not need to switch to an actual database. You do not even need to use the SQL features within Excel to do it. Hopefully the video is clear; if not let us know where you are having issues and we'll try to help.

#XPression

Great news! Thank you so much Brian!

#XPression

Is that also possible with xml, to sort some post based on higest value?

#XPression

No, that is only possible with sources using the ADODB datalinq.

#XPression