I'm trying to create a personalized mailer where recommended products will be pitched to each customer.
I'm getting error - An unrecognized expression appears in a script block. Script Expression: Testing_database_lead_journey:AESL_Class_LK__c
Below is the ampscript code I'm using -
code for setting variables
%%[
var @currentClassCode
var @stream
var @courseDetailsRows
var @courseDetailsRow1
var @courseDetailsRow2
var @title1
var @title2
var @Line1_1
var @Line1_2
var @Line2_1
var @Line2_2
var @Line3_1
var @Line3_2
var @Link1
var @Link2
var @Number1_1
var @Number1_2
var @Number2_1
var @Number2_2
set @currentClassCode = Testing_database_lead_journey:AESL_Class_LK__c
set @stream = Testing_database_lead_journey:AESL_Stream__c
set @courseDetailsRows = LookupOrderedRows('DigitalJourneyCourseDetails', 2, 'Priority ASC', 'ClassCode', @currentClassCode, 'Stream', @stream, 'Product', 'ICON')
if RowCount(@courseDetailsRows) > 0 then
set @courseDetailsRow1 = Row(@courseDetailsRows, 1)
set @Description1 = Field(@courseDetailsRow1, 'Description')
set @title1 = Field(@courseDetailsRow1, 'Title')
set @Line1_1 = Field(@courseDetailsRow1, 'Line1')
set @Line2_1 = Field(@courseDetailsRow1, 'Line2')
set @Line3_1 = Field(@courseDetailsRow1, 'Line3')
set @Link1 = Field(@courseDetailsRow1, 'Link')
set @Number1_1 = Field(@courseDetailsRow1, 'TollFreeNumber1')
set @Number1_1 = Field(@courseDetailsRow1, 'TollFreeNumber2')
if RowCount(@courseDetailsRows) > 1 then
set @courseDetailsRow2 = Row(@courseDetailsRows, 2)
set @Description2 = Field(@courseDetailsRow2, 'Description')
set @title2 = Field(@courseDetailsRow2, 'Title')
set @Line1_2 = Field(@courseDetailsRow2, 'Line1')
set @Line2_2 = Field(@courseDetailsRow2, 'Line2')
set @Line3_2 = Field(@courseDetailsRow2, 'Line3')
set @Link2 = Field(@courseDetailsRow2, 'Link')
set @Number2_1 = Field(@courseDetailsRow2, 'TollFreeNumber1')
set @Number2_1 = Field(@courseDetailsRow2, 'TollFreeNumber2')
endif
endif
]%%
Code for printing out recommended products in email
%%[ if not Empty(@title1) then ]%%Course name:%%= v(@title1) =%%%%[ endif ]%%
%%[ if not Empty(@Line1_1) then ]%%Course details:%%= v(@Line1_1) =%%%%[ endif ]%%
%%[ if not Empty(@Line2_1) then ]%%%%= v(@Line2_1) =%%%%[ endif ]%%
%%[ if not Empty(@Line3_1) then ]%%%%= v(@Line3_1) =%%%%[ endif ]%%
Please suggest how do I fix this.
Testing_database_lead_journey:AESL_Class_LK__c
andTesting_database_lead_journey:AESL_Stream__c
columns in your send context?