Pass URL parameter to dlookup??

CodeCharge Studio

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> General/Other

Pass URL parameter to dlookup??

Author

Message

Posted: 03/07/2005, 5:25 PM

Is it possible to pass a URL parameter to the WHERE clause of a dlookup? Eg I want to look up a product name from the products table, and the prod_id is a paramater in the URL, and I want to have the following in the WHERE clause:

product_id=prod_id

(product_id is the column in the products table)

Is it possible to do that simply or would I have to write code for it?

VN

peterr

Posts: 5971

Posted: 03/08/2005, 12:22 AM

You would need to enter some code that retrieves the URL parameter into the "Criteria" property of the Dlookup action.
In PHP it could be:
"product_id=".CCGetParam("prod_id","")
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com

Oper

Posts: 1195

Posted: 03/08/2005, 5:03 AM

in ASP:

"product_id=" & request.querystring("prod_id")

_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)

http://www.PremiumWebTemplate.com
Affiliation Web Site Templates

Please do backup first

matheus

Posts: 386

Posted: 03/08/2005, 5:11 AM

in JSP & Servlet

Quote :
"product_id="+e.getPage().getRequest().getParameter("prod_id")

_________________
Matheus Trevizan

Dynamix Software Ltda.
Blumenau SC Brasil
www.dynamix.com.br

Posted: 03/08/2005, 7:17 PM

Thank you all very much. That answers my question.

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

PHP Reports

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

Home | Search | Members | Register | Login