Solved

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

Posted on 2009-05-17
12
301 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
  • 7
  • 5
12 Comments
 
LVL 30

Expert Comment

by:Wayne Barron
Comment Utility
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
Comment Utility
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 30

Expert Comment

by:Wayne Barron
Comment Utility
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
 
LVL 9

Author Comment

by:GuitarFingers
Comment Utility
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 30

Expert Comment

by:Wayne Barron
Comment Utility
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 30

Expert Comment

by:Wayne Barron
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 9

Author Comment

by:GuitarFingers
Comment Utility
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 30

Expert Comment

by:Wayne Barron
Comment Utility
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 30

Accepted Solution

by:
Wayne Barron earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Thank you for your time..!!
0
 
LVL 30

Expert Comment

by:Wayne Barron
Comment Utility
you are welcome.
Keep on coding.

Carrzkiss
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
PL/SQL can be a very powerful tool for working directly with database tables. Being able to loop will allow you to perform more complex operations, but can be a little tricky to write correctly. This article will provide examples of basic loops alon…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now