CodeCharge Studio
search Register Login  

Visual PHP Web Development

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

YesSoftware Forums -> CodeCharge Studio -> PHP

 Conditional Where Clause

Print topic Send  topic

Author Message
russew

Posts: 4
Posted: 07/11/2005, 3:10 PM

I have an include page for bread crumbs using the Path component that is used on various pages. The primary query calls for Department_ID = query String d_id. (No default value set). I would like to make one page to handle 16 departments, without making 16 pages that do the same thing with a different default value set on each page.

I added this code in the Before Build Select:

if ($AcademicBreadCrumbs->NewPath1->ds->Where = "") {
$AcademicBreadCrumbs->NewPath1->ds->Where .= "department_id = 64";
}

This is hard coded for testing, but eventually I will set a variable for the department ID. Unfortunately this doesn't work. The sub pages pull up the Bread Crumbs/Path just fine, but the initial page has no default value. Any thoughts are appreciated.
_________________
wjr
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.

Web Database

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.