RE: Moto drops Mysql connection

> -----Original Message-----
> From: Jack [mailto:[email protected]] 
> Sent: Monday, March 03, 2003 10:33 PM
> To: [email protected]
> Subject: Re: [moto-users] Moto drops Mysql connection
> 
> 
> Okay, Im missing something....
> 
> I have pulled a query off a db, and come up with a sring full 
> of numbers.
> 
> For example one of the strings would be: 3032003
> 
> Now I want to do a sql query such as:
> 
> String tableName = "transactions";
> String query = "select pictures,description from " + 
> tableName + "WHERE date >" + begin_date;

You are "smooshing" your "WHERE" against your table name so it doesn't see
the "WHERE" clause.

Change to:

String query = "select pictures,description from " + tableName + " WHERE
date >" + begin_date


Shay

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.459 / Virus Database: 258 - Release Date: 2/25/2003