Page 1 of 1

How to populate SQL Query Result into Table field?

Posted: Thu Jul 10, 2008 3:56 pm
by 99cents
Does anybody know how to populate SQL query results into table field without using Revolution's Query Builder?

The Query Builder works as directed in populating SQL content in table format, however, I need to write more customized solution. If anyone has additional information how to populate table content via scripts, please let me know.

Thanks for the assistance!

Posted: Fri Jul 11, 2008 8:31 am
by Mark
Hi 99,

Use something like revDataFromQuery() to put the data into a variable, while using tab and return as the delimiters. A script can not put the data into fields, line by line and item by item.

You'll need to have a look at the docs.

Best,

Mark

Trying this now

Posted: Fri Jul 11, 2008 4:43 pm
by 99cents
Thanks Mark.

I keep digging to find more documentation. I'll use your suggestion as a starting point. I'll keep you posted.

Thanks again.

Populating SQL query output to table successful

Posted: Fri Jul 11, 2008 5:37 pm
by 99cents
Mark,

I read the "revDataFromQuery / Table Fields problem" in this forum and combined with your direction, I was able to be successfully populate my SQL query data into the table w/o using Rev's built in query builder.

Thanks and have a great day.

99 cents