Custom Variables

[Michael Parker]

When you set up custom variables for products, can anyone tell me which access table the informaiton is held in please?

It's much easier to update the info in Access.

Thanks

[pinbrook_nick]

HTMLVariables :cool:

[Michael Parker]

Thanks for that... but where are the actual variables for each product and section.

I have about 300 to go through and its easier to do it in the Access table format than it is pulling up each product individually in Actinic.

[Jan]

They are stored in productproperties,

sProductRef is the product ref for the appropriate product (NULL or blank for sections)

nSectionID is the appropriate section id

nType is 3

nValue1 is the cross reference to the variable id from HTML variables

nString1 is the value.


Obvious eh ;=)

Regards,

[Michael Parker]

Thanks very much.

I'll make a cup of tea and take a look!