Return-Path: <user-return-11943-archive-asf-public=cust-asf.ponee.io@ignite.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id 5D9DE200C8C
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Tue, 23 May 2017 06:58:13 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id 5C194160BD4; Tue, 23 May 2017 04:58:13 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id A19A1160BBF
	for <archive-asf-public@cust-asf.ponee.io>; Tue, 23 May 2017 06:58:12 +0200 (CEST)
Received: (qmail 34742 invoked by uid 500); 23 May 2017 04:58:06 -0000
Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ignite.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ignite.apache.org>
List-Post: <mailto:user@ignite.apache.org>
List-Id: <user.ignite.apache.org>
Reply-To: user@ignite.apache.org
Delivered-To: mailing list user@ignite.apache.org
Received: (qmail 34732 invoked by uid 99); 23 May 2017 04:58:06 -0000
Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 23 May 2017 04:58:06 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id 2A843190D5A
	for <user@ignite.apache.org>; Tue, 23 May 2017 04:58:06 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 2.174
X-Spam-Level: **
X-Spam-Status: No, score=2.174 tagged_above=-999 required=6.31
	tests=[DKIM_ADSP_CUSTOM_MED=0.001, NML_ADSP_CUSTOM_MED=1.2,
	RCVD_IN_DNSWL_NONE=-0.0001, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001]
	autolearn=disabled
Received: from mx1-lw-us.apache.org ([10.40.0.8])
	by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024)
	with ESMTP id RnNqe5a6nuRL for <user@ignite.apache.org>;
	Tue, 23 May 2017 04:58:05 +0000 (UTC)
Received: from mwork.nabble.com (mwork.nabble.com [162.253.133.43])
	by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 293D45FCC4
	for <user@ignite.apache.org>; Tue, 23 May 2017 04:58:05 +0000 (UTC)
Received: from static.162.255.23.37.macminivault.com (unknown [162.255.23.37])
	by mwork.nabble.com (Postfix) with ESMTP id BDC9143E4F1F5
	for <user@ignite.apache.org>; Mon, 22 May 2017 21:58:04 -0700 (MST)
Date: Mon, 22 May 2017 21:58:04 -0700 (MST)
From: rishi007bansod <rishi007bansod@gmail.com>
To: user@ignite.apache.org
Message-ID: <1495515484770-13079.post@n6.nabble.com>
In-Reply-To: <CALOGAoxWEatm0L28oCB3Eb-osCawR742=SCnyEyCrMhum-UZOw@mail.gmail.com>
References: <1495312341743-13049.post@n6.nabble.com> <CALOGAoxWEatm0L28oCB3Eb-osCawR742=SCnyEyCrMhum-UZOw@mail.gmail.com>
Subject: Re: Error while passing arraylist as argument to INSERT data into
 Ignite cache using pyodbc
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
archived-at: Tue, 23 May 2017 04:58:13 -0000

If instead of id_list i.e. list of ids, if I pass single parameter(not list)
as argument as follows,

*cursor = connection.cursor()
select_string= "INSERT INTO Person (_key, id,  firstName, lastName, salary)
VALUES (322, ? , 'abcd', 'dhsagd', 1000)"

cursor.execute(select_string, 'test')
*
I am still getting following error,

*Traceback (most recent call last):
  File "pythonOdbclist.py", line 13, in <module>
    cursor.execute(select_string, id_list)
pyodbc.ProgrammingError: ('The SQL contains 0 parameter markers, but 1
parameters were supplied', 'HY000')*

I think either Ignite or pyodbc is unable to identify paramere marker *"?"*
that I have provided

Thanks.



--
View this message in context: http://apache-ignite-users.70518.x6.nabble.com/Error-while-passing-arraylist-as-argument-to-INSERT-data-into-Ignite-cache-using-pyodbc-tp13049p13079.html
Sent from the Apache Ignite Users mailing list archive at Nabble.com.