How to populate SQL Query Result into Table field?

[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!

[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

[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.

[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