I have a page with a Repeated where the Data Object bound to the Repeated, has
SQL something like:
SELECT col1, col2, col3, col4, col5
FROM tableX
WHERE X_id = xxxxx
At runtime I'd like to be able to conditionally change the FROM and WHERE clause
to reference another table but selecting the exact same 5 column names.
What would be the best way to do this? Some guesses:
1. override the DO's SQL via code. If this is best solution, do you recommend
full text override or partial? (I know the code snippet syntax for full text
override, but not partial.)
2. Put 2 Repeateds on the page (each bound a diff DO) and in their
_onDisplayEvent do the condition chk and return SKIP or PROCEED to only show one
of them. If I did that, will the Repeated being skipped still retrieve its rows
from the database even if I'm not displaying them?
Thanks,
Janet
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
