breaking code to several lines

Miro Karpis

23 Dec 2013 23 Dec '13

4:42 p.m.

Hi please,... I have one sql insert statement which is too long to be on one line. Is there a way that I can break it several lines? Or does it have to be everything in one line? here is the query: execute_ conn "INSERT INTO ttableXY (column1, column2, column3, column4, column5, column6, column7) VALUES ('var1', 'var2', 'var3', 'var4', 'var5', 'var6', 'var7')" Thanks, Miro

Attachments:

attachment.html (text/html — 539 bytes)

Show replies by date

Brandon Allbery

23 Dec 23 Dec

4:47 p.m.

On Mon, Dec 23, 2013 at 4:42 PM, Miro Karpis wrote:

...

Hi please,... I have one sql insert statement which is too long to be on one line. Is there a way that I can break it several lines? Or does it have to be everything in one line?

See "string gaps" in http://www.haskell.org/onlinereport/haskell2010/haskellch2.html#x7-200002.6 -- brandon s allbery kf8nh sine nomine associates allbery.b@gmail.com ballbery@sinenomine.net unix, openafs, kerberos, infrastructure, xmonad http://sinenomine.net

David McBride

4:57 p.m.

Another option is a string quasiquoter. There are several options available, non interpolating ones ones such as string-qq or string-quote, as well as ones that allow you to interpolate variables, like interpolatedstring-qq. On Mon, Dec 23, 2013 at 4:42 PM, Miro Karpis wrote:

...

Hi please,... I have one sql insert statement which is too long to be on one line. Is there a way that I can break it several lines? Or does it have to be everything in one line?

here is the query: execute_ conn "INSERT INTO ttableXY (column1, column2, column3, column4, column5, column6, column7) VALUES ('var1', 'var2', 'var3', 'var4', 'var5', 'var6', 'var7')"

Thanks, Miro

_______________________________________________ Beginners mailing list Beginners@haskell.org http://www.haskell.org/mailman/listinfo/beginners

Miro Karpis

5:05 p.m.

thank you very much m. On Mon, Dec 23, 2013 at 10:57 PM, David McBride wrote:

...

Another option is a string quasiquoter. There are several options available, non interpolating ones ones such as string-qq or string-quote, as well as ones that allow you to interpolate variables, like interpolatedstring-qq.

On Mon, Dec 23, 2013 at 4:42 PM, Miro Karpis wrote:

...
Hi please,... I have one sql insert statement which is too long to be on one line. Is there a way that I can break it several lines? Or does it have to be everything in one line?

here is the query: execute_ conn "INSERT INTO ttableXY (column1, column2, column3, column4, column5, column6, column7) VALUES ('var1', 'var2', 'var3', 'var4', 'var5', 'var6', 'var7')"

Thanks, Miro

_______________________________________________ Beginners mailing list Beginners@haskell.org http://www.haskell.org/mailman/listinfo/beginners

Gesh hseG

29 Jan 29 Jan

2:34 p.m.

...

On Mon, Dec 23, 2013 at 4:42 PM, Miro Karpis wrote:

...
...
Hi please,... I have one sql insert statement which is too long to be on one line. Is there a way that I can break it several lines? Or does it have to be everything in one line?

here is the query: execute_ conn "INSERT INTO ttableXY (column1, column2, column3, column4, column5, column6, column7) VALUES ('var1', 'var2', 'var3', 'var4', 'var5', 'var6', 'var7')"

Thanks, Miro

In addition, you could break the string into two strings and append them.

That is, execute_conn $ "INSERT INTO ttableXY (column1, column2, column3, column4, column5, column6, column7) " ++ "VALUES ('var1', 'var2', 'var3', 'var4', 'var5', 'var6', 'var7')" HTH, Gesh

4128

Age (days ago)

4165

Last active (days ago)

List overview

Download

4 comments

4 participants

participants (4)

Brandon Allbery
David McBride
Gesh hseG
Miro Karpis