SQLite Problem in 4.5

[Bob Sneidar]

OK just figured out what the syntax does. I ran this query against a Spiceworks sqLite database, substituting column and table names with  those in the Spiceworks database, and the query worked fine for me. At this point, what I would suggest is getting the sqLite plugin for Firefox and making queries directly against the sqLite database. See what you get then. 

Bob


On Nov 13, 2010, at 9:59 AM, Peter Haworth wrote:

> Just ran into a serious problem with and SQLite SELECT statement in 4.5.
> 
> I'm selecting data from my database with the following SQLite statement
> 
> put revDataFromQuery(,,gDBID,myLine) after tdata
> 
> myline contains SELECT PlaceID, Name || ',' || City || ',' || State AS Location FROM Places ORDER BY Name
> 
> In 4.0, this successfully selects all the correct data.  In 4.5 is selects only 2 rows.  Same codebase, same database.  Executing the SELECT in 2 or 3 different SQLite query utilities returns the correct data
> 
> Has anyone run into this type of issue with 4.5?
> 
> Pete Haworth
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution