Moto is pretty cool...

Nevermind my previous post - was just formatting errors, I've got it
now!

Thanks,
Jack


On Mon, 2003-03-03 at 22:33, Jack wrote:
> 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;
> 
> I keep getting a MySQL Error:
> /var/www/site/query.moto:37: Uncaught SQLException
>     message: You have an error in your SQL syntax near '>3032003' at
> line 1
> 
> 
> Now when I run this query directly in MySQL:
> select * from transactions where date >= 28012003;
> I get all kinds of information.
> 
> Im not sure what Im doing wrong, but it seems I've tried plenty of
> permutations of the same thing with no luck.
> 
> Anyone help?
> 
> THanks,
> Jack