summarized at
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/using_r6.htm.
It is the official QofQ b*tch page!
I'm really sick of spending so much time searching for workarounds for
QofQ that gets things working until you discover the next bug or come
across a circumstance where a previous workaround doesn't work. My
current issue is that QofQ is trimming whitespace off of the end of some
of my text columns.
That's why I'd like to see a more robust QofQ implementation in Java.
The functionality is so useful I'm surprised I can't find it.
Any ideas anyone?
Jon
>>> [EMAIL PROTECTED] 8/24/2004 7:37:41 PM >>>
Yeah, the datatype thing is a drag. That one really bit me one day.
Did you find some of the work-arounds listed in the Macromedia live
docs? One stands out in my memory, in case you don't get anywhere with
Java - create an empty table with one column of each data type you
need in your database, and name them according to their types, say
numeric, string, date, etc
Then instead of using QueryNew(), create your query with a query to
that empty table using
Select string AS myStringColumn1, numeric AS myNumericColumn1, numeric
AS my numericColumn2, etc
FROM QofQTable
The datatypes will be set and you can then populate it reliably. I
thought it was a cool workaround and worth mentioning.
JICIH ;-)
Nando
On Tue, 24 Aug 2004 17:24:58 -0600, Jon Gunnip
<[EMAIL PROTECTED]> wrote:
> Is there a public package that supports query of queries-like
> functionality in Java? I would assume it would be something like
making
> a SQL-like query against a Java ResultSet in memory.
>
> I keep coming across QofQ bugs. I would like QofQ functionality
> without all of the bugs (not allowing control over column data
types,
> trimming text fields, ...).
>
> Thanks,
> Jon
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
