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
|
|
|
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
|
|
|
|