From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id kF6GF/YosWDAKAAAgWs5BA (envelope-from ) for ; Fri, 28 May 2021 19:31:34 +0200 Received: from aspmx1.migadu.com ([2001:41d0:8:6d80::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 4F4DE/YosWDmMQAAbx9fmQ (envelope-from ) for ; Fri, 28 May 2021 17:31:34 +0000 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id EA8DD146B1 for ; Fri, 28 May 2021 19:31:32 +0200 (CEST) Received: from localhost ([::1]:53368 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1lmgKZ-0004VN-4N for larch@yhetil.org; Fri, 28 May 2021 13:31:31 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:58534) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lmgJQ-0004UA-6l for emacs-orgmode@gnu.org; Fri, 28 May 2021 13:30:20 -0400 Received: from mx0b-00395d01.pphosted.com ([148.163.137.170]:35232) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1lmgJN-00051X-Qh for emacs-orgmode@gnu.org; Fri, 28 May 2021 13:30:19 -0400 Received: from pps.filterd (m0173174.ppops.net [127.0.0.1]) by mx0b-00395d01.pphosted.com (8.16.0.43/8.16.0.43) with SMTP id 14SHQtwi018827; Fri, 28 May 2021 10:30:13 -0700 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucsd.edu; h=from : to : cc : subject : date : message-id : references : in-reply-to : content-type : content-id : content-transfer-encoding : mime-version; s=campus; bh=zf7c77kv+QrhEIvW3bDrs6TL/rKy52jBKSY65wDoB0E=; b=c7nnkvD2RWR/HGXQcK3zdwSbiJfvO5zvn4GkuA46eBd6w+nukUfvybin9kdbX+8sU2Ox HjfNHXGIskjdHsP7Tui0BYuq03uAcaFyfFsZfXteiPhgsUJCROR3ksi1mWG5NnunjKbJ zhnGvs/pJpDKOgMe2DT0+LUZqTOcrxjmXcr5UTtvxP6GjAyISmj75W/cMUCO/gnmdjpt MawS8LEdMEAuPtcWd8Z7Lg4Fv7LMFXCMKTVgwvXuBV8/X3Ns3FVI/E17c57cuStoqHz4 9pQweopNYd0tZ13Hin9jvRI2bum5dbo1bqTEWaaBbjRCJMeb8nCkeOvR0hL8nz9DUjvB vw== Received: from secdlpezp05.ucsd.edu ([40.112.251.180]) by mx0b-00395d01.pphosted.com with ESMTP id 38u14dgpg6-1 (version=TLSv1.2 cipher=ECDHE-RSA-AES256-GCM-SHA384 bits=256 verify=NOT); Fri, 28 May 2021 10:30:13 -0700 ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=Nbn1lHMZ9RE7FxsmTXdaDH9HJoNF2GPBnswll4LHX3hF4KYewY+Ow19dxEYnPoWM/8tEiQFLQzpwLdFKhaAbaOEl9ohJmgIoI6+RHdX7CHs5sDOBxnR8E9FZbdahng7KAzgFfqB1rkXYLcP8FPnVPUx9ItwQRz/Hfgd8iDrjGNP5TkYUVbqzD0PoaTv0gMQFm7/qFDQfj8DRNECFNxdsyY/KSmxlIAJzQCZCJO5kCFQolBNXxdOhzN2joPnjryZAddRvFhEAXCBeo7VB91yFsRpo8CWQruSb9vvB7CtkHkBNhqzhJ6MPBneq49JgZVEaHnQoBPh5oovcOLujOjZ1uQ== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=zf7c77kv+QrhEIvW3bDrs6TL/rKy52jBKSY65wDoB0E=; b=QBOPvehAVbUB90t6O7+jWyWlECCsl4NQJZIv292s7Hlt2//uoCx/VsqJ63qjWCenVrRR/i2A+vtYujQGFHPhyeR1wq6MDFUrxNDlAO5vcVyQQYW31XTB+4Y9bf7feT3cYvY1L1rYcK3fdmgesAwHIpV7JfYIi8SZPf3jTHOFyg+/LE7iCoF3cv0CvoN7QexmirrqjEToaxVTnqb58aooDdl9YdWDK2v9ct8loZKsdQr6VEZOCiPDwBs+25+yFyNJMcuGMoNFjuvBrdLNSkTMkNdU6oQQSopcQWQpo2qq89OOR48jTKyjMg9lwMoK2ALM9R/rsDE8ZcwkyIBW4sPLiw== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=health.ucsd.edu; dmarc=pass action=none header.from=health.ucsd.edu; dkim=pass header.d=health.ucsd.edu; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ucsdhs.onmicrosoft.com; s=selector2-ucsdhs-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=zf7c77kv+QrhEIvW3bDrs6TL/rKy52jBKSY65wDoB0E=; b=o4VnwLKCSmY5Uc1Hq50XoQIYaKHeU8fNfKSd97ZMoXggmtnt7UKXt8zh8DsM5gzMdjaEBVjTMwBMa5HBWEfdGwYAz4Z8IgUFyNwjcD1ZGfG2/iEX10lJAhepGOORXlXRaub766Fo3Nh/h6+nvDgqmsm2+5DZvnQe7edfWXHsFXo= To: Roger Mason Subject: Re: Passing a variable into an R source block. Thread-Topic: Passing a variable into an R source block. Thread-Index: AQHXU+cbsTMVCtVlXEqs3ZEgVovOAw== Date: Fri, 28 May 2021 17:30:09 +0000 Message-ID: References: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [2600:1702:1021:b0:f182:3129:9e14:3f7e] x-ms-publictraffictype: Email x-ms-office365-filtering-correlation-id: 456e54c4-ee81-4b05-3dea-08d921fe3e37 x-ms-traffictypediagnostic: BY5PR19MB3141: x-microsoft-antispam-prvs: x-ms-oob-tlc-oobclassifiers: OLM:4303; x-ms-exchange-senderadcheck: 1 x-microsoft-antispam: BCL:0; x-microsoft-antispam-message-info: dyXBxwN1QupR7k4ZIcvR5u8//y+D61148QCddv/nfGPVpNgwPjNMBzew4OUjjYbp7y/uZsZPn14UXBkwehbjRgEScQysiqYI2aAHDuhyehwmbNh53kfRYWyw1W4AmHEpqL9413Yazm9Q85BWBx1Yt3TDUbaHWIQ4LFWIWRGrbX7cJr2ZazvL24d2uq1BeopaS+sdKJp2UGgD2CwXt5ql3mYQoNbeSldXvp/Kgs2HHdbIe35NgUuAxx4QqSBbs4BFR9SFvPwGgb0lSLr2P7MklVJqBgjDqK8w5OganhURH+ILZSDRGnmy9V1RPYAftaOnRsXg8DX9jU8hZHUUfeQTXvyX/btziO4f1B8tGggJ9TzW3XrV03nmFZRWYiATHISdU0/JeHs+FiUgC+19vUNdTS6W2pSsRUN/lKyl4JK+S6ACvlyKme4+wIqPq/K8OO4daI3hMZ0Cyoq52tbECM3E1vttISCHdvPqdlUSCXx+mO0EPa1kK1vQRaAP4icGLtbD88g+MztnUgOjyZSW2iursO+GUtg0kUaJ47wEo6X6NtBkv4uKbefu7oBTaU/3u5PqZUd1lpEB6PkuUyIbEGllyJUmlIw06WldJCmypmVtvobAcTkdmEppkqd32O9VWhJINzbEtISyurQH0btVogM/5ol7RXUP6+HkILKhILmyrk0= x-forefront-antispam-report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:BYAPR19MB2581.namprd19.prod.outlook.com; PTR:; CAT:NONE; SFS:(4636009)(346002)(376002)(396003)(136003)(39860400002)(366004)(53546011)(6506007)(33656002)(122000001)(83380400001)(75432002)(86362001)(6916009)(2906002)(8936002)(66556008)(38100700002)(2616005)(64756008)(71200400001)(4326008)(186003)(66446008)(66946007)(76116006)(6486002)(8676002)(4744005)(786003)(316002)(478600001)(6512007)(66476007)(5660300002)(45980500001); DIR:OUT; SFP:1102; x-ms-exchange-antispam-messagedata: =?us-ascii?Q?O1F16OFIB/i/R2aQnGbfkbyOZZF6v2u9WqXZeudn0U2tQdTZY97jF7S9XThz?= =?us-ascii?Q?n/8urvkgEhPKxmo9rG9XLDsFR+NY3u2EDG+c5T5tonS2ju4NxDdgijFcfZkf?= =?us-ascii?Q?uErB/1nLXYkS7K2buFepShmqIy3DfWcZToXamWNpm1CF8qe4NdndZ7Njg54p?= =?us-ascii?Q?/ZtyWr5xyYDhhZkGbAWZUjTklitwNJN0sHiEVDCnBohmFqqxUtfYzTrORsbG?= =?us-ascii?Q?HYyP1mlgVrNBNISX2tH5he3swmqFujigpP1XcM7p9bS8PkeG/uBw3xjXeEED?= =?us-ascii?Q?De3qGXNQbnjQrFvf/rxffCIp1iTOWbsd98C662Z7Rkd7aiG2QwBsQcRASzq2?= =?us-ascii?Q?0dz5e2lOJTFcSm9+BNN5O75BaY4WRhl+mmIEZrW6lspIPPpZMB83Rrucr1L4?= =?us-ascii?Q?B8begkJ8bDd3ZopPMOwpitL+2vjoJA/+X3CR13cl2ZCMSgXp3kXFSZBqU9ko?= =?us-ascii?Q?qQWaKaVzpnMIWbMXYc9CTJDhm4nM/p8jhvte42bOmrhOxtAfy4L0krZKqRqh?= =?us-ascii?Q?rAa8HQbEqL01aTApS1so0ZvpJ9ZtY40nezEMQyjQzNM64jpDvdMC1wON0Paq?= =?us-ascii?Q?Pb3NwRQJYmhVfqYmXX2BaPadWlpdXCPETM8q83aZUO04/4tr5fTyYibfC0fm?= =?us-ascii?Q?M0v+6oBRD3D+EWXk5XyeYyOqLggJu2hBOgkSK/YaEjbKNxyjP2A9Lx9preyc?= =?us-ascii?Q?Ru0HhrTrUzHy6T8DJidhiSEV1QN1vfPLLURoPtFF2HgjJ7fASW+LhqC0g3+/?= =?us-ascii?Q?nf0MEaCrE5jjT6hVw9hxaOQiUhVdm9f3zX11hOcThIZSG20bbxmAvnPkRe33?= =?us-ascii?Q?ax0fq3UcjRdC0Yg3FIhMzx0A6k6mTRbSWYOlzkaY2cfS1qlLZOBfnZThUjPf?= =?us-ascii?Q?EDKaibSnYvFaG6ktiiPJLMkazHGME0oof4dWgONZIaHDMfQrKPjLA7XkRWls?= =?us-ascii?Q?A+l40wuMG5b/PteYO3K6fdezEwOBRqE2NhAYwwxCDa9CLI9nx4dS+Za7YpbA?= =?us-ascii?Q?rsBwU4TGboOlgnw1v44ZIpJTC1SpPCqdpD1aiWiatgFB/RNzAq/idZiB4HLY?= =?us-ascii?Q?Y5goZjTivyMMRZ47rfemEQXc9ZbyX15qFZrFuRiBvvK88XP/kzq5F+yvplt6?= =?us-ascii?Q?T9cX8nksI3OdkS3yYV/bJTpqXgwuN2LzuJXBxLlI9RGZ85ADBC6PMhu3fgB5?= =?us-ascii?Q?WCsyh/ERuMFVufJR8ey9i7DGo3b+YxHAtrgoD6A66htqGkYG7yQAgnEe0jyG?= =?us-ascii?Q?EWrQ0OvMvyEQ0Oy/f8qy0jYV3BD+8CxJJr1X+SPG4dTaO70yIn5QRcHoO+1m?= =?us-ascii?Q?tmMkRWM5eBW1GechlUdwh+aDgICszguX7eEgm01AfdLCJjPlEfaUsYPl89sv?= =?us-ascii?Q?cNCkIBs2KcMXkklqfzVQQ8rtlNyN?= x-ms-exchange-transport-forked: True Content-Type: text/plain; charset="us-ascii" Content-ID: Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-OriginatorOrg: health.ucsd.edu X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: BYAPR19MB2581.namprd19.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 456e54c4-ee81-4b05-3dea-08d921fe3e37 X-MS-Exchange-CrossTenant-originalarrivaltime: 28 May 2021 17:30:09.7823 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: e470d736-e7f7-41a8-8eab-dad544b2b579 X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 0fel8n9ko1plXuVd+Urftq+7Px4LOdf1jeU6dLB+SBi29lv0DBR6cor+UeaHlq87SkEZU3fmpx2rnfR5IxS6Og== X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY5PR19MB3141 X-Proofpoint-ORIG-GUID: GsJXW2yFF8S_w-Or1bYQ0MbuEyYPgKWh X-Proofpoint-GUID: GsJXW2yFF8S_w-Or1bYQ0MbuEyYPgKWh X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:6.0.391, 18.0.761 definitions=2021-05-28_05:2021-05-27, 2021-05-28 signatures=0 X-Proofpoint-Spam-Details: rule=outbound_notspam policy=outbound score=0 priorityscore=1501 bulkscore=0 mlxlogscore=992 lowpriorityscore=0 malwarescore=0 adultscore=0 spamscore=0 impostorscore=0 phishscore=0 mlxscore=0 clxscore=1011 suspectscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.12.0-2104190000 definitions=main-2105280114 Received-SPF: pass client-ip=148.163.137.170; envelope-from=ccberry@health.ucsd.edu; helo=mx0b-00395d01.pphosted.com X-Spam_score_int: -19 X-Spam_score: -2.0 X-Spam_bar: -- X-Spam_report: (-2.0 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: emacs-orgmode@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: "emacs-orgmode@gnu.org" Errors-To: emacs-orgmode-bounces+larch=yhetil.org@gnu.org Sender: "Emacs-orgmode" Reply-to: "Berry, Charles" From: "Berry, Charles" via "General discussions about Org-mode." X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1622223093; h=from:from:sender:sender:reply-to:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=zf7c77kv+QrhEIvW3bDrs6TL/rKy52jBKSY65wDoB0E=; b=BNM8iPYAQz1bB+D75+x6PHXI7LlSYicl+7XaKZgM1NsFODwh6OHnZm9HlXqWRlThZTyz9x WDqW29/D9crGojWCKHFI3sJceav7W2QPRmj+5oBvv2Ilb4mr/cHG1QKt7jt0mk93nVy8gy SPbQuNhD+YTxSD7cXlBRkzGAvEqItGSpL56DcGg3KRZ+sLTiwO3S9AdjzSyZoCyaOovbGJ YpEjJFJceojQ4jY10UATtXmeZ7w0wHd1/BCMjZJHff7/n3avXsj4Gbbu1ZLRYsigB+n+Lr jc8KYkZrV185ja6KeFELdCnFmgTenwBDV2d5uH7cfxDvs6d9eHLAH9gLEqIHVg== ARC-Seal: i=2; s=key1; d=yhetil.org; t=1622223093; a=rsa-sha256; cv=fail; b=ZAP97FzX5E8Q64L2ySnmGvokgkWGU9LqU+1JlxI1aT6FI1iMfxdmijH4iDiftAzZ5a+6yr NP4H0CZ9jx1eDKgRb5saDsaaka7xEzmP58Ln/9r7kU8WvOSORs40APHMGpdYuiTeILCmJy dK/9LbJUz+u51SYZ69aBBh8D+4PvZFCjADH3eiEl4W2yKCDBdtkjDpZc52Nd9Jsda9bDCY b+TBTW/d3ghCzpPZfu6JgwCVQqM+sm5zKUvC3Tk1/mNcFcIAHaTrcIUbANsAENFmOMvlJ9 3LmI4jni8F7+F076Zu1HmpG+ZAWOZMPQHYkXSu9ahPN7bu9AANPuTAVZ6w2JQw== ARC-Authentication-Results: i=2; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=ucsd.edu header.s=campus header.b=c7nnkvD2; dkim=fail ("headers rsa verify failed") header.d=ucsdhs.onmicrosoft.com header.s=selector2-ucsdhs-onmicrosoft-com header.b=o4VnwLKC; arc=reject ("signature check failed: fail, {[1] = sig:microsoft.com:reject}"); spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Spam-Score: -0.93 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=ucsd.edu header.s=campus header.b=c7nnkvD2; dkim=fail ("headers rsa verify failed") header.d=ucsdhs.onmicrosoft.com header.s=selector2-ucsdhs-onmicrosoft-com header.b=o4VnwLKC; arc=reject ("signature check failed: fail, {[1] = sig:microsoft.com:reject}"); dmarc=pass (policy=none) header.from=gnu.org; spf=pass (aspmx1.migadu.com: domain of emacs-orgmode-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=emacs-orgmode-bounces@gnu.org X-Migadu-Queue-Id: EA8DD146B1 X-Spam-Score: -0.93 X-Migadu-Scanner: scn0.migadu.com X-TUID: m2tOzFyNZgNF > On May 28, 2021, at 8:52 AM, Roger Mason wrote: >=20 > Hello, >=20 > I have an SQL source block that returns this: >=20 > #+RESULTS: query >=20 >=20 [snip] > I would like to pass this into R for further processing. At the moment > I have this: >=20 > #+begin_src R :session :colnames yes :var data=3Dquery > r <- data.frame($data) [snip] data.frame($data) is not valid R syntax. If you are new to R doing some tut= orials will help. I suggest you use C-c C-v C-v (org-babel-expand-src-block) to see what the = R code is and debug the result given in the the *Org Babel Preview...* buff= er. HTH, Chuck