Re: Fresh eyeballs needed: input into error

On 4/26/22 2:31 PM, Rich Shepard wrote:
> I'm getting a syntax error with an input into statement and I cannot see
> the
> cause.
>
> A MWE and the result (N.B.: line one wrapped for readability; it ends with
> 'values'):
> insert into people (person_nbr,lname,fname,job_title,company_nbr,loc_nbr,
> loc_phone_ext,direct_phone,direct_fax,cell_phone,email,active,comment)
> values (6000,'No','Name',null,404,1,null,null,null,null,null,null,null);
>
> 2: ERROR:  syntax error at end of input
> LINE 2: (
>          ^
> What do I keep missing?

I'm guessing some sort of hidden character.

What client are you using to run this?

Where is the query string coming from?

>
> TIA,
>
> Rich
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com