1. Home
  2. Point-Of-Sale Software
  3. Drilldown.htm - my products aren't made by my Nan!

Drilldown.htm - my products aren't made by my Nan!

Hi there, some more issues for you to solve for me!

Basically, I am looking at using drilldown.htm as an alternative (and slightly nicer) way of browsing through our products. However, having it display the item picture and description is pretty useless as a) I haven't got any item pictures in the database and b) a lot of my descriptions are longer than the description field allows.

So, what I want to do is modify the drilldown.htm cells so that they show subdescription1 (the manufacturer) and the Extended description. I can get it to show the extended description fine, but where it should show a manufacturer's name, in every cell it has NaN instead. Now, while I'm sure many of our products may be made by someone's grandmother in the factory, it is not very helpful when trying to find a product.

One other things if I load the Subdescription1 from the SQL query into the extendeddescription variable in drilldown.htm, it will show it fine, so I know it is getting it out of the database OK

Cheers

Reply to
Mheill
Loading thread data ...

Just playing around a bit more with it, if I ask it to just show the subdescription field it just returns the text as "undefined". How should it be defined in the script?

Reply to
Mheill

OK everyone, problem solved. I just assigned the Subdescription1 to the description variable already in the script, and displayed that instead. I still don't know why it thought all my products were made by "NaN", but I've got round it.

Cheers for the help you probably would have given me had I not solved the problem before anyone got a chance

Reply to
Mheill

NaN is a javascript error for "Not a Number", meaning you were probably trying to manipulate some text in a numeric context.

- Evan Culver New West Technologies

Reply to
Evan Culver

Hi Evan,

I thought it might be something along those lines, but I couldn't find anywhere where I was trying to do something that would be wrong.

Anyway, having got it to work on my back office PC, I transferred it onto my POS PC, and now have a new problem - Internet Explorer will not allow me to run Active X controls inside the POS window. I can't find anything in the security settings to change this - how would I do this?

Cheers

Evan Culver wrote:

Reply to
Mheill

in internet explorer, Tools, Internet Options, Security

Add the location of the file you are browsing to the trusted sites list.

should then allow you to run active-x controls.

Jamieson Gill

formatting link

Reply to
j

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.