W D
asked on
use regexp_like with multiple values
Hi, I have the following SQL (we use Oracle) in my Crystal Reports command object:
WITH
full_narr AS(
SELECT
it.order_proc_id
, it.line
, it.narrative narr_impression
FROM impression_text it
WHERE regexp_like(it.narrative,' {?Keyword} ','i')
)
How can I use regexp_like to allow multiple values? Do I need to write multiple OR statements?
WITH
full_narr AS(
SELECT
it.order_proc_id
, it.line
, it.narrative narr_impression
FROM impression_text it
WHERE regexp_like(it.narrative,'
)
How can I use regexp_like to allow multiple values? Do I need to write multiple OR statements?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SQL does not allow multiple value input parameters. That being said, if you have Crystal Reports 2008 or 2011 then you can use multiple value input parameters with SQL Commands, because SAP has basically built in functionality that converts the list of values selected by the user into an array of values that SQL can read.
If you're using XI R2 or lower, please see this example report I've written that demonstrates how to use Multiple-value parameters with SQL Command objects:
https://www.box.net/shared/663ziq8unr
If you're using XI R2 or lower, please see this example report I've written that demonstrates how to use Multiple-value parameters with SQL Command objects:
https://www.box.net/shared/663ziq8unr
glad to help, both slightwv and mankowitz were within a couple minutes though, close enough that I'm willing to call them all effectively "simultaneous". I'm ok with splitting the points with them
ASKER
Re: I'm ok with splitting the points with them
ah, ok, sdstuber, that's very kind of you.
Since the points are already awarded, I'll contact the Expert's Exchange editors to have them update the points.
ah, ok, sdstuber, that's very kind of you.
Since the points are already awarded, I'll contact the Expert's Exchange editors to have them update the points.
sdstuber and myself are both Zone Advisors and can unaccept this if you wish.
Personally, I'm OK either way. Just let us know your wishes.
Personally, I'm OK either way. Just let us know your wishes.
ASKER
Re: slightwv and I are both Zone Advisors
Ah, good to know! I was just trolling around the site trying to figure out how to contact customer service. thanks for reopening the question for me again, sdstuber.
Regards,
w delaney
Ah, good to know! I was just trolling around the site trying to figure out how to contact customer service. thanks for reopening the question for me again, sdstuber.
Regards,
w delaney
no problem, but, if you ever do need to get help on a question scroll to the top, just under the question window itself there is a "Request Attention" link.
That will open a thread with the moderators to assist you.
That will open a thread with the moderators to assist you.
ASKER
Thanks, sdstuber!! :)
ASKER