RE: SQL Query question

2002-07-15 Thread Shawn Bayern
On Mon, 15 Jul 2002, Alex Reznik wrote: > tru, it seems like every time the count is called its incremented, so > if i wanted to use it in the loop for different vars, i would use > count-1, count-2, etc. ive rewritten the loop as begin="0" end="${end}"> and i am not getting the error any more,

RE: SQL Query question

2002-07-15 Thread Alex Reznik
returns only the first value and not all of them?do i need to set the end? or does it find the end of the array and stop there? alex -Original Message- From: Shawn Bayern [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 4:46 PM To: Tag Libraries Users List Subject: RE: SQL Query question

RE: SQL Query question

2002-07-15 Thread Shawn Bayern
On Mon, 15 Jul 2002, Alex Reznik wrote: > here is what i am getting: > by the way, i think the error comes from the second parameter, and it looks > like the following: (i am setting this in a loop) > Are you sure 'tmp_name' doesn't end up null, perhaps because 's.count' is off by one? (In m

RE: SQL Query question

2002-07-15 Thread Alex Reznik
(Thread.java:536) -Original Message- From: Shawn Bayern [mailto:[EMAIL PROTECTED]] Sent: Monday, July 15, 2002 4:39 PM To: Tag Libraries Users List Subject: RE: SQL Query question On Mon, 15 Jul 2002, Alex Reznik wrote: > all fields in the db are varchar2 and i am trying to send it parameters f

RE: SQL Query question

2002-07-15 Thread Shawn Bayern
On Mon, 15 Jul 2002, Alex Reznik wrote: > 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? No, "?" should not need to be quoted. What's the actual text of your error

RE: SQL Query question

2002-07-15 Thread Alex Reznik
Libraries Users List Subject: Re: SQL Query question On Mon, 15 Jul 2002, Alex Reznik wrote: > Hello, > please take a look at the following: > > > select value from msgrouter.mr_preferences where category = ? and name = ? > > > > > i am getting an inval

Re: SQL Query question

2002-07-15 Thread Shawn Bayern
On Mon, 15 Jul 2002, Alex Reznik wrote: > Hello, > please take a look at the following: > > > select value from msgrouter.mr_preferences where category = ? and name = ? > > > > > i am getting an invalid column type error from this statement...is the error > in "and name = ?" part and how

SQL Query question

2002-07-15 Thread Alex Reznik
Hello, please take a look at the following: select value from msgrouter.mr_preferences where category = ? and name = ? i am getting an invalid column type error from this statement...is the error in "and name = ?" part and how do i avoid it? thank you, alex -Original Message- Fro