Redirect component causes an Error with INSERT statement ON CONFLICT #211
Answered
by
chris-bragg-sift
chris-bragg-sift
asked this question in
Q&A
-
insert into new_contacts(
email,
....
) values (
$email,
....
)
ON CONFLICT (email) DO UPDATE
SET
email = EXCLUDED.email,
.....
RETURNING
'redirect' AS component,
'docompanysearch.sql?company_id=' || $company_id AS link; Gives me...
Not sure what I am doing wrong. The url shows the correct argument /docompanysearch.sql?company_id=company_id |
Beta Was this translation helpful? Give feedback.
Answered by
chris-bragg-sift
Jan 31, 2024
Replies: 1 comment
-
My bad worked it out... the url arg /docompanysearch.sql?company_id=company_id |
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
lovasoa
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
My bad worked it out... the url arg /docompanysearch.sql?company_id=company_id
should have been /docompanysearch.sql?companydomain=company_id so it was the page i was redirecting too (which also has a redirect) erroring.