We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Solved
classic aspvb syntax question
Posted on 2013-11-09
Hi,
I have an old asp site that I need to modify. We have a menu item that shows under a certain condition with a usertype field:
and then we show the menu item.
We recently modified a database field so that a single user record can be assigned multiple types in a comma delimited list. So instead of UserType=1, for our condition, we need to check if Session("UserType") contains 1 in a comma delimited list.
assuming users will have values like 1,7,8 or 1,3,7 how can I scan and confirm a "contains" condition in asp vb?
Thank you
Bill
I have an old asp site that I need to modify. We have a menu item that shows under a certain condition with a usertype field:
<% IF Session("UserType") = 1 OR Session("UserType") = 7 THEN %>
and then we show the menu item.
We recently modified a database field so that a single user record can be assigned multiple types in a comma delimited list. So instead of UserType=1, for our condition, we need to check if Session("UserType") contains 1 in a comma delimited list.
assuming users will have values like 1,7,8 or 1,3,7 how can I scan and confirm a "contains" condition in asp vb?
Thank you
Bill
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
3
2
2- +1
8 Comments
Assuming no number bigger than 9 then you can do
instr(Session("UserType"),
If greater than 9 then
instr(","&Session("UserTyp
instr(Session("UserType"),
If greater than 9 then
instr(","&Session("UserTyp
Active today
<%
test="1,3,7,9,10"
if checkIT(test)=1 then
%>
<div class="nav">Nav bar</div>
<%
end if
%>
<%
' functions are typically at the top or bottom of your page.
function checkIT(user_type)
checkIT=0
arrUsertype=split(user_type,",")
for each number in arrUsertype
if cstr(number)="1" then
checkIT=1
end if
next
end function
%>
Hi,
I would go the route with padas solution BUT would extend it a little bit - just to pass the check parameter as well:
HTH
Rainer
I would go the route with padas solution BUT would extend it a little bit - just to pass the check parameter as well:
<%
test="1,3,7,9,10"
if checkIT(test,"1") OR checkIT(test,"7") then
%>
<div class="nav">Nav bar</div>
<%
end if
%>
<%
' functions are typically at the top or bottom of your page.
function checkIT(user_type,valueToCheck)
checkIT=false
arrUsertype=split(user_type,",")
for each number in arrUsertype
if cstr(number)=cstr(valueToCheck) then
checkIT=true
end if
next
end function
%>
HTH
Rainer
Thanks All - now Gary's solution is clearly the simplest, and right now all values are 1 - 8, but just to clarify, the second example assumes the number MUST be greater than 9?
So truly if we get to 10 user types, we need to use Pradas or Rainer's solutions?
So truly if we get to 10 user types, we need to use Pradas or Rainer's solutions?
Hi,
Gary`s is the quickest one - but hard to read and you have always to add the "," before and after your session variable. This will work for any number but it could be not as error save as Padas/my solution due to the extras you have to add.
Padas solution is the right one in terms of best practices as it creates the array with the distinct values and then runs the compare.
My extension to Padas solution just make it usable for any check you want to run - check for 5 or 10 or ...
Just my 2ct
Rainer
Gary`s is the quickest one - but hard to read and you have always to add the "," before and after your session variable. This will work for any number but it could be not as error save as Padas/my solution due to the extras you have to add.
Padas solution is the right one in terms of best practices as it creates the array with the distinct values and then runs the compare.
My extension to Padas solution just make it usable for any check you want to run - check for 5 or 10 or ...
Just my 2ct
Rainer
OK thx - I have another question related to this that I will post right now, to not abuse my points. =)
Featured Post
Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Welcome, welcome! If you are new to the series and haven't been following along, please take a brief moment to review the first three installments:
Part 1 (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/A_266-VBScri…
Not long ago I saw a question in the VB Script forum that I thought would not take much time. You can read that question (Question ID (http://www.experts-exchange.com/Programming/Languages/Visual_Basic/VB_Script/Q_28455246.html)28455246) Here (http…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster.
To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
How to fix incompatible JVM issue while installing Eclipse
While installing Eclipse in windows, got one error like above and unable to proceed with the installation.
This video describes how to successfully install Eclipse.
How to solve incompa…
Suggested Courses
Course of the Month9 days, 10 hours left to enroll
722 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.