product detail not being shown

Hey Ray

further to our premier ticket on Friday, I have added all the RS's, built the options etc and tested it at each stage and in the main it worked fine, but got all the way to the end and now the page doesnt display any content....

I have tried retracing/undoing my steps to rectify but nothing is doing any good :(

Details and file in the PM

When I did have it working fine, I noticed that the cart only displayed the options from the first item added (eg if you added left and then went to add right options then only the left would show)

Cheers

Jamie

I'm probably going to have to debug this with you in a screen sharing session.

as ever your support is legendary - thanks for helping me debug the page!

on the same page, am trying to order one of the drop down lists from +ive values down to -ive values.

The +ives are grouped together and the -ive are grouped together but neither are in order. How would I get the list to descend from top to bottom? have tried ORDER BY PowerValue ASC (and DESC) as well as not using the ORDER BY but just not getting it right.

EDIT. also, how to gethe 0.00 value to sit in between the +ive and -ive values

Have linked to a test page and attached the file as well.

cheers

Jamie

Try using:

ORDER BY
CAST(PowerValue as DECIMAL(4,2))

thats great, thanks Ray

is the (4,2) a fraction to decimal converting number of decimal points to 2?

Yes it is the field data size with the maximum number of characters before and after the decimal.

many thanks mate