Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnGjg-0004nH-O0 for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 06:14:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hnGje-00042r-Jl for pgsql-sql@arkaria.postgresql.org; Tue, 16 Jul 2019 06:14:46 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hnGjd-00042k-SP for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 06:14:46 +0000 Received: from sonic316-13.consmr.mail.bf2.yahoo.com ([74.6.130.123]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.92) (envelope-from ) id 1hnGja-0003VR-Az for pgsql-sql@lists.postgresql.org; Tue, 16 Jul 2019 06:14:44 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1563257681; bh=UYdzw3IAMdS9dXZVJKLhQbZugmb58fI1R0bNa6Rqrp4=; h=Date:From:To:In-Reply-To:References:Subject:From:Subject; b=HrT9aXogAn7aNYfXcK8SZVSLJCAi4GOlAs1CulVgXdAViDz9A4e10SNNmVA++G6QPLma7YRTvO2Z1emXMKq26o4d1Qe8UXw8DHuBglciN2UpqX7G2EO5fZzXIY20fv34BQbjgQVzwNMC/EBQaQRCjLV++bg4578mkGkXvome2b8sw0W2MKiTc+QtsmM4+tFUUZHZwyHZzZ5XGI83hk6RhtJaXCBbxdS3ACyJOsL0tg5bFlKXhLuwVjro48ggde896tHtnf0d1maByGz9veIvajTvGH1lYS824vvrBrqIRl88FrJvRaqYyTMvtU09OGullV05NWdf+nc+wOVNkyvDDA== X-YMail-OSG: oaKl5ykVM1l_1eLwixAhqxksWuJnjDEUcqkGceYdkgxng57V9QwGeqKeAHwQ1Ae cZUAYdCvYDFzIZ8ez.4gA82RrYvYUF9Xg7o6s9C6J5cDhBfT2U6IhrtxC45MDDnBpPmvPxeJx9fk v_7EpTcMdZhTQ6pGgfRO4FKXaCsjlS6HbEvFco4CWTZjXI11O9hisC0sD2tCzF2l6EwWf2t5tANi RKb5I6Zxd2xrVMLpNoe7HAanyBcQnJS9D9c5tGMrM.xqAqef8tgaw.HvsjrPKkxTgTIUs5R3F5wO aQEBeSgsdn7OvrPTfESK2aCCvi6.36vYoZDImOeFenOztJuw2RhBN1tfPmx1Kti2FdloIwU6U3Su cwna9RoWYdL8utExe_rTvFuyy_VPcyv3nC.mhOUu4A2.l_soXcF6KWUoBmtCXW59su2Yw49WJQjm UMgGQ55XRahHCNl0kTQYNCA_ODrpVdVgfyoTn7gzTWkGnTffMJfsHmXxR_V7pn6hdZd.laqKvyBS X.tlhc77B2MxN0bouFcv1QvP_zt2pNw5Zi_oT8KR2AfYFZ8uDdyCYklRPfIzrB1z1eUm1W287Mps 3cqRMKfN8SGN_x3ubYoyCtZ5xWbnPNMTRVexOaf53zRDWTZXUQMQWJ11oGKAbIer.cMlVZF2Celk 7fRgp9QZoC6dZ_s74TR5XMvlMUH2EJk3VVKxsbVaU.XEcF7IUhbzLHGsT9GjifXu_MVo27P.0ptf QjG8_F4lKIZfhinSFnv69KZXPwQZSajQ.f68yNFkFjJuqVLSsvhunYGTUwJAW1fX21JkVJ8pqD8v N1ylCI0TDWyxn2m0vQmYXNsmBfy2HdJ89C0XjIwq5FKSNfeBMcTyE0lqsMix6tJG62Bp0FoA7oWP xr3R.eSM2LNCIW0Za8XeDRj56qBasjLLnrFIRhkMVHRIHl56ozYaFpHUOBvmJbsLAACGYLAQcKxx fTq5Y3izrpC3Yw3I1gHbuGlOEGkoWPZISzTKZq_JjerjxA0H73uRplZXYQfo9kUYE2YGwCN99wNR ExK4KCfRC_QKeFEZoGUEju1qgfqlXGAcrgOhFdHMgaGh3CHlY_L9AzJa0oRxlXHWG0myAtAxRiio DrTVktqCRnT6g_uKHjMIARYQr.Qr7Xoy2sUFVPupcVSTz0uvgVY1Gzk_dyt9zvXmMp6TrcWnNuA7 OxyZr9a6ly7y7seDB7ui5c_d9UX7YDsMXdUfw6B1sPuWdC7Rbqg55BKyQJnlbryYEWN2SOoHCj29 ys67fep94zy4fan6jO7B2Pel10xN1pD0i4O9UZeboszddynET1Zvrp9dX Received: from sonic.gate.mail.ne1.yahoo.com by sonic316.consmr.mail.bf2.yahoo.com with HTTP; Tue, 16 Jul 2019 06:14:41 +0000 Date: Tue, 16 Jul 2019 06:14:35 +0000 (UTC) From: Karen Goh To: "pgsql-sql@lists.postgresql.org" Message-ID: <774271584.1091322.1563257675315@mail.yahoo.com> In-Reply-To: References: <110414461.528890.1563075361778@mail.yahoo.com> <1846547624.530883.1563075598322@mail.yahoo.com> <40544440.741577.1563178850210@mail.yahoo.com> <768811852.1032981.1563242356010@mail.yahoo.com> Subject: Fw: how to resolve org.postgresql.util.PSQLException: ERROR: operator does not exist: text = integer? MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1091321_346506179.1563257675314" X-Mailer: WebService/1.1.13991 YahooMailIosMobile Yahoo%20Mail/45955 CFNetwork/978.0.7 Darwin/18.6.0 Content-Length: 4928 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_1091321_346506179.1563257675314 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Attn to all: For sone kind of strange reason I do not know why the mail is not sent to a= ll. I have normally wrote n replied to the last person who wrote but yahoo mail= didn=E2=80=99t let me write at there. Hope everyone receives this mail this time round. N please help me. Tks! Sent from Yahoo Mail for iPhone Begin forwarded message: On Tuesday, July 16, 2019, 1:01 PM, David G. Johnston wrote: On Mon, Jul 15, 2019 at 6:59 PM Karen Goh wrote: May I know why did you say I am comparing subject_name to an integer ? I am trying to get both tutor_id and subject_name from the same table base= d on the no of ? in subjectName as per parameterValues. Again, you need to send messages to the mailing, not me personally. That said you might want to first figure out what: ps2.setInt(1, tutor_id);=C2=A0 is supposed to accomplish in your code. David J. ------=_Part_1091321_346506179.1563257675314 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Attn to all:

For sone kind of strange reason I do not kn= ow why the mail is not sent to all.

I have normall= y wrote n replied to the last person who wrote but yahoo mail didn=E2=80=99= t let me write at there.

Hope everyone receives th= is mail this time round.

N please help me.

Tks!




Sent from Yahoo Mail fo= r iPhone

Begin forwarded message:

On Tuesday, July 16, 2019,= 1:01 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:

On Mon, Jul 15, 2019 at 6:59 PM Karen Goh <karenworld@yahoo.com&g= t; wrote:

May I know why did you say I am comparing subject_= name to an integer ?

I am trying to g= et both tutor_id and subject_name from the same table based on the no of ? = in subjectName as per parameterValues.

Again, you need to send m= essages to the mailing, not me personally.

That said you might want to first figur= e out what:

ps2.setInt(1, tutor_id); 

is supposed to accomplish i= n your code.

David J.

<= /div>
------=_Part_1091321_346506179.1563257675314--