Hi

I have two culum in Access DB name "Imain" "I2" for image name.

I want to show users from catalogue page

More pictures available (which will reffer from I2) if there is any picture name then show "More pictures available" or if I2 is Null then ignore the text.

I found a code but not sure how to manupulate.

<%Dim TextShow
TextShow = rsletting_list.Fields.Item("I2".Value
IF TextShow <>"" THEN%>
<%=TextShow%>">
<%ELSE%>
<b>Extra photographs available</b>
<%End If%>

Please help with advice.

Babu

- The first code line is just creating a variable called TextShow;
- The next line is setting TextShow to the value of the database in the I2 Column;
- The third line is the beginning of an IF block and the <> means "" IF NOT" so if the string IS NOT EMPTY then it will write the contents out of I2 on your screen.
- The fourth is an ELSE block that will be processed when the first IF tag is NOT true (so it is filled) and then the normal HTML code <b>Extra..... available</b> is written to the browser.


<hr><b>DMXZone support manager</b><br><a href="www.kousman.nl">Kousman web resellers</a>

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
- The first code line is just creating a variable called TextShow;
- The next line is setting TextShow to the value of the database in the I2 Column;
- The third line is the beginning of an IF block and the &lt;&gt; means "" IF NOT" so if the string IS NOT EMPTY then it will write the contents out of I2 on your screen.
- The fourth is an ELSE block that will be processed when the first IF tag is NOT true (so it is filled) and then the normal HTML code &lt;b&gt;Extra..... available&lt;/b&gt; is written to the browser.


&lt;hr&gt;<b>DMXZone support manager</b><br>&lt;a href="www.kousman.nl"&gt;Kousman web resellers&lt;/a&gt;
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>



Thanks RENE,

Pretty much I understand the explanation now. But how can I modify something like:

If I2 value is something then write - Extra Photographs Available
If I2 value is nothing then do not write anything.

Please help with advice.

Babu

Try this
<pre id=code><font face=courier size=2 id=code>&lt;% if rs.fields("I2" &lt;&gt;"" then response.write("Extra Photographs Available" %&gt; </font id=code></pre id=code>

Hope it helps

Wayne

Thanks a lot....absolutely fine<img src=../images/dmxzone/forum/icon_smile_big.gif border=0 align=middle>

Babu