So I have a page that I am working on and I am hainv a problem with a certai
n
db. record. I have a field called "cancertypes" In this field there are list
s
of cancer type IE

breast, gallbladder, bladder, kidney, prostate,liver

So in order to get certain values I had to make the SQL statement

SELECT *
FROM types
WHERE cancertype  LIKE '%MMColParam%'
ORDER BY sortOrder ASC, Name ASC

So I am getting some of the values from cancertypes gallbladder and bladder
showing put on the same results pages. So I want to make a VBSCRIPT if else
statements. I changed the value Gallbladder to Gall then I want to make a if
else the says if "cancer type = "gall" response.write "bladder" and add it t
hat
way. Here is the code below. Is this a good fix or does anyone know of anyth
ing
better to use?

Thanks
-Matt

<%=(Recordset1.Fields.Item("cancertype").Value)%><%
If (Recordset1.Fields.Item("cancertype").Value) = "Gall" Then
Response.Write "blader"
End If
%>

What you have done will work, however you are going to create a lot of
coding work if you abbreviate other names. If you are shortening the name to
help with input why not create a separate table to hold the names and then
link that to a drop down box on the input page.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
www.valleybiz.net

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
www.macromedia.com/support/forums/team_macromedia

"Matt - Stamats" <webforumsuser@macromedia.com> wrote in message
news:cjes57$68$1@forums.macromedia.com...
> So I have a page that I am working on and I am hainv a problem with a
certain
> db. record. I have a field called "cancertypes" In this field there are
lists
> of cancer type IE
>
>  breast, gallbladder, bladder, kidney, prostate,liver
>
>  So in order to get certain values I had to make the SQL statement
>
>  SELECT *
>  FROM types
>  WHERE cancertype  LIKE '%MMColParam%'
>  ORDER BY sortOrder ASC, Name ASC
>
>  So I am getting some of the values from cancertypes gallbladder and
bladder
> showing put on the same results pages. So I want to make a VBSCRIPT if
else
> statements. I changed the value Gallbladder to Gall then I want to make a
if
> else the says if "cancer type = "gall" response.write "bladder" and add it
that
> way. Here is the code below. Is this a good fix or does anyone know of
anything
> better to use?
>
>  Thanks
>  -Matt
>
>  <%=(Recordset1.Fields.Item("cancertype").Value)%><%
>  If (Recordset1.Fields.Item("cancertype").Value) = "Gall" Then
>  Response.Write "blader"
>      End If
>  %>
>