Sinist0r
July 26th, 2005, 12:47 PM
Hello people,
you'll have to excuse me, as im a bit of a newbit to this, in at the deep end as always. Basically, this is for our sales package, and im trying to get it to pick up on multiple bit's of text against the same table. Let me show you what i have tried, and see if anyone can give me any suggestions!!!! as nothing ive tried is based on knowlege of it, just through it seeming the right thing to do!!!
If I use:
if {ORD_DETAIL.OD_PRICE_CODE} = "CITYAM" then "CITY AM - *NO PAPERWORK* - PICKUP BOX"
All prints out fine.
if {ORD_DETAIL.OD_PRICE_CODE} = "PLAIN LABEL" then "DO NOT SHIP PAPERWORK"
All prints out fine.
if {ORD_DETAIL.OD_PRICE_CODE} = "CITYAM" and “PLAIN LABEL” then "CITY AM - *NO PAPERWORK* - PICKUP BOX"
Boolean Error (expected I suppose).
if {ORD_DETAIL.OD_PRICE_CODE} = "CITYAM" and {ORD_DETAIL.OD_PRICE_CODE} = "PLAIN LABEL" then "CITY AM - *NO PAPERWORK* - PICKUP BOX" else “failed”
Just get the words 'failed' print up. Since then i have also tried doing 'Then if' for the second string, but no joy either. The main problem is that our dataset looks like:
OD_ORDER_NUMBER OD_ACCOUNT OD_PRICE_CODE
48684 DD828444 PICKUP
48684 DD828444 PLAIN LABEL
48684 DD828444 CITYAM
This then leaves several things to match under that one field, and i can't get it to match in pairs!!!!!!!
It might help to know the orig problem for me to want to do it this way. Theres potentially a combination of upto 3 different combinations on alerts. First of all i started by making 3 different formula's, but once it had printed off text from the first one, 2 and 3 would bring back nothing, remove the line from the order that the first formula is set to look for, and it will then print the 2nd match, and not the 3rd (and so on).
My appologies for poor construction of this post, but im at the end of a very steep learning curve of a day!!!
you'll have to excuse me, as im a bit of a newbit to this, in at the deep end as always. Basically, this is for our sales package, and im trying to get it to pick up on multiple bit's of text against the same table. Let me show you what i have tried, and see if anyone can give me any suggestions!!!! as nothing ive tried is based on knowlege of it, just through it seeming the right thing to do!!!
If I use:
if {ORD_DETAIL.OD_PRICE_CODE} = "CITYAM" then "CITY AM - *NO PAPERWORK* - PICKUP BOX"
All prints out fine.
if {ORD_DETAIL.OD_PRICE_CODE} = "PLAIN LABEL" then "DO NOT SHIP PAPERWORK"
All prints out fine.
if {ORD_DETAIL.OD_PRICE_CODE} = "CITYAM" and “PLAIN LABEL” then "CITY AM - *NO PAPERWORK* - PICKUP BOX"
Boolean Error (expected I suppose).
if {ORD_DETAIL.OD_PRICE_CODE} = "CITYAM" and {ORD_DETAIL.OD_PRICE_CODE} = "PLAIN LABEL" then "CITY AM - *NO PAPERWORK* - PICKUP BOX" else “failed”
Just get the words 'failed' print up. Since then i have also tried doing 'Then if' for the second string, but no joy either. The main problem is that our dataset looks like:
OD_ORDER_NUMBER OD_ACCOUNT OD_PRICE_CODE
48684 DD828444 PICKUP
48684 DD828444 PLAIN LABEL
48684 DD828444 CITYAM
This then leaves several things to match under that one field, and i can't get it to match in pairs!!!!!!!
It might help to know the orig problem for me to want to do it this way. Theres potentially a combination of upto 3 different combinations on alerts. First of all i started by making 3 different formula's, but once it had printed off text from the first one, 2 and 3 would bring back nothing, remove the line from the order that the first formula is set to look for, and it will then print the 2nd match, and not the 3rd (and so on).
My appologies for poor construction of this post, but im at the end of a very steep learning curve of a day!!!