"Tag Libraries Users List" <[EMAIL PROTECTED]>
Sent: Thu, 20 May 2004 16:02:02 -0400
Subject: RE: [JSTL] How do I enter a null value with ?
> Wow! I just installed the jTDS JDBC driver for Microsoft SQL Server, and it does
> *not*
produce the NULL parameter problem that
Thank you again for this jTDS reference!
Derek
-Original Message-
From: Kris Schneider [mailto:[EMAIL PROTECTED]
Sent: May 20, 2004 3:21 PM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with ?
I'm merely aware of its existence. I've never used jTDS
, so it is unnecessary to identify
> > its type.
> >
> > Derek
> >
> > -----Original Message-
> > From: Derek Mahar
> > Sent: May 20, 2004 2:08 PM
> > To: Tag Libraries Users List
> > Subject: RE: [JSTL] How do I enter a null value with ?
PROTECTED]
Sent: May 20, 2004 2:57 PM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with ?
On a slightly different topic, how about trying a different driver:
http://jtds.sourceforge.net/
Quoting Derek Mahar <[EMAIL PROTECTED]>:
> I need to clarify the first
t; Sent: May 20, 2004 2:08 PM
> To: Tag Libraries Users List
> Subject: RE: [JSTL] How do I enter a null value with ?
>
>
> Thank you. I appreciate your attention and quick response.
>
> After reading JDBC Specification Section 13.2.2.3, Setting NULL Parameters, I
> unders
, so it is unnecessary to identify its type.
Derek
-Original Message-
From: Derek Mahar
Sent: May 20, 2004 2:08 PM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with ?
Thank you. I appreciate your attention and quick response.
After reading JDBC
fgang Röckelein
> [mailto:[EMAIL PROTECTED]
> Sent: May 19, 2004 10:40 AM
> To: Tag Libraries Users List
> Subject: Re: [JSTL] How do I enter a null value with ?
>
>
> Keith wrote:
>
>>This was on the Users list and was my problem. But mine had to do
>>specifi
being patient with my posts as I
worked through my problem.
Derek
-Original Message-
From: Wolfgang Röckelein [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:40 AM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value with ?
Keith wrote:
This was on the Users list
pointing me in the right direction and being patient with my posts as I
worked through my problem.
Derek
-Original Message-
From: Wolfgang Röckelein [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:40 AM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value with ?
Keith
rchive.com/[EMAIL PROTECTED]/msg06989.html
Derek
-Original Message-
From: Keith [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:28 AM
To: [EMAIL PROTECTED]
Subject: Re: [JSTL] How do I enter a null value with ?
This was on the Users list and was my problem. But mine had to do specifi
ot; but it says nothing about how it handles a null object
reference.
Derek
-Original Message-
From: Keith [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:28 AM
To: [EMAIL PROTECTED]
Subject: Re: [JSTL] How do I enter a null value with ?
This was on the Users list and was my problem. Bu
I still do not believe this is a JDBC driver problem for reasons that I have given in
two previous posts.
-Original Message-
From: Wolfgang Röckelein [mailto:[EMAIL PROTECTED]
Sent: May 19, 2004 10:05 AM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value with
EMAIL PROTECTED]
Sent: May 19, 2004 10:40 AM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value with ?
Keith wrote:
> This was on the Users list and was my problem. But mine had to do
> specifically with the
> and the Oracle JDBC driver. The regular worked fine for
: May 19, 2004 10:28 AM
To: Tag Libraries Users List; [EMAIL PROTECTED]
Subject: Re: [JSTL] How do I enter a null value with ?
It certainly could be a driver issue, but you've gotta pass null instead of "null" to
find out ;-). The Standard taglib uses the following to set
inal Message-
> From: Kris Schneider [mailto:[EMAIL PROTECTED]
> Sent: May 18, 2004 9:10 PM
> To: Tag Libraries Users List
> Subject: Re: [JSTL] How do I enter a null value with ?
>
>
>
>
> Derek Mahar wrote:
> > How do I enter a null value into a tab
Keith wrote:
This was on the Users list and was my problem. But mine had to do specifically with the
and the Oracle JDBC driver. The regular worked fine for me
when I passed it a null value.
Link to the starting thread in the archive:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg06748.ht
It certainly could be a driver issue, but you've gotta pass null instead of
"null" to find out ;-). The Standard taglib uses the following to set SQL
parameters:
PreparedStatement.setObject(int parameterIndex, Object x)
It should be pretty easy to write a simple JDBC test to see how your driver
b
-- Original Message ---
From: Wolfgang Röckelein <[EMAIL PROTECTED]>
To: Tag Libraries Users List <[EMAIL PROTECTED]>
Sent: Wed, 19 May 2004 16:05:14 +0200
Subject: Re: [JSTL] How do I enter a null value with ?
> Derek Mahar wrote:
>
> > Your solution
Derek Mahar wrote:
Your solution is equivalent to Case 2 that I listed in my original
message. The Microsoft SQL Server JDBC driver complains with a
JspException:
javax.servlet.ServletException: javax.servlet.jsp.JspException:
INSERT INTO tblTest(a) VALUES (?)
: [Microsoft][SQLServer 2000 Drive
Correction: the table name should have read tblTest rather than
tblTestDerek.
-Original Message-
From: Derek Mahar
Sent: May 19, 2004 9:45 AM
To: Tag Libraries Users List
Subject: RE: [JSTL] How do I enter a null value with ?
Your solution is equivalent to Case 2 that I listed in my
is Schneider [mailto:[EMAIL PROTECTED]
> Sent: May 18, 2004 9:10 PM
> To: Tag Libraries Users List
> Subject: Re: [JSTL] How do I enter a null value with ?
>
>
>
>
> Derek Mahar wrote:
> > How do I enter a null value into a table column with ? The
>
> &g
where it treats "null" as a string
argument rather than as an SQL null argument.
Derek
-Original Message-
From: Kris Schneider [mailto:[EMAIL PROTECTED]
Sent: May 18, 2004 9:10 PM
To: Tag Libraries Users List
Subject: Re: [JSTL] How do I enter a null value with ?
Derek Mah
Derek Mahar wrote:
How do I enter a null value into a table column with ? The
JSTL 1.1 specification states for that, "If value is null,
the parameter is set to the SQL value NULL." However, no matter what
value I pass to , I'm unable to set a null column:
Case 1: Set value to undefined variabl
How do I enter a null value into a table column with ? The
JSTL 1.1 specification states for that, "If value is null,
the parameter is set to the SQL value NULL." However, no matter what
value I pass to , I'm unable to set a null column:
Case 1: Set value to undefined variable
INSERT INTO tb
24 matches
Mail list logo
