CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 parameter with SQL and CCS SQL grid Builder

Print topic Send  topic

Author Message
carlo
Posted: 09/05/2003, 3:12 AM

I'm Using MySQL....
I create a new Grid, I select "Data Source Type = SQL" and then I write the
SQL string into "Data Source", the question is this: How can I write a
parameter into that string.

Ex.:
SELECT * FROM tbluser WHERE nome=PARAMETER

How Could I write "PARAMETER" so that it is consider as a parameter?????

Tanks a lot
RonB
Posted: 09/05/2003, 4:21 PM

in the query use the {} to define parameters:

select bla from blabla where number_field={parameter_name}
or

Select bla from blabla where text_field='parameter_name}'

In the parameters box click on the + sign and under variable type parameter_name and select the source under "source"

That's it

Ron

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.