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.

Web datawindow problem with Microsoft SQL Server Ver 7

4 posts in General Discussion (old) Last posting was on 2000-03-14 14:02:15.0Z
Mark Carlile Posted on 2000-03-10 17:08:25.0Z
Newsgroups: sybase.public.easerver
From: "Mark Carlile" <nospam_carlilem@americanimaging.net>
Organization: 38.211.2.50
X-Newsreader: AspNNTP 1.41 (Advent 2000, Inc.)
Subject: Web datawindow problem with Microsoft SQL Server Ver 7
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Fri, 10 Mar 2000 12:08:25 -0500
Lines: 20
NNTP-Posting-Host: 207.156.232.4
Message-ID: <347_wE6f$Mri$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26659
Article PK: 157659

Web datawindow problem with Microsoft SQL Server Ver 7 Database

Using EA Server 3.0. Web datawindow. Using dw.describe to retrieve SQL for data
window, then dynamically modifying the where clause. The where clause for the
modified SQL says &#8230;. WHERE (m.modal_code in (2, 3, 6, 5, 4, 1) and
(site_state in (&#8220;NJ&#8221;))&#8230;

After dw.modify() and dw.Generate(), I get error message Select error: SQLSTATE
= S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name 'NJ'.

If I drop the site_state portion of the where clause, the select and the web
datawindow retrieves data correctly. Can anyone help? THANKS!

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Larry Cermak[Team Sybase] Posted on 2000-03-11 03:51:23.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Web datawindow problem with Microsoft SQL Server Ver 7
Date: Fri, 10 Mar 2000 21:51:23 -0600
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-Mimeole: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_b#oHZ5wi$GA.111@forums.sybase.com>
References: <347_wE6f$Mri$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26601
Article PK: 157614

I saw some things like this with MS SQL recently at a client and they were
forced to switch to a stored procedure.

Does this statement work correctly if run in PB database painter? How about
the MS SQL isql?

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Mark Carlile" <nospam_carlilem@americanimaging.net> wrote in message
news:wE6f$Mri$GA.111@forums.sybase.com...
> Web datawindow problem with Microsoft SQL Server Ver 7 Database
>
> Using EA Server 3.0. Web datawindow. Using dw.describe to retrieve SQL
for data
> window, then dynamically modifying the where clause. The where clause for
the
> modified SQL says &#8230;. WHERE (m.modal_code in (2, 3, 6, 5, 4, 1) and
> (site_state in (&#8220;NJ&#8221;))&#8230;
>
> After dw.modify() and dw.Generate(), I get error message Select error:
SQLSTATE
> = S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'NJ'.
>
> If I drop the site_state portion of the where clause, the select and the
web
> datawindow retrieves data correctly. Can anyone help? THANKS!
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp


Mark Carlile Posted on 2000-03-13 19:47:00.0Z
Newsgroups: sybase.public.easerver
From: "Mark Carlile" <no_spam_carlilem@americanimaging.net>
Organization: 38.211.2.50
X-Newsreader: AspNNTP 1.41 (Advent 2000, Inc.)
Subject: Re: Web datawindow problem with Microsoft SQL Server Ver 7
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Date: Mon, 13 Mar 2000 14:47:00 -0500
Lines: 46
NNTP-Posting-Host: 207.156.232.4
Message-ID: <347_Q#2mlTSj$GA.202@forums.sybase.com>
References: <347_wE6f$Mri$GA.111@forums.sybase.com> <347_b#oHZ5wi$GA.111@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26502
Article PK: 157519

This sql statement works in both PB database painter and the MS SQL isql.
Interesting that the numeric m_modal_code works fine and the alpha site_state
code doesn't work. I tried single quotes instead of double quotes around the
state, same error.



On Fri, 10 Mar 2000 21:51:23 -0600,
in powersoft.public.easerver

Larry Cermak[Team Sybase] <lcermak@ctpartners.com> wrote:
>I saw some things like this with MS SQL recently at a client and they were
>forced to switch to a stored procedure.
>
>Does this statement work correctly if run in PB database painter? How about
>the MS SQL isql?
>
>--
>
>Larry Cermak [Team Sybase]
>Corporate Technology Partners, Inc.
>www.ctpartners.com
>Web DataWindow Articles
>(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
>
>
>"Mark Carlile" <nospam_carlilem@americanimaging.net> wrote in message
>news:wE6f$Mri$GA.111@forums.sybase.com...
>> Web datawindow problem with Microsoft SQL Server Ver 7 Database
>>
>> Using EA Server 3.0. Web datawindow. Using dw.describe to retrieve SQL
>for data
>> window, then dynamically modifying the where clause. The where clause for
>the
>> modified SQL says WHERE (m.modal_code in (2, 3, 6, 5, 4, 1) and
>> (site_state in ("NJ"))
>>
>> After dw.modify() and dw.Generate(), I get error message Select error:
>SQLSTATE
>> = S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
>'NJ'.
>>
>> If I drop the site_state portion of the where clause, the select and the
>web
>> datawindow retrieves data correctly. Can anyone help? THANKS!
>>
>> ---== Posted via the PFCGuide Web Newsreader ==---
>> http://www.pfcguide.com/_newsgroups/group_list.asp
>
>

---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp


Larry Cermak[Team Sybase] Posted on 2000-03-14 14:02:15.0Z
Newsgroups: sybase.public.easerver
From: "Larry Cermak[Team Sybase]" <lcermak@ctpartners.com>
Subject: Re: Web datawindow problem with Microsoft SQL Server Ver 7
Date: Tue, 14 Mar 2000 08:02:15 -0600
Lines: 74
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Host: node6.dhcpchi.dslspeed.zyan.com 208.41.199.6
Message-ID: <347_rPJT28bj$GA.201@forums.sybase.com>
References: <347_wE6f$Mri$GA.111@forums.sybase.com> <347_b#oHZ5wi$GA.111@forums.sybase.com> <347_Q#2mlTSj$GA.202@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26459
Article PK: 157474

Any possibility of trying a different driver?

--

Larry Cermak [Team Sybase]
Corporate Technology Partners, Inc.
www.ctpartners.com
Web DataWindow Articles
(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)

"Mark Carlile" <no_spam_carlilem@americanimaging.net> wrote in message
news:Q#2mlTSj$GA.202@forums.sybase.com...
> This sql statement works in both PB database painter and the MS SQL isql.
> Interesting that the numeric m_modal_code works fine and the alpha
site_state
> code doesn't work. I tried single quotes instead of double quotes around
the
> state, same error.
>
>
>
> On Fri, 10 Mar 2000 21:51:23 -0600,
> in powersoft.public.easerver
> Larry Cermak[Team Sybase] <lcermak@ctpartners.com> wrote:
> >I saw some things like this with MS SQL recently at a client and they
were
> >forced to switch to a stored procedure.
> >
> >Does this statement work correctly if run in PB database painter? How
about
> >the MS SQL isql?
> >
> >--
> >
> >Larry Cermak [Team Sybase]
> >Corporate Technology Partners, Inc.
> >www.ctpartners.com
> >Web DataWindow Articles
> >(http://sdn.sybase.com/sdn/appdev/get_doc.stm?loc=1001708)
> >
> >
> >"Mark Carlile" <nospam_carlilem@americanimaging.net> wrote in message
> >news:wE6f$Mri$GA.111@forums.sybase.com...
> >> Web datawindow problem with Microsoft SQL Server Ver 7 Database
> >>
> >> Using EA Server 3.0. Web datawindow. Using dw.describe to retrieve SQL
> >for data
> >> window, then dynamically modifying the where clause. The where clause
for
> >the
> >> modified SQL says WHERE (m.modal_code in (2, 3, 6, 5, 4, 1) and
> >> (site_state in ("NJ"))
> >>
> >> After dw.modify() and dw.Generate(), I get error message Select error:
> >SQLSTATE
> >> = S0022 [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column
name
> >'NJ'.
> >>
> >> If I drop the site_state portion of the where clause, the select and
the
> >web
> >> datawindow retrieves data correctly. Can anyone help? THANKS!
> >>
> >> ---== Posted via the PFCGuide Web Newsreader ==---
> >> http://www.pfcguide.com/_newsgroups/group_list.asp
> >
> >
>
> ---== Posted via the PFCGuide Web Newsreader ==---
> http://www.pfcguide.com/_newsgroups/group_list.asp