Solved

How to keep fields from populating on a page based on a certain criteria.

Posted on 2009-05-17
12
305 Views
Last Modified: 2012-05-07
Hi Guys,

Working on a real estate site here with DW CS4, MS Access 2000, VB, and Classic ASP. I have an insert form where when properties are entered, the user has the option of choosing yes or no for certain attributes. For example you may choose yes for a formal living room, while then choosing no for a great room.

I desire to have all of these options be put into the details page of the property, but have only those with a yes value display. Can one of you experts please guide me through doing this.

Advance notice, not a great coder, so please be detailed about where to place code if it is a code only solutions. Would love to know a DW method. OR a method to do the query in Access to be used as a 'view' in DW that I can just pass an ID off to.

Thanks

GF -
0
Comment
Question by:GuitarFingers
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 31

Expert Comment

by:Wayne Barron
ID: 24408153
You have a LOT of requirements, but with little explainlation of what you are needing.
Yes/No
Yes - option
No - Option.

You need to be a little more specific as to what you are wanting to accomplish.
As I think that I know what you are wanting, I just need some more insite as to what you
Are needing in All.

All Properties, all values.
This is information stored in a database and retrieved using a different set of attributes.

Please provide as much detail as possible, and I will see about assisting in this feature rich project.

Carrzkiss
0
 
LVL 9

Author Comment

by:GuitarFingers
ID: 24408284
Carrz

The choices would be available in a drop down box. An example would be something on the order like this:

Central Air Conditioning Yes or No
Central Heating Yes or No
Laundry Room Yes or No
Refrigerator Yes or No
Washer Yes or No
Dryer Yes or No
Basement Yes or No

There will be more choices, but the options will remain the same. You either have this item, or you do not. Hope this helps.

GF -

0
 
LVL 31

Expert Comment

by:Wayne Barron
ID: 24409303
Love the name Guitar.

Are you wanting to have a selections page, that allows the person to insert their information
From options that are listed? And then have this information inserted into a database?

If that is what you are wanting, then this is a little example of how that is done.
http://ee.cffcs.com/Q_24416204/choose.asp
code
http://ee.cffcs.com/Q_24416204/Q_24416204.zip

If this is not what you are wanting, please let me know and I will try to assist to help
Your coding dream a reality.

Carrzkiss
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 9

Author Comment

by:GuitarFingers
ID: 24411148
Carrzkiss,

Yes, that is exactly it, and that part I can do with dreamweaver and the insert record behavour. What I don't know how to do is when I query that information to make it display on the details page, I don't want items that have "no" for a value to populate on the details page. Does that make sense?

Thanks Again,
GF -
0
 
LVL 31

Expert Comment

by:Wayne Barron
ID: 24415553
OK.
http://ee.cffcs.com/Q_24416204/Info.asp?Houseid=1 ' This will display Yes items
http://ee.cffcs.com/Q_24416204/Info.asp?Houseid=3 ' This will display Yes items
http://ee.cffcs.com/Q_24416204/Info.asp?Houseid=8 ' This will display Yes items and no Info
(Th Additional Information as a Default Value set in the database, this information is challanged
Against the Display Record, if it matches, then Do Not Display, Please have a look at the Database
For the Default value for the [AddInfo] Field)

http://ee.cffcs.com/Q_24416204/choose.asp
Code
http://ee.cffcs.com/Q_24416204/Q_24416204.zip

Let me know if you need any additional assistance.
Carrzkiss
0
 
LVL 31

Expert Comment

by:Wayne Barron
ID: 24415569
GF.
Do me a favor, I know that you are using DW (I use DWCS3)
Do not use it to generate your ASP/SQL coding. Only use it to get an understanding, and then
Do the rest on your own.
I use DWCS3 to do my site design and layout, and that is it.
All the coding I do is all hand-coded.

Have a good one.
Carrzkiss
0
 
LVL 9

Author Comment

by:GuitarFingers
ID: 24429583
Carrzkiss,

thank you so much for your efforts here. I hope I am saying this right as it looks like you are understanding me. What I am hoping can be done is to have only the item to display and not the word "yes". So... if for example there is central air, then 'central air' would show up in the list without the word "yes", and then items that are no's, just would not show up.

Thanks Again

GF
0
 
LVL 31

Expert Comment

by:Wayne Barron
ID: 24429596
OK.
So instead of this
=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Central Air Conditioning Yes
Laundry Room Yes
=-=-=-=-=-=-=-=-=-=-=-=-=-=-
You want it to look like this instead.
=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Central Air Conditioning
Laundry Room
=-=-=-=-=-=-=-=-=-=-=-=-=-=-
0
 
LVL 31

Accepted Solution

by:
Wayne Barron earned 500 total points
ID: 24429619
Done.


http://ee.cffcs.com/Q_24416204/Info.asp?Houseid=1 ' This will display Yes items
http://ee.cffcs.com/Q_24416204/Info.asp?Houseid=3 ' This will display Yes items
http://ee.cffcs.com/Q_24416204/Info.asp?Houseid=8 ' This will display Yes items and no Info
(Th Additional Information as a Default Value set in the database, this information is challanged
Against the Display Record, if it matches, then Do Not Display, Please have a look at the Database
For the Default value for the [AddInfo] Field)

http://ee.cffcs.com/Q_24416204/choose.asp
Code
http://ee.cffcs.com/Q_24416204/Q_24416204.zip
0
 
LVL 9

Author Comment

by:GuitarFingers
ID: 24464143
Carrzkiss,

That's exactly it! I want to thank you so much for taking your time to assist me in this problem.
0
 
LVL 9

Author Closing Comment

by:GuitarFingers
ID: 31582440
Thank you for your time..!!
0
 
LVL 31

Expert Comment

by:Wayne Barron
ID: 24467885
you are welcome.
Keep on coding.

Carrzkiss
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question