Discuss "Help with If contains then" in the ASP Development forum.

mehere · #11 (**permalink**) May 2nd, 2008, 01:57 PM

show me what you have for that line. i edited my code and added a parenthesis because i was missing it when i first posted. I've tested this code in a quick sample page and i'm not getting any errors.

Rebelle · #12 (**permalink**) May 2nd, 2008, 02:00 PM

Here is what I have for the error line:

Code:

strType = MID(strLoc,inStr(strLoc,"-")+1,len(strLoc))

Thanks again!

mehere · #13 (**permalink**) May 2nd, 2008, 02:04 PM

try changing to this ... i just need to check something

Code:

strType = MID(strLoc,4,len(strLoc))

mehere · #14 (**permalink**) May 2nd, 2008, 02:26 PM

NT ... nevermind ... that wasn't it.

Rebelle · #15 (**permalink**) May 2nd, 2008, 05:27 PM

When i use this suggestion, i don't get any errors but maybe i don't have my loop right or something because it only showed "strType" once.

Code:

strType = MID(strLoc,4,len(strLoc))

I'll keep digging...Thanks Mehere!

mehere · #16 (**permalink**) May 5th, 2008, 08:49 AM

show the whole code that you're using ... maybe it's something i'm missing.

Rebelle · #17 (**permalink**) May 12th, 2008, 08:33 AM

Thanks Mehere,
Sorry for the delayed response back, last week was awful and today will be the same but I should be able to post back code tomorrow or wednesday at the latest.

mehere · #18 (**permalink**) May 12th, 2008, 01:57 PM

np ... will keep an eye out for it.

Rebelle · #19 (**permalink**) May 14th, 2008, 10:23 AM

Ok, after looking at this again, it looks like the data is a bit more complicated. Right now I do have it putting everything with ready first and then everything that contains repair.

some of the data contains more alpha/numeric and hyphens like,
XX-XX-XXX-READY
XX-XX-XXX-REPAIR-XX##
XX-XX-XXX-REPAIR

i'm not going to worry about slipping in a group name "ready" or "repair" to separate.

Thanks Mehere for all your help!!!

mehere · #20 (**permalink**) May 14th, 2008, 10:48 AM

you can add something else into your query to do this then ... add another column for the column that contains those values ... something like this

Code:

CASE WHEN CHARINDEX('READY',column_name) > 0 THEN 'READY' ELSE 'REPAIR' END AS type

change your ORDER BY clause

Code:

ORDER BY Type, column_name

then you can still use the other code i posted to keep 'REPAIR's together and 'READY's together.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Discuss "Help with If contains then" in the ASP Development forum.

ASP Development - Learn coding practices and tips to get the best out of your Active Server Pages (ASP). The Classic ASP forum is for ASP/VBScript and ASP/JScript applications.