We have a need to do a select query. The "WHERE" of the SQL statement

scotte over 9 years ago

We have a need to do a select query. The "WHERE" of the SQL statement will need to be dynamic.The reason is that this is a "search" that our users are doing. They may select to search on 1 to 5 fields. In other words, the columns in our where clause will vary depending on the user situation. When using the Query Database smart node, we are struggling to find a way to accomplish this. Is there a way to get this done? Thanks!...

Discussion posts and replies are publicly visible

Parents

0 scotte over 9 years ago

csteward... You said you did this. This is not working as you say. If you leave blank we are getting NO results? We would like to use the way you mention but no luck. In fact if blank I put the value "%" in the search field. This does not give us the correct results ethier. When using % there it only returns records if a value is in field.?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 scotte over 9 years ago

csteward... You said you did this. This is not working as you say. If you leave blank we are getting NO results? We would like to use the way you mention but no luck. In fact if blank I put the value "%" in the search field. This does not give us the correct results ethier. When using % there it only returns records if a value is in field.?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data