Print Thread
Template language: user variables inside query variables
#44968 11/21/12 09:37 PM
Joined: Dec 2001
Posts: 73
Cedar Hills, UT
bcoulam Offline OP
Member
OP Offline
Member
Joined: Dec 2001
Posts: 73
Cedar Hills, UT
Marco,

If I haven't requested this enhancement before, will do so now. I'm sure all your users would benefit from it.

I'd like to be able to prompt the user for a value, then use that value in a query variable in the same template.

For example, I have a unit testing script that tests new view results against the old view results. I'd like my template to prompt for a user variable, [view_name], then use that to fill the following query variable:

[$QUERY vw_cols =
SELECT column_name
FROM user_tab_columns
WHERE table_name = UPPER('[view_name]')
ORDER BY column_id]

I would use that column list to populate the various SELECT statements in my unit testing script.

Instead PSD tells me my SQL statement is invalid, which it would not be if [view_name] were substituted after user entry.

Re: Template language: user variables inside query variables
bcoulam #44970 11/22/12 10:38 AM
Joined: Aug 1999
Posts: 22,232
Member
Offline
Member
Joined: Aug 1999
Posts: 22,232
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.046s Queries: 15 (0.012s) Memory: 2.4975 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-06-17 13:10:12 UTC
Valid HTML 5 and Valid CSS