DRW Question

[skc]

See:

http://www.romfordcommercials.com/showroom0.asp

I have a drop-down for the various fields in my database,
as I am using the DRW (drop-down list) for the drop-down.

On the showroom.asp, I want my DRW to take all the 4 drop-
downs from showroom0.asp (still incomplete).

So I need a custom DRW on page showroom.asp to take all 4
parameters from showroom0.asp, which are independent forms
going to the same page to fetch the results.

The fields in my database are:

Make: Text
Model: Text
Description: Memo
Price: Currency

The backend database is Access2000.

Thanks,

skc

 

[Jim Buyens]

1. On page 3 of the DRW, click More Options and then
Criteria.
2. Click Add, then specify:
Field Name: Make
Comparison: Like
Value: make
Use This Search Form Field: selected
And/Or: And
and click OK.
3. Repeat step 2 for Model and Description. Be
sure to keep changing the field name *and* the value
name.
4. Click Add, then specify:
Field Name: Price
Comparison: Not Greater Than
Value: price
Use This Search Form Field: selected
And/Or: And
and click OK.
4. Click OK, then click Defaults.
5. Select Price, then click Edit, specify 999999.
6. Click OK, OK, Next, Next.
7. On page 5 of the DRW, make sure the Add Search Form
check box is cleared, and then click Finish.
8. Double-click any yellow area in the database results
region.
9. On page 2 of the DRW, click Custom Query and Edit.
This should reveal a SQL statement that includes this
code:
WHERE (Make LIKE '::make::'
AND Model LIKE '::model::'
AND Description LIKE '::description::'
AND Price > :rice:
8. Add percent signs around each occurrence of the
the word "keyword". Here are some samaple results.
WHERE (Make LIKE '::%make%::'
AND Model LIKE '::%model%::'
AND Description LIKE '::%description%::'
AND Price > :rice:
9. Click OK, Next, Next, Next, and Finish.
10. Save the page, and test it using an http:// URL.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------