GuitarFingers
asked on
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 -
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 -
ASKER
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 -
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 -
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
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
ASKER
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 -
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 -
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
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
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
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
ASKER
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
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
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
=-=-=-=-=-=-=-=-=-=-=-=-=- =-
So instead of this
=-=-=-=-=-=-=-=-=-=-=-=-=-
Central Air Conditioning Yes
Laundry Room Yes
=-=-=-=-=-=-=-=-=-=-=-=-=-
You want it to look like this instead.
=-=-=-=-=-=-=-=-=-=-=-=-=-
Central Air Conditioning
Laundry Room
=-=-=-=-=-=-=-=-=-=-=-=-=-
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Carrzkiss,
That's exactly it! I want to thank you so much for taking your time to assist me in this problem.
That's exactly it! I want to thank you so much for taking your time to assist me in this problem.
ASKER
Thank you for your time..!!
you are welcome.
Keep on coding.
Carrzkiss
Keep on coding.
Carrzkiss
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