JustPunkin
Registered User.
- Local time
- Today, 10:10
- Joined
- Jan 8, 2009
- Messages
- 38
I actually have two questions.
1 - Is there a limit to the number of operators in a sql string. In other words, how many times can I say AND or OR?
2 - I think a little background is necessary. I have a table that includes a wide variety of mechanical information regarding a product we sell. I want to be able to search this table to find projects that have a certain set of criteria based on this mechanical information. I have about 30 different features that I need to search.
Many of these fields are yes/no checkboxes. The way my sql string works now is that it assumes anything unchecked is no. I would rather it assume anything that is unchecked is either yes or no. I do know how to do this for my combo boxes - I just have an ifnull statement in my code. Is there a way to do this for checkboxes?
The answers to these questions will lead to more, but the questions are going to depend on the answers I recieve
Again, thanks in advance for the help, and please, be gentle, I'm still learning this (but, if any of you guys ever have AutoCAD questions, I'd be more than happy to help
)
Brenda
1 - Is there a limit to the number of operators in a sql string. In other words, how many times can I say AND or OR?
2 - I think a little background is necessary. I have a table that includes a wide variety of mechanical information regarding a product we sell. I want to be able to search this table to find projects that have a certain set of criteria based on this mechanical information. I have about 30 different features that I need to search.
Many of these fields are yes/no checkboxes. The way my sql string works now is that it assumes anything unchecked is no. I would rather it assume anything that is unchecked is either yes or no. I do know how to do this for my combo boxes - I just have an ifnull statement in my code. Is there a way to do this for checkboxes?
The answers to these questions will lead to more, but the questions are going to depend on the answers I recieve

Again, thanks in advance for the help, and please, be gentle, I'm still learning this (but, if any of you guys ever have AutoCAD questions, I'd be more than happy to help

Brenda