How do I create hyperlinks that include data from my database?

This topic is locked

How do I create hyperlinks that include data from my database?		12/13/2011 18:21:22
ASPRunnerPro General questions
N new_user2012 author Hi, This is probably a very easy question but I can't figure it out. I'm using ASPRunner 7.0 and I'm looking for a way to create hyperlinks on my list page that include data from my database. I tried using the following code and wrapping it around a particular field on my list page, but it doesn't work: <a href="http://www.mywebsite.com/{$Field1_value}/{$Field2_value}/{$Field3_value}">; </a> How would I do this in ASPRunner 7.0? Thanks in advance.


T	Tim 12/13/2011
	To include one field from your db to the end of a path, in the Visual Editor right-click the field and choose properties, then set the "View As" type to Hyperlink, then in the URL prefix put http://www.mywebsite.com/ the field data will be added to the end of that. If you want field1/field2 to be appended to the prefix I would create that as one field in the query. This depends on what db you're using, but if you are using MySQL you would go to the Query page in ASPRunner and do select concat(filed1,'/',field2,'/',field3) as LinkInfo from yourdb then on the Visual Editor use that field to do what I said earlier. hope this helps. Tim