.asp coding help!

[b3nje]

Hi all,

If you look at this link

http://www.lease360.com/offers2.asp?v=car&id=77

It brings these details through twice;

Registration Fee
Delivery
Twelve Months Road Tax
Concert single CD player with MP3 facility
Manual headlight levelling
Solid paint
4 spoke leather steering wheel with gear change controls
Metrik design fabric upholstery
Vavona bernstein inlay
17" 16 Spoke Alloy Wheels
Registration Fee
Delivery
Twelve Months Road Tax
Concert single CD player with MP3 facility
Manual headlight levelling
Solid paint
4 spoke leather steering wheel with gear change controls
Metrik design fabric upholstery
Vavona bernstein inlay
17" 16 Spoke Alloy Wheels


as you can see. I can't find where in the code it is going wrong!

Please help!

 

[b3nje]

If you look at any of the offers

http://www.lease360.com/offers.asp

it brings all the "DealerOptions" through twice.

 

[b3nje]

%= RenderAsList( objRS("FactoryOptions") ) %>
<%
If Trim( objRS("DealerOptions").Value ) <> "" Then
%>
<hr />
<%= RenderAsList( objRS( "DealerOptions" ) ) %>
<%
End If
%>

 

[bigmouk]

Do a count on your recordset to check there isnt 2 identical records.

Either that or that code is in the middle of a loop ?

Also, to cut down on code/lines, change to this i think (not used inline asp for a while) ..

<%
If Trim( objRS("DealerOptions").Value ) <> "" Then
Response.Write("<hr/>")
RenderAsList( objRS( "DealerOptions" ) )
End If
%>

 

[b3nje]

as of yet not found anything...i'll slap the full code on pastebin!

2secs!

 

[b3nje]

http://www.pastebin.co.uk/7075

 

[bigmouk]

<%= RenderAsList( objRS("FactoryOptions") ) %>

and

<%= RenderAsList( objRS( "DealerOptions" ) ) %>

... has to be the same data and that is why its duplicated on screen, that is the only explanation looking at your code. check what data you have directly in the database under the fields FactoryOptions and DealerOptions for a 'car', id '77' for example. i'm assumming these fields are comma delimited strings and you are parsing them with the RenderAsList function.