Brilliant!
Thanks to both Bryan Ashcraft & Crash, sorted now.
Gary
"crash" <crash@bcdcdigital.com> wrote in message
news:e4km4g$9rp$1@forums.macromedia.com...
> Does your database hold "yes" as a checkmark?
>
> I would try true/false or 0/1.
>
> Jon
>
> "woodywyatt" <woodywyatt@fuerteventura.com> wrote
in message
> news:e4k7ev$kf0$1@forums.macromedia.com...
>> Hi Bryan
>> Tried that, but I don't seem to get the 'Field to
display' to actually
>> show on the page.
>> See my code below -
>>
>> <% If Recordset1.Fields.Item("check").Value = yes
Then %
>> <%= Recordset1.Fields.Item("hyperlink").Value
%><input name="hiddenField"
>> type="hidden"
value="<%=(Recordset1.Fields.Item("check").Value)%>">
>> <% End If %>
>>
>> Any ideas what I'm doing wrong?
>> Many thanks
>> Gary
>>
>>
>> "Bryan Ashcraft" <bashcraft@wmtBRAIN.com>
wrote in message
>> news:e4iq6n$qo5$1@forums.macromedia.com...
>>> Just use an if to check the value of the field.
>>>
>>> <% If
YourRecordset.Fields.Item("FieldToCheck").Value = someValue Then
>>> %>
>>> <%=
YourRecordset.Fields.Item("FieldToDisplay").Value %>
>>> <% End If %>
>>>
>>> --
>>> Bryan Ashcraft (remove brain to reply)
>>> Web Application Developer
>>> Wright Medical Technologies, Inc.
>>> =============================
>>> Macromedia Certified Dreamweaver Developer
>>> Adobe Community Expert (DW) ::
http://www.adobe.com/communities/experts/
>>>
>>>
>>> "woodywyatt"
<woodywyatt@fuerteventura.com> wrote in message
>>> news:e4i9m9$5rv$1@forums.macromedia.com...
>>>> Hi, thanks for the swift reply
>>>> I'm using VBSCRIPT
>>>> The code for the weblink is
>>>>
<%=(Recordset1.Fields.Item("webtext").Value)%>
>>>>
<%=MakeHyperlink((Recordset1.Fields.Item("hyperlink").Value))%>
>>>> Where/how do I insert the code you provided?
>>>>
>>>>
>>>>
>>>> "crash" <crash@bcdcdigital.com> wrote
in message
>>>> news:e4i5n9$g7$1@forums.macromedia.com...
>>>>> what language are you using?
>>>>>
>>>>> basically
>>>>>
>>>>> varRecip = RecordsetCheckbox;
>>>>> varSite = RecordsetSite
>>>>>
>>>>> if (varRecip) {
>>>>> print/echo ("'<a href='" &&
varSite && "'>" && varCompanyName &&
>>>>> "</a>");
>>>>> }
>>>>>
>>>>>
>>>>> "woodywyatt"
<woodywyatt@fuerteventura.com> wrote in message
>>>>>
news:e4i452$rng$1@forums.macromedia.com...
>>>>>> Is there a way to only display a
certain field from a recordset if
>>>>>> another seperate field is not empty?
Else nothing.
>>>>>>
>>>>>> Heres an example:
>>>>>> I have a database from which want to
display a clients url's
>>>>>>
>>>>>> If they don't have a reciprocal link
then without our ok their
>>>>>> website link won't appear - if at a
later date they do put a
>>>>>> reciprocal link then all we'd have
to do would be to check the
>>>>>> reciprocal link box and their
weblink will show.
>>>>>>
>>>>>> Hope I'm making sense!
>>>>>> Thanks
>>>>>> Gary
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
8
Replies
AdChoices