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: [EMAIL PROTECTED] >Web: www.frs.fo ______________________________________________ [EMAIL PROTECTED] mailing list https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
