Kapalı

half dozen lines of SQL or access query for Volusion

The following is the standard Volusion google export script with 3 comments in it.

The first 2 I don't know how to conditionally replace what I want.

The third needs the field to be referenced correctly.

TIA!

SELECT

'[login to view URL] =' + [login to view URL] + '&click=35' AS link

, [login to view URL] AS title

, [login to view URL] AS [stripHTML-description]

, 'Config_FullStoreURLConfig_ProductPhotosFolder/' + [login to view URL] + '[login to view URL]' AS image_link

-- if [CategoryTree-product_type] ="MOTORCYCLE" then image_link = PhotoURL_Small

, [login to view URL] AS [CategoryTree-product_type]

-- if [CategoryTree-product_type] ="MOTORCYCLE" then [login to view URL] = CustomField5

-- METATAG_Keywords as label

, IsNull([login to view URL],[login to view URL]) AS price

, [login to view URL] AS id

FROM Products p

INNER JOIN Products_Descriptions pd ON [login to view URL] = [login to view URL]

INNER JOIN Products_Extended pe ON [login to view URL] = [login to view URL]

WHERE ([login to view URL] is NULL OR [login to view URL] = '')

AND ([login to view URL] is NULL OR [login to view URL] 'Y')

AND ([login to view URL] > 0)

ORDER BY [login to view URL]

Edit/Delete Message

Beceriler: Betik Yükleme

Daha fazlasını gör: volusion sql script, categorytree volusion, sql price, ischildofproductcode volusion, volusion database access, what is volusion, t-sql with, t-sql in, p sql, on sql, tia, t-sql;, sql script , or, null, motorcycle, motorcycle t, inner, access delete, google query, access order, link sql, sql google script, volusion export sql, click link description

İşveren Hakkında:
( 0 değerlendirme ) Saddle Brook, United States

Proje NO: #83493