CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge -> Programming

 how to use a variable in where SQL?

Print topic Send  topic

Author Message
codeman

Posts: 3
Posted: 09/05/2006, 10:32 AM

i need to use a variable in my where SQL but i dont know how to set it

i see other post about this, but dont work form e

for example

where clients = {clients_id}

clients_id is a variable in the URL

View profile  Send private message
WKempees
Posted: 09/05/2006, 12:37 PM

Codeman,
Q1: Are you using CodeCharge or CodeCharge Studio.
Q2:Do you want to add the Where variable in the code or in the
VisualQueryBuileder (CCS 3+)

Please state the version and programming language you are using.

In CCS3+ getting the value of a variable on the URL :
CCGetFromGet("clients_id","")
In CCS3 VQB you can set the Where parameters
on the left side on the right side
client clients_id
Integer URL

Walter

codeman

Posts: 3
Posted: 09/05/2006, 12:49 PM

i use CC only with ASP and MSSQL server
i want to add the where condition in the "field" where in "form properties" > "SQL"

now i have

clients_id ='" & getparam("client") & "'

my URL have the correct variale and value, but i dont get any result

http://mysite/aco/clientGrid.asp?client=1


View profile  Send private message

Add new topic Subscribe to topic   


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

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


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