RE: ant sql call stored procedure

2008-03-19 Thread Chaohua Wang
Thank you very much for your help. -Original Message- From: Anderson, Rob (Global Trade) [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 19, 2008 12:30 PM To: Ant Users List Subject: RE: ant sql call stored procedure It looks like the sql you are trying to execute is vendor specific

Re: ant sql call stored procedure

2008-03-19 Thread Scot P. Floess
specific statements that may work fine in the vendor supplied client. -Rob Anderson -Original Message- From: Chaohua Wang [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 9:23 AM To: Ant Users List; [EMAIL PROTECTED] Subject: RE: ant sql call stored procedure Hi, Thank you for your

RE: ant sql call stored procedure

2008-03-19 Thread Anderson, Rob (Global Trade)
:[EMAIL PROTECTED] Sent: Monday, March 17, 2008 9:23 AM To: Ant Users List; [EMAIL PROTECTED] Subject: RE: ant sql call stored procedure Hi, Thank you for your suggestion. But I used UTF-8, It changed a little bit, still can not get through. [sql] Executing file: C:\workspace\Canoo\billPay

RE: ant sql call stored procedure

2008-03-19 Thread Anderson, Rob (Global Trade)
sql statements, you can use the exec task to use the run the vendor supplied client. -Rob Anderson -Original Message- From: Chaohua Wang [mailto:[EMAIL PROTECTED] Sent: Thursday, March 13, 2008 10:15 AM To: Ant Users List Subject: ant sql call stored procedure Hi folks, I am using

Re: ant sql call stored procedure

2008-03-17 Thread Scot P. Floess
essage- From: Olivier Gies [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2008 8:02 PM To: Ant Users List Subject: Re: ant sql call stored procedure Hi, It looks like the SQL file is encoded in some version of Unicode (UTF-8 or Unicode/UTF-16 ?), with each character using 2 bytes, and your

RE: ant sql call stored procedure

2008-03-17 Thread Chaohua Wang
NTIFIER ON GO CREATE PROCEDURE [dbo].[uspSelectCount] AS BEGIN SET NOCOUNT ON; Select count(*) from dbo.Payments_Staging; End -Original Message- From: Olivier Gies [mailto:[EMAIL PROTECTED] Sent: Sunday, March 16, 2008 8:02 PM To: Ant Users List Subject: Re: ant sql call stored proc

Re: ant sql call stored procedure

2008-03-16 Thread Olivier Gies
ng tool in Windows, e.g. UltraEdit32) and set the task's "encoding" attribute accordingly (see http://ant.apache.org/manual/CoreTasks/sql.html) BR, Olivier Original Message ---- Subject: ant sql call stored procedure From: Chaohua Wang <[EMAIL PROTECTED]> To:

Re: ant sql call stored procedure

2008-03-14 Thread Bently Drake
Can you please attach sql file with the mail - Original Message From: Steve Loughran <[EMAIL PROTECTED]> To: Ant Users List Sent: Friday, March 14, 2008 3:47:20 PM Subject: Re: ant sql call stored procedure Chaohua Wang wrote: > Hi folks, > > > I am using ant sq

Re: ant sql call stored procedure

2008-03-14 Thread Steve Loughran
Chaohua Wang wrote: Hi folks, I am using ant sql to call a stored procedure of Ms Sql server I can execute stored procedure in Ms Sql server. My stored procedure name is uspSelectCount. But when I am using ant sql to call the file uspSelectCount.sql that is located with the build fil

ant sql call stored procedure

2008-03-13 Thread Chaohua Wang
Hi folks, I am using ant sql to call a stored procedure of Ms Sql server I can execute stored procedure in Ms Sql server. My stored procedure name is uspSelectCount. But when I am using ant sql to call the file uspSelectCount.sql that is located with the build file. I alway

ant sql call stored procedure

2008-03-13 Thread Chaohua Wang
Hi folks, I am using ant sql to call a stored procedure of Ms Sql server I can execute stored procedure in Ms Sql server. My stored procedure name is uspSelectCount. Then I use Execute--> File to generate a file called selectCount.sql. But when I am using ant sql to call the fi