here-doc not working? 2

[feherke]

Hi

The terminating string must appear by itself (unquoted and with no surrounding whitespace) on the terminating line.

    [b]my[/b] [navy]$sql[/navy] [teal]=[/teal] [teal]<<[/teal]ENDSQL[teal];[/teal]
ENDSQL
[gray]# ^-- no leading space[/gray]

[gray]# or[/gray]

[gray]#                  v-- same amount of spaces here ...[/gray]
    [b]my[/b] [navy]$sql[/navy] [teal]=[/teal] [teal]<<[/teal][green][i]'    ENDSQL'[/i][/green][teal];[/teal]
    ENDSQL
[gray]# ^-- ... and here[/gray]

Feherke.

http://free.rootshell.be/~feherke/

 

[1DMF]

Thanks Feherke,

1st time I've used it so I'm not suprised I had problems.

Makes code indenting a nightmare or as you say , I'll have to add the same amount of whitespace, however I can't use the quote as you have it as I read it won't interpolate if you do that.

so it's going to have to be ugly, bad practice, non-indented code!

-----------------------------------

Update -> still getting same error with...

    # build SQL    
    my $sql = <<ENDSQL;
        SELECT *
        FROM CASE_DETAILS 
        JOIN $mort_table ON CASE_DETAILS.CaseId = $mort_table.CaseId 
        JOIN ADVISER ON CASE_DETAILS.AdviserIndexId = ADVISER.IndexId 
        WHERE CASE_DETAILS.CaseId = $_[0]{'CaseId'} AND CASE_DETAILS.CompanyId = $_[0]{'CompanyId'}
ENDSQL

i made sure the last line had no whitespace on the end and the 'ENDSQL' is far left with no space or indentation, but still getting same error?

I gave up and used concatenation instead!

    # build SQL    
    my $sql = "SELECT * FROM CASE_DETAILS" .
        " JOIN $mort_table ON CASE_DETAILS.CaseId = $mort_table.CaseId" .
        " JOIN ADVISER ON CASE_DETAILS.AdviserIndexId = ADVISER.IndexId" .
        " WHERE CASE_DETAILS.CaseId = $_[0]{'CaseId'} AND CASE_DETAILS.CompanyId = $_[0]{'CompanyId'}"

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[1DMF]

damn, there was a trailing white space on the ENDSQL line i hadn't noticed.

bit anal the old here-doc isn't it!

Cheers Feherke!

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[feherke]

Hi

I can't use the quote as you have it as I read it won't interpolate if you do that.

Oops, missed that. Just use double quote ( " ) instead :

    [b]my[/b] [navy]$sql[/navy] [teal]=[/teal] [teal]<<[/teal][green][i]"    ENDSQL"[/i][/green][teal];[/teal]
    ENDSQL

Feherke.

http://free.rootshell.be/~feherke/

 

[feherke]

Hi

damn, there was a trailing white space on the ENDSQL line i hadn't noticed.

Oops. MCEdit highlighted them and I just removed them by reflex. Then forgot to mention it...


Feherke.

http://free.rootshell.be/~feherke/

 

[1DMF]

i was wondering if double quote was OK, but the info I found regarding here-doc just showed it not quoted or use single quote for no interpolation.

It's working fine now the trailing whitespace has been culled.

Thanks again Feherke, it makes the SQL code much more readable using this method.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts

 

[MillerH]

Using quotes around a heredoc is how you specify if it should be interpolated or not. By default heredoc's are interpolated so double quotes are assumed.

Most people don't necessarily know what is default though, so it's good practice to always use double quotes around your heredocs.

- Miller

 

[1DMF]

Thanks Miller - I shall cordially add them.

"In complete darkness we are all the same, only our knowledge and wisdom separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"

Google Rank Extractor -> Perl beta with FusionCharts