G.W.Green
28-Oct-2011, 08:54 AM
The variable names for the extended information page tick boxes have been changed, due to the introduction of the Single Product per Page feature, and therefore the links to the extended information pages are no longer enabled if you had these enabled before.
To tick "Links from Product Page" | "Text Link to Extended Information Page" for all products:
UPDATE Product SET bSPPDisplayExtInfoByLink = -1
To change the text of "Links from Product Page" | "Link Text" for all products:
UPDATE Product SET sSPPDisplayExtInfoByLinkTxt = "More info…"
To tick "Links from Product Page" | "Extended Info Button Link to Extended Information Page" for all products:
UPDATE Product SET bSPPDisplayExtInfoByBtn = -1
To tick "Links from Product Page" | "Product Image Link to Extended Information Page" for all products:
UPDATE Product SET bSPPDisplayExtInfoByImage = -1
To tick "Text Link" | "Displays the Extended Information Page" option:
UPDATE Product SET nDisplayByLink = 2
To set the new value of the "Text Link" | "Link Text" edit box:
UPDATE Product SET sProductListLinkText = "new text"
To untick any of the options listed above, replace -1 with 0 in the related SQL.
How to run one of these SQL scripts.
To run an SQL query into the Actinic database you will need to follow these instructions. You will need Access 2000 or above in order to run a query in your Actinic database.
First make a backup of your site (File | Snapshot | Export Site)
Also make a backup of your “Site1” folder, or the folder of the site you are currently using.
Close down Actinic.
Open Windows Explorer
Browse to: C:\Program Files\Actinic v11\Sites\Site1 (Or the location of the “Site1” folder you are using)
Open up “ActinicCatalog.mdb” in Access.
Go to 'View | Database Objects | Queries
Click 'New'
Select 'Design' view
Click 'close' on the 'Show Table' window
Then go to 'View | SQL view'
Copy and paste the SQL statement from above into the page, replacing “SELECT;” if that is already in the page:
To run the query, go to 'Query | Run'
Now close the SQL query Window
Close the Access Database
To tick "Links from Product Page" | "Text Link to Extended Information Page" for all products:
UPDATE Product SET bSPPDisplayExtInfoByLink = -1
To change the text of "Links from Product Page" | "Link Text" for all products:
UPDATE Product SET sSPPDisplayExtInfoByLinkTxt = "More info…"
To tick "Links from Product Page" | "Extended Info Button Link to Extended Information Page" for all products:
UPDATE Product SET bSPPDisplayExtInfoByBtn = -1
To tick "Links from Product Page" | "Product Image Link to Extended Information Page" for all products:
UPDATE Product SET bSPPDisplayExtInfoByImage = -1
To tick "Text Link" | "Displays the Extended Information Page" option:
UPDATE Product SET nDisplayByLink = 2
To set the new value of the "Text Link" | "Link Text" edit box:
UPDATE Product SET sProductListLinkText = "new text"
To untick any of the options listed above, replace -1 with 0 in the related SQL.
How to run one of these SQL scripts.
To run an SQL query into the Actinic database you will need to follow these instructions. You will need Access 2000 or above in order to run a query in your Actinic database.
First make a backup of your site (File | Snapshot | Export Site)
Also make a backup of your “Site1” folder, or the folder of the site you are currently using.
Close down Actinic.
Open Windows Explorer
Browse to: C:\Program Files\Actinic v11\Sites\Site1 (Or the location of the “Site1” folder you are using)
Open up “ActinicCatalog.mdb” in Access.
Go to 'View | Database Objects | Queries
Click 'New'
Select 'Design' view
Click 'close' on the 'Show Table' window
Then go to 'View | SQL view'
Copy and paste the SQL statement from above into the page, replacing “SELECT;” if that is already in the page:
To run the query, go to 'Query | Run'
Now close the SQL query Window
Close the Access Database