How to access a category name and code from vbscript

Aug 03, 2005 1 Replies

I am modifying the lineitem.html for the status bar in Store operation. I want to ask how can i access the category name and code for each item, i only can find a categoryid function, which is in the TransactionEntry.Item.CategoryID, but can not access the name and code for the category



Raemond,

You will need to retrieve the name and code via SQL using the ID:

resultSet=QSRules.OpenRecordset("SELECT Name, Code FROM Category WHERE ID=" & TransactionEntry.Item.CategoryID, true)

- Evan Culver New West Technologies

Raem> I am modifying the lineitem.html for the status bar in Store operation. I

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required