Hi there again..
Thanks for your help.. I have now discovered something weird that explains
the problem below..
When I check froa a value or print a value from recordset the value is
emptied ! This is why I have the problem.
I tested with the below code :
1 <%
2 response.Write "profile1 - " &
(Recordset1.Fields.Item("profile1").Value) & "-<br> "
3 ' if ((Recordset1.Fields.Item("profile1").Value) <> null) then
4 response.Write "Pro1 " & (Recordset1.Fields.Item("profile1").Value)
5 ' End IF
6 %>
When I execute the above the response is :
profile1 - Photoshop and guitar playing-
Pro1
Therefore the value of (Recordset1.Fields.Item("profile1").Value) is now
somehow empty in line 4 !
When I comment line 2 the response is :
Pro1 Photoshop and guitar playing
So now (Recordset1.Fields.Item("profile1").Value) in line 4 prints !
The value of (Recordset1.Fields.Item("profile1").Value) is also emptied on
any checking for null.
I know line 3 may be incorrect for the moment but this is commented for this
test.
Any ideas on this pls ?
Thanks again
"raj chahal" <in**@digitise.info> wrote in message
news:%2****************@TK2MSFTNGP14.phx.gbl...
Hi there
I need to be able to print on screen when I check if a value within a db
<td>
<% if ((Recordset1.Fields.Item("profile1").Value) <>
"") then response.Write"Pro1<br>" &
Recordset1.Fields.Item("profile1").Value%>
</td>
I am checking if profile1 contains any text if not don't print anything.
If yes then print the heading and the contents .
Now the problem is that I cannot seem to check the value and print the
same value.
If I check profile2 instead of profile1 (which contains a value) then
profile1 is printed.
At the moment only Pro1 is written to the screen but the contents of
profile1 is not, eventhough profile1 is not empty.
What could be wrong ??
Thanks