Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Sybase 15 - Parameterized Query

2 posts in General Discussion Last posting was on 2009-08-01 07:37:52.0Z
alleycat2017 Posted on 2009-08-01 01:05:27.0Z
From: alleycat2017 <alleyd1@netzero.net>
Newsgroups: sybase.public.ase.general
Subject: Sybase 15 - Parameterized Query
Date: Fri, 31 Jul 2009 18:05:27 -0700 (PDT)
Organization: http://groups.google.com
Lines: 4
Message-ID: <4d1d585e-c61f-41fd-aa0e-b59fd9605068@r36g2000vbn.googlegroups.com>
NNTP-Posting-Host: 69.255.2.230
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1249088727 8154 127.0.0.1 (1 Aug 2009 01:05:27 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Sat, 1 Aug 2009 01:05:27 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: r36g2000vbn.googlegroups.com; posting-host=69.255.2.230; posting-account=av6eHwoAAADUkKVeOBIKcsMtEL7YSt7q
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.0.12) Gecko/2009070611 Firefox/3.0.12,gzip(gfe),gzip(gfe)
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!r36g2000vbn.googlegroups.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28078
Article PK: 77324

In Sybase 12.5 could create a parameterized query like "Select * from
table where :parameter = "All". Sybase 15 throws an error. Does
Sybase 15 insist that a query parameter be compared to a table column
or is there a workaround?


Alberto Posted on 2009-08-01 07:37:52.0Z
From: Alberto <Alberto.daSilva@gmail.com>
User-Agent: Thunderbird 2.0.0.22 (Windows/20090605)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Sybase 15 - Parameterized Query
References: <4d1d585e-c61f-41fd-aa0e-b59fd9605068@r36g2000vbn.googlegroups.com>
In-Reply-To: <4d1d585e-c61f-41fd-aa0e-b59fd9605068@r36g2000vbn.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4a73f0d0$2@forums-3-dub.sybase.com>
Date: 1 Aug 2009 00:37:52 -0700
X-Trace: forums-3-dub.sybase.com 1249112272 10.22.241.152 (1 Aug 2009 00:37:52 -0700)
X-Original-Trace: 1 Aug 2009 00:37:52 -0700, vip152.sybase.com
Lines: 17
Path: forums-1-dub!forums-master!forums-3-dub.sybase.com!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28082
Article PK: 77329


alleycat2017 wrote:
> In Sybase 12.5 could create a parameterized query like "Select * from
> table where :parameter = "All". Sybase 15 throws an error. Does
> Sybase 15 insist that a query parameter be compared to a table column
> or is there a workaround?

Always a good idea to post
* the SQL / DDL that you are having a problem with
* the error message / error code


See below for a fix for this issue:
http://www.sybase.com/detail?id=47613
http://www.sybase.com/detail?id=1032433


Alberto