How to put in a multi-line string without quotes on each line?

[dean]

sSQL =
" update SELECTED_NODES "
" set LABEL_S = 'Y' "
" where NODE_I in "
" ( "
" select NODE_I "
" from "
" ( "
" select ONODE_I NODE_I from link "
" union all "
" select DNODE_I NODE_I from link "
" ) ALL_NODES "
" group by NODE_I "
" having count(*) > 2 "
" ) ";

Is there a super-quote I can add at the start of that statement, so I
don't need all the double quotes on each line? Something like /* and */
but for strings and not comments.

Thanks!

Dean

[Dennis Jones]

"dean" <de*********@ya hoo.com> wrote in message
news:11******** **************@ i39g2000cwa.goo glegroups.com.. .

sSQL =
" update SELECTED_NODES "
" set LABEL_S = 'Y' "
" where NODE_I in "
" ( "
" select NODE_I "
" from "
" ( "
" select ONODE_I NODE_I from link "
" union all "
" select DNODE_I NODE_I from link "
" ) ALL_NODES "
" group by NODE_I "
" having count(*) > 2 "
" ) ";

Is there a super-quote I can add at the start of that statement, so I
don't need all the double quotes on each line? Something like /* and */
but for strings and not comments.

No.

- Dennis

[Jerry Coffin]

In article <1149348708.643 640.258530
@i39g2000cwa.go oglegroups.com> , de*********@yah oo.com
says...

sSQL =
" update SELECTED_NODES "
" set LABEL_S = 'Y' "
" where NODE_I in "
" ( "
" select NODE_I "
" from "
" ( "
" select ONODE_I NODE_I from link "
" union all "
" select DNODE_I NODE_I from link "
" ) ALL_NODES "
" group by NODE_I "
" having count(*) > 2 "
" ) ";

Is there a super-quote I can add at the start of that statement, so I
don't need all the double quotes on each line? Something like /* and */
but for strings and not comments.

I'm not sure it's any improvement in readability, but you
can do something like this:

sSQL = "\
update SELECTED_NODES \
set LABEL_S = 'Y' \
where NODE_I in \
( \
select NODE_I \
from \
( \
select ONODE_I NODE_I from link \
union all \
select DNODE_I NODE_I from link \
) all NODES \
group by NODE_I \
having count(*) > 2 \
)";

This can lead to problems though -- in particular,
inserting white-space between the back-slash and the new-
line can cause a bit of a problem.

My advice would be to read the query in from an external
file instead.

--
Later,
Jerry.

The universe is a figment of its own imagination.

[Larry I Smith]

dean wrote:

sSQL =
" update SELECTED_NODES "
" set LABEL_S = 'Y' "
" where NODE_I in "
" ( "
" select NODE_I "
" from "
" ( "
" select ONODE_I NODE_I from link "
" union all "
" select DNODE_I NODE_I from link "
" ) ALL_NODES "
" group by NODE_I "
" having count(*) > 2 "
" ) ";

Is there a super-quote I can add at the start of that statement, so I
don't need all the double quotes on each line? Something like /* and */
but for strings and not comments.

Thanks!

Dean

This topic may be compiler dependent, I don't know...

The best I could do without getting compile errors was:

const char * sqla =
"update SELECTED_NODES \
set LABEL_S = 'Y' \
where NODE_I in \
( \
select NODE_I \
from \
( \
select ONODE_I NODE_I from link \
union all \
select DNODE_I NODE_I from link \
) ALL_NODES \
group by NODE_I \
having count(*) > 2 \
)" ;

All the above example does is eliminate the leading quote on each
line, but you still must have the trailing backslash on every
line but the last. Also, the final string contains ALL of the blanks
that appear at the beginning of each line.

I'd stay with your original approach; it's easier to read and puts
fewer blanks in the string.

Larry

[benben]

dean wrote:

sSQL =
" update SELECTED_NODES "
" set LABEL_S = 'Y' "
" where NODE_I in "
" ( "
" select NODE_I "
" from "
" ( "
" select ONODE_I NODE_I from link "
" union all "
" select DNODE_I NODE_I from link "
" ) ALL_NODES "
" group by NODE_I "
" having count(*) > 2 "
" ) ";

Is there a super-quote I can add at the start of that statement, so I
don't need all the double quotes on each line? Something like /* and */
but for strings and not comments.

Thanks!

Dean

Put it in a file and read it at run time.

Ben

[Phlip]

dean wrote:

sSQL =
" update SELECTED_NODES "
" set LABEL_S = 'Y' "
" where NODE_I in "
" ( "
" select NODE_I "
" from "
" ( "
" select ONODE_I NODE_I from link "
" union all "
" select DNODE_I NODE_I from link "
" ) ALL_NODES "
" group by NODE_I "
" having count(*) > 2 "
" ) ";

Is there a super-quote I can add at the start of that statement, so I
don't need all the double quotes on each line? Something like /* and */
but for strings and not comments.

That pattern is called PerniciousIngro wnSql. You are asking how to make the
SQL easier to in-grow.

Instead, consider writing a simple system that generates SQL with streams,
like this:

stringstream q;
update(q, selectedNodesTa ble);
q << "set LABEL_S = 'Y'";
q << "where NODE_I in "
selectNode_I(q) ;

I pushed some of your strings into simple functions. As you write more SQL,
you will re-use these simple functions. If your program grows very complex,
that suite of simple functions will start to work as a "persistenc e layer".

But if you program does not grow complex (a good thing), then they won't.
They will just keep helping you write SQL statements that don't duplicate
all their contents everywhere.

--
Phlip
http://c2.com/cgi/wiki?ZeekLand <-- NOT a blog!!!