Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 314
  • Last Modified:

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

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
GuitarFingers
Asked:
GuitarFingers
  • 7
  • 5
1 Solution
 
Wayne BarronAuthor, Web DeveloperCommented:
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
 
GuitarFingersAuthor Commented:
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
 
Wayne BarronAuthor, Web DeveloperCommented:
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
GuitarFingersAuthor Commented:
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
 
Wayne BarronAuthor, Web DeveloperCommented:
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
 
Wayne BarronAuthor, Web DeveloperCommented:
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
 
GuitarFingersAuthor Commented:
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
 
Wayne BarronAuthor, Web DeveloperCommented:
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
 
Wayne BarronAuthor, Web DeveloperCommented:
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
 
GuitarFingersAuthor Commented:
Carrzkiss,

That's exactly it! I want to thank you so much for taking your time to assist me in this problem.
0
 
GuitarFingersAuthor Commented:
Thank you for your time..!!
0
 
Wayne BarronAuthor, Web DeveloperCommented:
you are welcome.
Keep on coding.

Carrzkiss
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now