OK. We are debugging the xql files and I have hit a brick wall in
relation to a function that attempts to insert some info into a table.
I am getting an error that doesnt really tell me what to look at.
The error message is that:
Error: Ns_PgExec: result status: 7 message: ERROR: parser: parse
error at or near "$1"
Now best as I can see, after ocuntless hours trying to debug, I am
fairly sure that the problem is in the following section of code,
which lies in a function.
insert into cr_wp_presentations
(
presentation_id,
pres_title,
page_signature,
copyright_notice,
style,
public_p,
show_modified_p
) values (
v_revision_id,
pres_title,
page_signature,
copyright_notice,
style,
public_p,
show_modified_p
);
I have tried doing this section within an ''execute'' command. But
this doesnt work either.
I was hoping someone might have come across this problem already?
Thanks alot
Jack