R help - Jun 2004 - Re: problem in long select from RODBC

Hallo!

You can protect the line break with a backslashes


sqlQuery(channel, "select dir, c \
 from firsthit3 \
 where dir LIKE \"%SCHULEN%\"")

Sincerely

Eryk

*********** REPLY SEPARATOR  ***********

On 16.06.2004 at 14:37 Luis Rideau Cruz wrote:
>Hi all
>
>I have a very long sql select.
>The problem is that (as selects have to be in one line) is so long that
>when I copy-paste from the text file there is a "sintax error" .I
have
>checked the select and it is working in SQL Plus but I believe the problem
>lies in the length of it.
>
>Can you help me?
>
>Thank you
>
>Luis Ridao Cruz
>Fiskiranns??knarstovan
>N??at??n 1
>P.O. Box 3051
>FR-110 T??rshavn
>Faroe Islands
>Phone:             +298 353900
>Phone(direct): +298 353912
>Mobile:             +298 580800
>Fax:                 +298 353901
>E-mail:              luisr at frs.fo
>Web:                www.frs.fo

On Wednesday 16 of June 2004 14:42, Wolski wrote:
> sqlQuery(channel, "select dir, c \
>  from firsthit3 \
>  where dir LIKE \"%SCHULEN%\"")
Another option is paste(). This works for me (selectedCities is a constant 
set outside of this function):

	getData <- function(var,condition,whatTotal="sum(vctcnt)") {
	    temp <- sqlQuery(pg,paste(
	        "select year, month, ori, ", whatTotal," as total",
	        "from victims where ori in ",selectedCities,
	        condition,
	        "group by year,month,ori",
	        "order by year,ori"))
		...
	}

and it is run like:

	data.youth    <- getData("murdyouth"," and offage <= 24
",
		whatTotal="sum(vctcnt*wtus)")

Have a nice day,

	Matej

-- 
Matej Cepl, http://www.ceplovi.cz/matej
GPG Finger: 89EF 4BC6 288A BF43 1BAB  25C3 E09F EF25 D964 84AC
138 Highland Ave. #10, Somerville, Ma 02143, (617) 623-1488
 
The state is the great fictitious entity by which everyone seeks
to live at the expense of everyone else.
      -- Frederick Bastiat