topic Re: Invalid column name error when passing Name parameter in Application Development and Automation Discussions

Invalid column name error when passing Name parameter

amber — Thu, 22 Feb 2024 09:09:40 GMT

HI I am trying to pass parameter first_name and when i pass in query and create parameter then this shows error

this is the query which used

and this is the error i receive

whereas when i use this query for Customer_ID parameter this works but not works with Name.. where is the mistake? why not working with Name

Re: Invalid column name error when passing Name parameter

JWiseman — Thu, 22 Feb 2024 17:04:06 GMT

Hi Amber, in the Command query WHERE clause try putting the First_Name@ prompt in single quotes. Otherwise it's assumed that the first name parameter value is a field name.

i.e. cs.First_Name = '{?First_Name@}'

Re: Invalid column name error when passing Name parameter

amber — Fri, 23 Feb 2024 04:58:14 GMT

Thanku so much . It works 🙂