it was a typo

everything works now, problem was my actual query/update code
lacked a space after table name and the where, i.e.

"SELECT a FROM " + table_name +
"WHERE ... etc."

because of the way I had laid out my code the missing space
didn't jump out at me and the sql exception message wasn't clear

When I jumped over to MS SQL Server and Sprinta and the
problem didn't go away I knew it was in my court and dug out the typo.

Another (my bug) problem came in when I jumped from Statement to
PreparedStatement but didn't drop the query from the executeUpdate(query)
and SQL reported a parse error on "".    Once I pulled the query
from the method call with PreparedStatement everything worked
like a champ.

All is well now.


> They should be.  Is the \o a typo below, or are you really trying to 
> send \o?
> thanks,
> --Barry
> Heitzso wrote:
>> PreparedStatement setString(i, s)
>> i.e.
>> p = connection.preparedStatement("SELECT a FROM b WHERE c = ?");
>> String s = "hello\t\out\r\nthere\t\t\t\r\n";
>> p.setString(1, s);
>> Just beating my head against the wall trying to sort out
>> what I'm doing wrong and about to hook up to MS SQL Server
>> via Sprinta to get this working ...
>> Thanks,
>> Heitzso

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly

Reply via email to