View Single Post
  #5 (permalink)  
Old 02-01-09, 11:19
freeBatjko freeBatjko is offline
Registered User
 
Join Date: Mar 2008
Posts: 89
Quote:
Originally Posted by steve.muench
Using the approach I outlined in the screencast (a read-only view object based on a SQL statement) the query can be of arbitrary complexity, so long as it parses as a valid SQL statement.
This might sound very inexperienced, and well... I am.
But in my SQL I have been using ampersand variables (i.e. &myvar1, &myvar 2...), instead of real bind variables (:myvar1...), in order to prompt the user to provide the input.

I would think I can just exchange the &'s with :'s, am I right?
__________________
"My brain is just no good at being a relational Database - my relations suck real bad!"
Reply With Quote