all fields in the db are varchar2 and i am trying to send it parameters from a request obj, also i am using Oracle8i..is there any occasion when the ? mark need to be quoted? alex
-----Original Message----- From: Shawn Bayern [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 4:29 PM To: Tag Libraries Users List Subject: Re: SQL Query question On Mon, 15 Jul 2002, Alex Reznik wrote: > Hello, > please take a look at the following: > > <sql:query var="value"> > select value from msgrouter.mr_preferences where category = ? and name = ? > <sql:param value="${tmp}"/> > <sql:param value="${tmp_name}"/> > </sql:query> > > i am getting an invalid column type error from this statement...is the error > in "and name = ?" part and how do i avoid it? If the error says something like "invalid column type," that probably comes from your JDBC driver. The error sounds like it's indicative of an attempt to assign a variable of one type to a column that cannot accept that type. (E.g., you might be setting an integer in to a SQL TIMESTAMP field.) Without more information, it'll be hard to diagnose the problem further. -- Shawn Bayern "JSTL in Action" http://www.jstlbook.com (coming in July 2002 from Manning Publications) -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>