Re: [ADMIN] Query problem

2011-09-07 Thread Kevin Grittner
Lukasz Brodziak wrote: > I have two DBs from the same user. When I run a query: SELECT > wer_sys||'.'||wer_int||'.'||wer_wew FROM ver WHERE code = '1243' > on a boken DB I get an error: ERROR: array value must start with > "{" or dimension information but when I try to run the query on a > "he

[ADMIN] Query problem

2011-09-05 Thread Lukasz Brodziak
Hello, I have two DBs from the same user. When I run a query: SELECT wer_sys||'.'||wer_int||'.'||wer_wew FROM ver WHERE code = '1243' on a boken DB I get an error: ERROR: array value must start with "{" or dimension information but when I try to run the query on a "healthy" DB I don't have the e

Re: [ADMIN] query problem

2003-01-14 Thread Nick Fankhauser
lf Of helen liu Sent: Monday, January 13, 2003 11:17 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [ADMIN] query problem Nick, Thank you very much for your response. Actually, here is the details:- I have a Students table with only three columns: firstname, lastname, email. I issued the f

Re: [ADMIN] query problem

2003-01-13 Thread helen liu
Nick, Thank you very much for your response. Actually, here is the details:- I have a Students table with only three columns: firstname, lastname, email. I issued the following select statements:1) select * from students;  2). select firstname, last name from students; query 1) worked fine, but qu

Re: [ADMIN] query problem

2003-01-13 Thread Nick Fankhauser
Helen- There is a separate JDBC list for related questions that I suggest you use in the future. A code sample is needed for a really good answer, but I'll make a guess. This message is probably telling you that you are either trying to set a value in a where clause that has a higher index than t