Hi People,

I have a really odd problem with a recordet using MX. Here's my setup, basically I have built a search page and a results page for second hand cars, my database in SQL server and my search results are pulling from a query. The query runs fine when I test it (in the recordset test area in DW MX) and it tests fine on SQL enterprise manager.

However here is the problem I'm having; The page is quite simple, just records being shown in a repeat region behaviour. The problem I seem to have is that most of the fields from my recordset displayed, show fine, however when I add say a few random fields (that I need, that are from the same recordset) i.e. location, MOT etc, certain fields (in this case price) then disappear!!?? I have tried mixing and matching fields and it still seems that when I add a certain combination i.e if I include car_location, price will then not display. Also if I add various other field items, such as a TAX, price will then also disappear, but when I add other fields such as seller_type it shows again!?

As I mentioned the query is pulling the information fine, I just can't figure out why its then not showing certain fields when I display them in a certain combination.

Has anyone had this problem before, or got any ideas what's going on? As i'm really baffled on this one and its driving me crazy as I just can't figure it out.

Any help or information would be massively appreciated !

Kind regards

Jon

Edited by - Jonny5uk on 05 Sep 2003 10:25:23

u had any problems with other parts of u dm Package?... sounds like maybe you have instllation problems .. <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>