Bookmarks

Yahoo Gmail Google Facebook Delicious Twitter Reddit Stumpleupon Myspace Digg

Search queries

w2ksp4.exe, WwwxxXdbf, procmail "FROM_MAILER" patch, Use of assignment to $[ is deprecated at /usr/local/sbin/apxs line 86. , wwwxxx vim, mysql closing table and opening table, 800c5000, setgid operation not permitted, pciehp: acpi_pciehprm on IBM, WWWXXX.DBF

Links

XODOX
Impressum

#1: Query bug

Posted on 2011-07-24 15:21:23 by Velen

------=_NextPart_000_0031_01CC4A26.1C56B940
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I have the following query which is fine when I run it from the mysql =
shell screen:

select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where =
paymentdate<=3D'2010-12-02' and grnno not in (Select sale_id from =
saletrans_cons where paymode=3D'Credit') group by supplier_code

but when I use VB to send this same query the results exclude the last =
record.

Can anyone tell me why I'm having this issue with VB? =20

Thanks.


Veln
------=_NextPart_000_0031_01CC4A26.1C56B940--

Report this message

#2: Re: Query bug

Posted on 2011-07-24 15:41:55 by Johnny Withers

--20cf302ad694a7ce3304a8d0dca0
Content-Type: text/plain; charset=ISO-8859-1

What's your vb code for outputting the results look like?

On Jul 24, 2011 8:22 AM, "Velen Vydelingum" <velen@biz-mu.com> wrote:

Hi,

I have the following query which is fine when I run it from the mysql shell
screen:

select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
paymentdate<='2010-12-02' and grnno not in (Select sale_id from
saletrans_cons where paymode='Credit') group by supplier_code

but when I use VB to send this same query the results exclude the last
record.

Can anyone tell me why I'm having this issue with VB?

Thanks.


Veln

--20cf302ad694a7ce3304a8d0dca0--

Report this message

#3: Re: Query bug

Posted on 2011-07-24 19:54:39 by Velen

It's something like :

conn.execute ("insert into tmptable select
supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
paymentdate<='2010-12-02' and grnno not in (Select sale_id from
saletrans_cons where paymode='Credit') group by supplier_code")


Veln



----- Original Message -----
From: "Johnny Withers" <johnny@pixelated.net>
To: "Velen Vydelingum" <velen@biz-mu.com>
Cc: <mysql@lists.mysql.com>
Sent: Sunday, July 24, 2011 17:41
Subject: Re: Query bug


> What's your vb code for outputting the results look like?
>
> On Jul 24, 2011 8:22 AM, "Velen Vydelingum" <velen@biz-mu.com> wrote:
>
> Hi,
>
> I have the following query which is fine when I run it from the mysql
> shell
> screen:
>
> select supplier_code,0,0,0,0,0-sum(amountpaid),0 from custpayments where
> paymentdate<='2010-12-02' and grnno not in (Select sale_id from
> saletrans_cons where paymode='Credit') group by supplier_code
>
> but when I use VB to send this same query the results exclude the last
> record.
>
> Can anyone tell me why I'm having this issue with VB?
>
> Thanks.
>
>
> Veln
>


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Report this message