From siddy_tow@yahoo.com Fri Dec  8 11:28:01 2006
Received: from localhost (maia-1.hub.org [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id A6EB09F9EED
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  8 Dec 2006 07:28:01 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024)
	with ESMTP id 48007-09 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  8 Dec 2006 07:28:00 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web36703.mail.mud.yahoo.com (web36703.mail.mud.yahoo.com
	[209.191.85.37]) by postgresql.org (Postfix) with SMTP id A7CAD9F9C35
	for <pgsql-sql@postgresql.org>; Fri,  8 Dec 2006 07:28:00 -0400 (AST)
Received: (qmail 12759 invoked by uid 60001); 8 Dec 2006 11:27:59 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type;
	b=TvwqI/8f8pMDOEUwuZUQjejqGe2R30F1+d9jZIc7SXvkQcHYFQmkpMG8Nz6RJUERvMLh7UduQlcVwCmumu69UeTdciLKRN+Ff1u0V9ReJ968nnqEqF/xfXwNKtb9GDhlaCrCzhcNIDgDZVhQhCJgc8XZStUSxURzM+L9dS/BxHk=
	;
Message-ID: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com>
Received: from [203.126.136.220] by web36703.mail.mud.yahoo.com via HTTP;
	Fri, 08 Dec 2006 03:27:59 PST
Date: Fri, 8 Dec 2006 03:27:59 -0800 (PST)
From: sid tow <siddy_tow@yahoo.com>
Subject: Problem with SQL stored procedure
To: Postgres SQL language list <pgsql-sql@postgresql.org>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-692760956-1165577279=:12133"
X-Archive-Number: 200612/81
X-Sequence-Number: 27037

--0-692760956-1165577279=:12133
Content-Type: text/plain; charset=ascii
Content-Transfer-Encoding: quoted-printable

Hi all=0A=0A        I dont know if this is the right forum to post this but=
 any way if you could help me or guide me to an appropriate forum, I would =
appreciate it.=0AI am trying to call a SQL (SQL server 2000) stored procedu=
re from my c++ code and in that stored procedure I have a Print statement w=
hich will print some string. Now the problem is that the parameters that I =
supply to the stored procedure are returned back with out being modified, b=
ut I expect some modifications to happen to those parameters. And if I comm=
ent out the Print statement I get what I desire. Can somebody explain what =
exactly is happening here?=0A=0ARegards,=0ASyed=0A=0A----- Original Message=
 ----=0AFrom: ivan marchesini <marchesini@unipg.it>=0ATo: Postgres SQL lang=
uage list <pgsql-sql@postgresql.org>=0ASent: Monday, November 13, 2006 10:0=
2:06 PM=0ASubject: [SQL] drop a check=0A=0ADear all...=0AI have created a c=
heck constraint without giving it a name..=0Anow I have a check named "$25"=
 in my table that I need to drop or=0Amodify!!!=0AHow can I do???=0Awith na=
mes is simple=0A=0Aalter table tablename drop constraint constraintname;=0A=
=0Abut without name??   :-)=0A=0Amany thanks...=0A=0AIvan=0A=0A=0A=0A=0A-- =
=0AIvan Marchesini=0ADepartment of Civil and Environmental Engineering=0AUn=
iversity of Perugia=0AVia G. Duranti 93/a =0A06125=0APerugia (Italy)=0Ae-ma=
il: marchesini@unipg.it=0A        ivan.marchesini@gmail.com=0Atel: +39(0)75=
5853760=0Afax: +39(0)755853756=0Ajabber: geoivan73@jabber.org=0A=0A=0A=0A=
=0A---------------------------(end of broadcast)---------------------------=
=0ATIP 6: explain analyze is your friend=0A=0A=0A=0A=0A=0A=0A=0A =0A_______=
___________________________________________________________________________=
__=0AAny questions? Get answers on any topic at www.Answers.yahoo.com.  Try=
 it now.
--0-692760956-1165577279=:12133
Content-Type: text/html; charset=ascii
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:12pt"><div style=3D"font-family: times new roman,new york,times,s=
erif; font-size: 12pt;">Hi all<br><br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;  I do=
nt know if this is the right forum to post this but any way if you could he=
lp me or guide me to an appropriate forum, I would appreciate it.<br>I am t=
rying to call a SQL (SQL server 2000) stored procedure from my c++ code and=
 in that stored procedure I have a Print statement which will print some st=
ring. Now the problem is that the parameters that I supply to the stored pr=
ocedure are returned back with out being modified, but I expect some modifi=
cations to happen to those parameters. And if I comment out the Print state=
ment I get what I desire. Can somebody explain what exactly is happening he=
re?<br><br>Regards,<br>Syed<br><br><div style=3D"font-family: times new rom=
an,new
 york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: i=
van marchesini &lt;marchesini@unipg.it&gt;<br>To: Postgres SQL language lis=
t &lt;pgsql-sql@postgresql.org&gt;<br>Sent: Monday, November 13, 2006 10:02=
:06 PM<br>Subject: [SQL] drop a check<br><br><div>Dear all...<br>I have cre=
ated a check constraint without giving it a name..<br>now I have a check na=
med "$25" in my table that I need to drop or<br>modify!!!<br>How can I do??=
?<br>with names is simple<br><br>alter table tablename drop constraint cons=
traintname;<br><br>but without name??&nbsp;&nbsp; :-)<br><br>many thanks...=
<br><br>Ivan<br><br><br><br><br>-- <br>Ivan Marchesini<br>Department of Civ=
il and Environmental Engineering<br>University of Perugia<br>Via G. Duranti=
 93/a <br>06125<br>Perugia (Italy)<br>e-mail: marchesini@unipg.it<br>&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ivan.marchesini@gmail.com<br>tel:=
 +39(0)755853760<br>fax: +39(0)755853756<br>jabber:
 geoivan73@jabber.org<br><br><br><br><br>---------------------------(end of=
 broadcast)---------------------------<br>TIP 6: explain analyze is your fr=
iend<br></div></div><br></div></div><br>=0A=0A<hr size=3D1>Access over 1 mi=
llion songs - <a href=3D"http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=3D=
36035/*http://music.yahoo.com/unlimited/">Yahoo! Music Unlimited.</a></body=
></html>
--0-692760956-1165577279=:12133--



From shoaibmir@gmail.com Fri Dec  8 11:39:07 2006
Received: from localhost (maia-2.hub.org [200.46.204.187])
	by postgresql.org (Postfix) with ESMTP id B6F779F9EED
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  8 Dec 2006 07:39:07 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024)
	with ESMTP id 67477-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Fri,  8 Dec 2006 07:39:03 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from nz-out-0102.google.com (nz-out-0506.google.com
 [64.233.162.227])
	by postgresql.org (Postfix) with ESMTP id 33B499F9C35
	for <pgsql-sql@postgresql.org>; Fri,  8 Dec 2006 07:39:07 -0400 (AST)
Received: by nz-out-0102.google.com with SMTP id i11so490956nzh
	for <pgsql-sql@postgresql.org>; Fri, 08 Dec 2006 03:39:06 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=iVSRS3JDYtiV0r0rDMB/hB6plZ8bX7By9CZUg/nwOLho2fERNmLxnVrOWN4bzXSjkYem5U+OxXbHuaPUvgMj64Vi0yZjiGRosf2yP2JfZiFMAqihqj+a6FXIw8EXefzVX6OOOzxvzxB/96g1iPo+Hfwab6Urxx40RuAwJWuASC0=
Received: by 10.65.243.18 with SMTP id v18mr2645376qbr.1165577945616;
	Fri, 08 Dec 2006 03:39:05 -0800 (PST)
Received: by 10.65.206.18 with HTTP; Fri, 8 Dec 2006 03:39:05 -0800 (PST)
Message-ID: <bf54be870612080339h4ed484das295b90c0ade859e5@mail.gmail.com>
Date: Fri, 8 Dec 2006 16:39:05 +0500
From: "Shoaib Mir" <shoaibmir@gmail.com>
To: "sid tow" <siddy_tow@yahoo.com>
Subject: Re: Problem with SQL stored procedure
Cc: "Postgres SQL language list" <pgsql-sql@postgresql.org>
In-Reply-To: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_35069_29388122.1165577945568"
References: <20061208112759.12757.qmail@web36703.mail.mud.yahoo.com>
X-Archive-Number: 200612/82
X-Sequence-Number: 27038

------=_Part_35069_29388122.1165577945568
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Wrong mailing list to ask this :-)

Try out a MS SQL Server one and you will get good help on that...

Regards,
Shoaib

On 12/8/06, sid tow <siddy_tow@yahoo.com> wrote:
>
> Hi all
>
>        I dont know if this is the right forum to post this but any way if
> you could help me or guide me to an appropriate forum, I would appreciate
> it.
> I am trying to call a SQL (SQL server 2000) stored procedure from my c++
> code and in that stored procedure I have a Print statement which will print
> some string. Now the problem is that the parameters that I supply to the
> stored procedure are returned back with out being modified, but I expect
> some modifications to happen to those parameters. And if I comment out the
> Print statement I get what I desire. Can somebody explain what exactly is
> happening here?
>
> Regards,
> Syed
>
> ----- Original Message ----
> From: ivan marchesini <marchesini@unipg.it>
> To: Postgres SQL language list <pgsql-sql@postgresql.org>
> Sent: Monday, November 13, 2006 10:02:06 PM
> Subject: [SQL] drop a check
>
> Dear all...
> I have created a check constraint without giving it a name..
> now I have a check named "$25" in my table that I need to drop or
> modify!!!
> How can I do???
> with names is simple
>
> alter table tablename drop constraint constraintname;
>
> but without name??   :-)
>
> many thanks...
>
> Ivan
>
>
>
>
> --
> Ivan Marchesini
> Department of Civil and Environmental Engineering
> University of Perugia
> Via G. Duranti 93/a
> 06125
> Perugia (Italy)
> e-mail: marchesini@unipg.it
>         ivan.marchesini@gmail.com
> tel: +39(0)755853760
> fax: +39(0)755853756
> jabber: geoivan73@jabber.org
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
>
> ------------------------------
> Access over 1 million songs - Yahoo! Music Unlimited.<http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/>
>

------=_Part_35069_29388122.1165577945568
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Wrong mailing list to ask this :-) <br><br>Try out a MS SQL Server one and you will get good help on that...<br><br>Regards,<br>Shoaib<br><br><div><span class="gmail_quote">On 12/8/06, <b class="gmail_sendername">sid tow</b>
 &lt;<a href="mailto:siddy_tow@yahoo.com">siddy_tow@yahoo.com</a>&gt; wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">
<div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">Hi all<br><br>&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;  I dont know if this is the right forum to post this but any way if you could help me or guide me to an appropriate forum, I would appreciate it.
<br>I am trying to call a SQL (SQL server 2000) stored procedure from my c++ code and in that stored procedure I have a Print statement which will print some string. Now the problem is that the parameters that I supply to the stored procedure are returned back with out being modified, but I expect some modifications to happen to those parameters. And if I comment out the Print statement I get what I desire. Can somebody explain what exactly is happening here?
<br><br>Regards,<br>Syed<br><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Original Message ----<br>From: ivan marchesini &lt;<a href="mailto:marchesini@unipg.it" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
marchesini@unipg.it</a>&gt;<br>To: Postgres SQL language list &lt;<a href="mailto:pgsql-sql@postgresql.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">pgsql-sql@postgresql.org</a>&gt;<br>Sent: Monday, November 13, 2006 10:02:06 PM
<br>Subject: [SQL] drop a check<br><br><div>Dear all...<br>I have created a check constraint without giving it a name..<br>now I have a check named &quot;$25&quot; in my table that I need to drop or<br>modify!!!<br>How can I do???
<br>with names is simple<br><br>alter table tablename drop constraint constraintname;<br><br>but without name??&nbsp;&nbsp; :-)<br><br>many thanks...<br><br>Ivan<br><br><br><br><br>-- <br>Ivan Marchesini<br>Department of Civil and Environmental Engineering
<br>University of Perugia<br>Via G. Duranti 93/a <br>06125<br>Perugia (Italy)<br>e-mail: <a href="mailto:marchesini@unipg.it" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">marchesini@unipg.it</a><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="mailto:ivan.marchesini@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">ivan.marchesini@gmail.com</a><br>tel: +39(0)755853760<br>fax: +39(0)755853756<br>jabber:
 <a href="mailto:geoivan73@jabber.org" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">geoivan73@jabber.org</a><br><br><br><br><br>---------------------------(end of broadcast)---------------------------
<br>TIP 6: explain analyze is your friend<br></div></div><span class="ad"><br></span></div></div><span class="ad"><br>

<hr size="1">Access over 1 million songs - <a href="http://pa.yahoo.com/*http://us.rd.yahoo.com/evt=36035/*http://music.yahoo.com/unlimited/" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">Yahoo! Music Unlimited.
</a></span></div><span class="ad">
</span></blockquote></div><br>

------=_Part_35069_29388122.1165577945568--