Dashboard > GreenPepperOpen > ... > Database > Parameters as bind variables
  GreenPepperOpen Log In View a printable version of the current page.  
  Parameters as bind variables
Added by Francois Denommee, last edited by Francois Denommee on Jan 27, 2010
Labels: 
(None)

Set interpreter can be used to set symbol values explicitly. They are then available to queries and statements as bind variables.

database-connection

connect to MySql database on localhost with username dbgreenpepper and password dbgreenpepper and database dbgreenpepper

insert into Table   users
username name
pera pera pera
nuja nuja nuja
nnn nnn nnn
set parameter   p1   pera

Symbols are then automatically available as bind variables for queries

set of query   Select * from users where username=@p1
username name
pera pera pera

DEMONSTRATION LICENSE - This Confluence site is for demonstration purposes only. Evaluate Confluence today.
Powered by Atlassian Confluence, the Enterprise Wiki. (Version: 2.4.3 Build:#705 Mar 21, 2007) - Bug/feature request - Contact Administrators