Syntax problem - please help

[SkyHigh]

Hi Folks

There is something wrong in the 2nd last line because of which the insert statement is not coming out right, can someone please help me
Thanks

my $SQL_Insert ="INSERT INTO summary VALUES ('" .
$LastDayOfMonth . "', " .
$summrow{'id'} . ',' .
$summrow{'alimit'} . ',' .
$summrow{'mlimit'} . ',' .
$summrow{'threshold'} . ',' .
"NEXTVAL('_seq_summary_'),' .
$summrow{'ttsls'})";

 

[audiopro]

"NEXTVAL('_seq_summary_'),' .

check the speech mark inbalance.

Keith

http://www.studiosoft.co.uk

 

[audiopro]

Sorry - They all match on second look. Just didn't appear right.

Keith

http://www.studiosoft.co.uk

 

[audiopro]

Shouldn't $NEXTVAL() be quoted as a single item?

Keith

http://www.studiosoft.co.uk

 

[SkyHigh]

This is how it shows up in the error logs of the database if it helps you guys to help me
Thanks


,NEXTVAL('_seq_monthly_invoice_no_'),' .
0)
From backend> E
From backend> "ERROR: parser: unterminated quoted string at or near "' .
0)" at character 168

 

[chazoid]

I'm really not sure, but maybe change the last to lines to this?

"NEXTVAL('_seq_summary_')".','.
$summrow{'ttsls'});

 

[audiopro]

The line is expecting your NEXTVAL var to be fully quoted as in the code sent by chazoid. Your original code quotes the NEXTVAL var and the last var together.

Keith

http://www.studiosoft.co.uk