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

mehere · #11 (**permalink**) 05-02-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**) 05-02-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**) 05-02-2008, 02:04 PM

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

Code:

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

mehere · #14 (**permalink**) 05-02-2008, 02:26 PM

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

Rebelle · #15 (**permalink**) 05-02-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**) 05-05-2008, 08:49 AM

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

Rebelle · #17 (**permalink**) 05-12-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**) 05-12-2008, 01:57 PM

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

Rebelle · #19 (**permalink**) 05-14-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**) 05-14-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.