hi guys,
can anyone see anything wrong with the following query format...
cfquery dbtype=query
SELECT *
FROM qGetAllProducts
WHERE (
(product_title LIKE '%table%')
OR (product_description LIKE '%table%')
OR (cat_title LIKE '%table%')
OR (artist_fname LIKE '%table%')
OR (artist_lname LIKE
Does the product have a product_title of 'Table' or 'table'?
I haven't checked in a while, but it might be case-sensitive.
::-Original Message-
::From: Mike Little [mailto:[EMAIL PROTECTED]
::Sent: Sunday, April 06, 2008 12:23 AM
::To: CF-Talk
::Subject: using LIKE in query of queries
::
hey william, you are right. it does appear to be case sensitive. darn.
Does the product have a product_title of 'Table' or 'table'?
I haven't checked in a while, but it might be case-sensitive.
::-Original Message-
::
::Sent: Sunday, April 06, 2008 12:23 AM
::To: CF-Talk
::Subject:
Try the lower() function - that might work in the QoQ.
On Sun, Apr 6, 2008 at 3:41 PM, Mike Little [EMAIL PROTECTED] wrote:
hey william, you are right. it does appear to be case sensitive. darn.
Does the product have a product_title of 'Table' or 'table'?
I haven't checked in a while,
Paul,
That's the link for v8. I'm looking for a working link to the v8.01
extensions.
-Dan
Dan,
Damon Ledet's blog
(http://blog.damonledet.com/index.cfm/2008/4/5/Coldfusion-801) lists links for
8.01 for extensions to Dreameweaver and Eclipse. The link he lists for Eclipse
is:
hi Dominic,
for some reason your approach with filtering verity results with a qoq
gives me an error:
Query Of Queries syntax error.
Encountered vSearch key. Incorrect conditional expression, Expected one
of [like|null|between|in|comparison] condition,
my qoq is:
cfquery name=qoqSearchResults
The link he lists for Eclipse is:
http://download.macromedia.
com/pub/coldfusion/8/eclipseextensions/CF801-Extensions-for-Eclipse.
zip
I see that that's the same URL as the one you listed... What I should have
said, Dan, was that I'm having no trouble with the URL. The extensions download
thanks james and william, got it sorted.
Try the lower() function - that might work in the QoQ.
On Sun, Apr 6, 2008 at 3:41 PM, Mike Little [EMAIL PROTECTED] wrote:
hey william, you are right. it does appear to be case sensitive. darn.
Does the product have a product_title of 'Table' or
for some reason your approach with filtering verity results with a qoq
gives me an error:
Oh yeh, you must put it in square brackets as CF sees it as a keyword even
thought it is prefixed. Forgot about that.
cfquery name=qoqSearchResults dbtype=query
SELECT *
FROM vSearch, dbSearch
WHERE
Judith,
The link he lists for Eclipse is:
http://download.macromedia.
com/pub/coldfusion/8/eclipseextensions/CF801-Extensions-for-Eclipse.
zip
I see that that's the same URL as the one you listed... What I should have
said, Dan, was that I'm having no trouble with the URL. The extensions
i'm working with an incredibly picky java lib. one key method requires a java
List (really, it barfs on ArrayList, etc.). after beating around google
several bushes blogs i ended up whipping up a java wrapper for this but it
seems like such a hack for something that should be simple.
anybody
Just curious, what is the method signature? I would have expected
ArrayList, Vector, etcetera to work, since they all implement java.
util.List.
Also, what does your java wrapper look like?
~|
Adobe® ColdFusion® 8
i'm working with an incredibly picky java lib. one key method requires a java
List (really, it barfs on ArrayList, etc.).
Just curious, what is the method signature? I would have expected ArrayList,
Vector, etcetera to work, since they all implement java.util.List.
Yeah, I would have thought so to.
What does the method signature look like?
Mark
On Mon, Apr 7, 2008 at 3:11 AM, C S [EMAIL PROTECTED] wrote:
i'm working with an incredibly picky java lib. one key method requires a java
List (really, it barfs on ArrayList, etc.).
Just curious, what is the
C S wrote:
Just curious, what is the method signature? I would have expected ArrayList,
Vector, etcetera to work, since they all implement java.util.List.
me too but as i said it's incredibly picky (it being jfreechart). it wants a
java.util.List nothing else. it's signature:
public static
So you can't just go:
list = createObject(java, java.util.ArrayList).init();
list.add(...);
And pass that through?
Mark
On Mon, Apr 7, 2008 at 9:42 AM, Paul Hastings [EMAIL PROTECTED] wrote:
C S wrote:
Just curious, what is the method signature? I would have expected
ArrayList,
A List is a List. There has to be some other explanation for the
weirdness. Even with your code, you're not passing a List, you're
passing an ArrayList. Did you try constructing an ArrayList and pass
in your CF array (aka a Vector)? I have no idea why an ArrayList
would work but a Vector
me too but as i said it's incredibly picky (it being jfreechart). it wants a
java.util.List nothing else. it's signature:
You are not kidding. It does seem to be picky.
Can you psych-it-out by using java.util.Arrays.asList(...)?
Is it possible to get the web server Name or IP that is making the CFM
request?
We have separate machines for ColdFusion and the Web Server (IIS)
And we have a DR site with the same set up.
When we flip over to the DR site, we have to change APPLICATION variable to
the DR web server address.
It
A List is a List. There has to be some other explanation for the
weirdness.
Duh! I was accidentally calling init(). Obviously that does not work with an
abstract class ;)
This seems to work:
cfscript
cfArray = [ javacast(double, 15.0), javacast(double, 22.5) ];
Box = createObject(java,
Barney Boisvert wrote:
A List is a List. There has to be some other explanation for the
weirdness. Even with your code, you're not passing a List, you're
passing an ArrayList. Did you try constructing an ArrayList and pass
in your CF array (aka a Vector)? I have no idea why an ArrayList
Mark Mandel wrote:
So you can't just go:
list = createObject(java, java.util.ArrayList).init();
list.add(...);
And pass that through?
nope. it even rejects java.utils.Arrays.asList() which btw returns a nested
class Arrays$ArrayList.
i suppose a problem was that i couldn't create a List
C S wrote:
You are not kidding. It does seem to be picky.
this is just the most stubborn case, it's picky all over the place i thought
this workaround wasn't so cool. don't get me wrong, it's quite a cool lib, just
a bit too finicky.
Can you psych-it-out by using
Paul, what exactly is the error? Is CF not finding it?
Can we see the code you're attempting at least?
Mark
On Mon, Apr 7, 2008 at 11:19 AM, Paul Hastings [EMAIL PROTECTED] wrote:
C S wrote:
You are not kidding. It does seem to be picky.
this is just the most stubborn case, it's picky
What am I doing wrong? When the following is viewd on FireFox, the 1st and
3rd row show correctly, but on IE 6, the middle row shows right. Any
suggestions?
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0//EN
html
head
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
STYLE
Thanks, Dominic,
However... the qoq started complaining about comparing integers to
strings... I guess Verity search returns all data as strings...
I had to CAST image_id column in db query as CHAR, and it started
working... But... it that right? Should it be like that?
I am worried that casting
don't cgi.remote_host or cgi.remote_address do the trick?
Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
AJ Mercer wrote:
Is it possible to get the web server Name or IP that is making the CFM
request?
We have separate machines for ColdFusion and the Web Server (IIS)
And we have a
Paul, what exactly is the error? Is CF not finding it?
Can we see the code you're attempting at least?
Yes, please. Because I am able to pass in a CF array without problem. Granted,
I am using an abstract class.
~|
Adobe®
I installed CF8 Updater 1 to my CF8 multiserver install.
Now every instance of CF is dead, reporting:
500
ROOT CAUSE:
coldfusion.runtime.CfJspPage$NoSuchTemplateException: Could not find
the ColdFusion Component or Interface
It sounds scary to me. I've just downloaded the Windows version.
On 07/04/2008, James Holmes [EMAIL PROTECTED] wrote:
I installed CF8 Updater 1 to my CF8 multiserver install.
Now every instance of CF is dead, reporting:
500
ROOT CAUSE:
Please let us know how it goes. We're on SLES 10.1 Linux.
On Mon, Apr 7, 2008 at 10:58 AM, George Lu [EMAIL PROTECTED] wrote:
It sounds scary to me. I've just downloaded the Windows version.
On 07/04/2008, James Holmes [EMAIL PROTECTED] wrote:
I installed CF8 Updater 1 to my CF8
Hi Andy
wots is ur email id , mine is wrvishnu(at)(gmail)(d0t)(com)
Vishnu...
Feel free to email me offlist if you have questions. I'm in the middle of
building an HTML/JS AIR application using the jQuery library. I found that
it went a lot quicker in the beginning, but I found significant
32 matches
Mail list logo