2

I am getting an error for Failed to convert parameter value from a String to a Int32

Code :

var @temp
set @temp = "-536885345"

set @rows = LookupOrderedRows("data",1,"date Desc","oid",@temp))

here "oid" field is defined as "Number" in my "data" data extension

on execution getting the below error : Getting an error Failed to convert parameter value from a String to a Int32.

Please help me in fixing this issue.

  • 1
    I'm not familiar with ampScript, but shouldn't set @temp = "-536885345" be without double quotes if it's a number ? – Samuel De Rycke Feb 20 '15 at 8:44
  • Make sure to mark the answer as correct if it worked for you. – Kelly J Andrews Feb 20 '15 at 19:26
0

You are passing a string into a number field. Remove the quotes to make it a number.

var @temp 
set @temp = -536885345
set @rows = LookupOrderedRows("data",1,"date Desc","oid",@temp))`
| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.