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

'[url removed, login to view] =' + [url removed, login to view] + '&click=35' AS link

, [url removed, login to view] AS title

, [url removed, login to view] AS [stripHTML-description]

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

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

, [url removed, login to view] AS [CategoryTree-product_type]

-- if [CategoryTree-product_type] ="MOTORCYCLE" then [url removed, login to view] = CustomField5

-- METATAG_Keywords as label

, IsNull([url removed, login to view],[url removed, login to view]) AS price

, [url removed, login to view] AS id

FROM Products p

INNER JOIN Products_Descriptions pd ON [url removed, login to view] = [url removed, login to view]

INNER JOIN Products_Extended pe ON [url removed, login to view] = [url removed, login to view]

WHERE ([url removed, login to view] is NULL OR [url removed, login to view] = '')

AND ([url removed, login to view] is NULL OR [url removed, login to view] 'Y')

AND ([url removed, login to view] > 0)

ORDER BY [url removed, login to view]

Edit/Delete Message

Beceriler: Betik Yükleme

Daha fazlasını görün: volusion sql script, categorytree volusion, sql price, volusion database access, p sql, on sql, tia, 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, sql select order, sql select, volusion query, amp access, amp sql

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

Proje NO: #83493