Hi all! I'm a bit stuck with DMX and populating a recordset. I have a database of car parts (spark plugs), when entering one part number I need the recordset to identify equivalent parts based on details for the original part (which are contained within the same databe table - e.g. thread size, spanner size etc).

A friend built an application for me some years ago, which does the job, but I am trying to rebuild the page as I need to expand the facility to include some additional features. He was a Visual Basic programmer but has changed career since then so no help there, I cannot write in VBS but can understand and modify code, I've built a number of dynamic lookup applications using DMX so am not a complete beginner.

I guess what I'm looking for is some help with the SQL statement to identify the equivalent part. I can identify the correct table row using a filter and form variable, I can then pass this to the next page but I can't see how to specify and display the equivalent parts in the SQL. I can post a link to the existing page to demo what it should do if I haven't explained it very well.

Thanks in advance for any help - I've basically been staring at the screen for about 4 hours now <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

Cheers.
RobH

Sorry, should have included I'm using DMX 2004, ASP VBS.

Thanks and regards,

RobH

I'm not sure what your question is but It seems you want to do some cross merchandizing, right. For example, when you go to the drugstore looking for a shampoo, you will also find in the same aisle hair, curlers, pony tails, and other hair products that can be associated with hair care.

Is that what you want to do? and can you show how far you have gone? put your demo up and let people see where they can give their input. Cheers.

J.

Hi and thanks for the reply, I'm trying to offer customers an alternative part made by a different manufacturer or a part with the same dimensions but made to a higher quality or using better materials - simply so they have a choice. For instance if I have a table

Make partnumber threaddiameter threadreach
NGK B7ES 14mm 19mm
Denso W22ESU 14mm 19mm
Denso W20FSU 14mm 12.5mm
Champion N4C 14mm 19mm

I want to be able to enter part number N4C as a form variable and in my recordset, show all the other plugs that have the same dimensions (i.e. Denso W22ESU and NGK B7ES). I can't really put up demos of the pages I'm working on without a huge amount of work (I'm not good at this) but the 'live' page I'm trying to rebuild is currently available at www.sparkplugs.co.uk/pages/database/altresults.asp. Enter a part number such as one of those above and the xref button will pass you to a disclaimer which will then pass you to the alternative results page - this is the page I'm trying to rebuild.

Hope someone can help <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Best regards,
RobH

Hi Rob,

Can you post the sql query you have?

Hi, thanks for your concern Javier, I've actually resolved the issue now - it's probably quite easy for someone who knows what they're doing (not me unfortunately!). I built a second recordset which referenced the results in the first recordset.

Cheers

RobH