I've just started my first site using DMX Dynamic Data, and I've come accross my first hurdle and really need some help.

The following link should give you some idea of what I'm trying to acheve.

www.antibrandcorporation.com/vinylstore/electronica.asp

Basically I have a database which stores links to real audio files (there is other data too but that not the problrm).

For each record in the Database there are four fields, in these fields are links to the real audio files.

If you look at the attached link you'll see that there are links to the audio files in the right hand side of the table.

I want to link my audio files to a number which is displayed only if the field has data. How would I do this?


Thanks

Carl Wicker
Creative Director
Anti Brand Corporation

lets assume that the fileds that house your RA file path are named RA1, RA2, RA3 and RA4...I'll write the code for RA1...the rest will be the same


<%
If rsMyRecordset.Fields.Item("RA1".Value <> Null then
Response.Write rsMyRecordset.Fields.Item("RA1".Value
End If
%>

The question was a little vague, so I'm not sure this is the answer to what you're asking...if you need something different or something more, let me know.

Doc
Rangewalk Digital Studios

Edited by - on 16 Jan 2003 06:37:27