I'm running a query to get featured products.
For the call, I'm using:
cfinvokecomponent =components.products
method =select_featured_products
returnVariable=featured_products/
and the cffunction is:
cffunction
the problem isn't the empty query. an empty query is still a query. the
problem is you're returning featured_products but your query is named
get_featured_products. you're returning an empty variable.
change this line:
cfset var featured_products = /
to:
cfset var get_featured_products = /
AFter the query do this...
cfif NOT get_featured_products.recordcount
cfset get_featured_products = QueryNew('id')
/cfif
That should fix the problem.
Rick Faircloth wrote:
I'm running a query to get featured products.
For the call, I'm using:
cfinvokecomponent =
but, but, but... I thought I saw CFC examples where the cfreturn variable
didn't match the query name. (It didn't make much sense, but then, again,
not a lot of the CFC stuff does, right now)
The change made it work, however.
Now I know. The cfreturn variable has to match the query name.
the return variable has to match whatever it is you want to return. in
*this* case, it's the query.
let's say you just wanted to return a recordcount... then the return
variable wouldn't match the query name. it'd match a variable name:
cffunction name=getNumberOfUsers output=false
Rick Faircloth wrote:
Now I know. The cfreturn variable has to match the query name.
Well, no. It has to match what you want to return. Sure there are lots
of examples where the return does not match the query name because the
query is not what is necessarily returned. But if your function
All cleared up... thanks, Charlie.
Rick
Charlie Griefer wrote:
the return variable has to match whatever it is you want to return. in
*this* case, it's the query.
let's say you just wanted to return a recordcount... then the return
variable wouldn't match the query name. it'd match a
Got it. Thanks, Ian.
Rick
Ian Skinner wrote:
Rick Faircloth wrote:
Now I know. The cfreturn variable has to match the query name.
Well, no. It has to match what you want to return. Sure there are lots
of examples where the return does not match the query name because the
Hi
i have this very simple line of code that i am trying to run in a query of
query:
select * from query where T_Site like '%,1,%'
but i am getting the error:
Encountered T_Site. Incorrect conditional expression, Incorrect conditional
expression, Lexical error at line 0, column 0.
select * from query where T_Site like '%1%'
On Fri, Jun 20, 2008 at 3:28 PM, Richard White [EMAIL PROTECTED] wrote:
Hi
i have this very simple line of code that i am trying to run in a query of
query:
select * from query where T_Site like '%,1,%'
but i am getting the error:
Encountered
hi, i need the commas in the like clause though, how can i get these in there?
thanks
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
I don't think you can have them.. Perhaps you can escape them? /,?
On Fri, Jun 20, 2008 at 3:36 PM, Richard White [EMAIL PROTECTED] wrote:
hi, i need the commas in the like clause though, how can i get these in there?
thanks
You aren't by chance storing a comma-delimited list in a single column a
database are you? :)
~Brad
-Original Message-
From: Phillip Vector [mailto:[EMAIL PROTECTED]
Sent: Friday, June 20, 2008 5:41 PM
To: CF-Talk
Subject: Re: very basic query error???
I don't think you can have them
You aren't by chance storing a comma-delimited list in a single column a
database are you? :)
hi brad, well not in the database but this particular column in the coldfusion
query at this point could have comma delimited lists.
this query is something i have created out of various other queries
i have actually used this in other queries and it does work fine and pulls out
the data as required, its just that in this one i am having problems
i have managed now to get rid of the error above, its becuase it was trying to
change the single quotes to double quotes. so i used the
josh managed to find the solution in this post:
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56796
it was down to some cells in that column being null when using the like clause
- i had to include where T_Site is not null
and now it is working fine
You aren't by chance
No, there shouldn't he any problems storing a comma delimited list-- it's just
bad normalization since a list isn't an atomic value.
If you are searching for 1 make sure you account for the following lists:
1,2,3
3,2,1
2,1,3
%,1,% is only work for one of those.
~Brad
would a comma delimited
Referring to this thread
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56335#305025
I wanted to pass a variable to a dynamic select box, so I changed this:
option value='#SITEID#' selected=#sid#
to
option value=#SITEID#cfif SITEID EQ sid selected=selected/cfif
and now get Error
Referring to this thread
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56335#305025
I wanted to pass a variable to a dynamic select box, so I changed this:
option value='#SITEID#' selected=#sid#
to
option value=#SITEID#cfif SITEID EQ sid selected=selected/cfif
and now get Error
Referring to this thread
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:56335#305025
I wanted to pass a value to a dynamic select box (in a url), so I changed this:
option value='#SITEID#' selected=#sid#
to
option value=#SITEID#cfif SITEID EQ sid selected=selected/cfif
and now
Does anyone know why I might get this sometimes? Mysql:
Query Error: Duplicate entry '75A8BA37-2B3E-7F0C-15E97C353E23FA73_100' for key
1 Datasource: Native Error Code: 1062 SQL State: 23000 Executing SQL:
INSERT INTO ...
Normally works fine so I don't understand it and google does
stylo stylo wrote:
Query Error: Duplicate entry '75A8BA37-2B3E-7F0C-15E97C353E23FA73_100' for
key 1 Datasource: Native Error Code: 1062 SQL State: 23000 Executing
SQL: INSERT INTO ...
There is already a check to see if the basket exists before adding the item,
so shouldn't
There is already a check to see if the basket exists before adding
the item, so shouldn't be a duplicate basket id.
Is there a lock from the time the basket is checket and the query is done?
--
___
REUSE CODE! Use custom tags;
See
I get the following during a radius check on zipcodes when I choose say 500
miles from point x
Internal Query Processor Error: The query processor ran out of stack space
during query optimization
Any Ideas?
Doug B.
~|
06, 2007 12:44 PM
Subject: Query error
I get the following during a radius check on zipcodes when I choose say
500 miles from point x
Internal Query Processor Error: The query processor ran out of stack space
during query optimization
Any Ideas?
Doug B
In my code I am running two cfsearches. The results from the second search
need to appear at the top of the results from the first search. So I append
them to the first set and manually set the score and the rank so can force the
results to the top in a query of a query.
That is where I am
ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Michael Beins [mailto:[EMAIL PROTECTED]
Sent: Monday, November 13, 2006 7:46 AM
To: CF-Talk
Subject: Query of Query Error
In my code I am running two cfsearches. The results from the second search
need to appear at the top
cf-talk@houseoffusion.com
Sent: Monday, November 13, 2006 12:45 PM
Subject: Query of Query Error
In my code I am running two cfsearches. The results from the second
search need to appear at the top of the results from the first search. So
I append them to the first set and manually set
This issue has been resolved, thanks everyone for your help.
In my code I am running two cfsearches. The results from the second
search need to appear at the top of the results from the first search.
So I append them to the first set and manually set the score and the
rank so can force
Certified Advanced ColdFusion MX7 Developer
www.bennadel.com
Need ColdFusion Help?
www.bennadel.com/ask-ben/
-Original Message-
From: Michael Beins [mailto:[EMAIL PROTECTED]
Sent: Monday, November 13, 2006 7:46 AM
To: CF-Talk
Subject: Query of Query Error
In my code I am
]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, May 24, 2006 9:17 PM
Subject: Re: insert query error - ANY FIX IDEAS?
Yea that might be it .. i'll switch it up .. but wouldnt the error state
THAT and not 'datatype mismatch' ??
It's microsoft so of course it wont..
here is a list
]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, May 24, 2006 9:17 PM
Subject: Re: insert query error - ANY FIX IDEAS?
Yea that might be it .. i'll switch it up .. but wouldnt the error state
THAT and not 'datatype mismatch' ??
It's microsoft so of course it wont..
here is a list
Here is a strange one.
I'm running Access as the database.
Before I get too much deeper the Format for the column is Yes/No (but the
values are 1/0) -- So maybe I need to insert Yes or No instead of 1 or 0 ???
I'll try that
I inserted test as a hard coded value in the last 2 columns
-talk@houseoffusion.com
Subject: insert query error - ANY FIX IDEAS?
Here is a strange one.
I'm running Access as the database.
Before I get too much deeper the Format for the column is Yes/No (but the
values are 1/0) -- So maybe I need to insert Yes or No instead of 1 or 0 ???
I'll try
Yea that might be it .. i'll switch it up .. but wouldnt the error state
THAT and not 'datatype mismatch' ??
- Original Message -
From: dave [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Wednesday, May 24, 2006 8:48 PM
Subject: re: insert query error - ANY FIX IDEAS
always know which tables are mine.
~Dave the disruptor~
From: Joe Velez [EMAIL PROTECTED]
Sent: Thursday, May 25, 2006 12:11 AM
To: CF-Talk cf-talk@houseoffusion.com
Subject: Re: insert query error - ANY FIX IDEAS?
Yea that might be it .. i'll switch it up
[mailto:[EMAIL PROTECTED]
Sent: 18 April 2006 01:59
To: CF-Talk
Subject: Re: 19 = 19 - query error
On 4/16/06, Adrian Lynch [EMAIL PROTECTED] wrote:
Nope, I use a passive code generator. Less risky :O)
Passive? Generation is generation, man! Heh. What do you mean?
Incoming! (Heh. Not often
:[EMAIL PROTECTED]
Sent: 16 April 2006 04:41
To: CF-Talk
Subject: Re: 19 = 19 - query error
On 4/14/06, Adrian Lynch [EMAIL PROTECTED] wrote:
And to balance out the argument some, writing all the columns takes
longer
to write!
Go on, fire away, I'm in my bunker and the flaps are down :OD
Something that I like about the 1=1... It's pretty handy for getting rid of
those WHERE blah blah AND blah blah things that sometimes happen
when you have conditional WHERE stuff. Just put a WHERE 1=1, and,
the rest are ANDs.
Just a little tidbit that makes it easier when you do have to do that
code to manipulate
the DB. They love that. Really.
:Deni
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 20:32
To: CF-Talk
Subject: RE: 19 = 19 - query error
Rick,
This is the easiest problem in the world to fix
Don't use SELECT *.
Name
code to manipulate
the DB. They love that. Really.
:Deni
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 20:32
To: CF-Talk
Subject: RE: 19 = 19 - query error
Rick,
This is the easiest problem in the world to fix
Don't use SELECT *.
Name
Adam Howitt wrote:
This bug usually happens when you change something on the database
server when you are using a prepared statement (cfqueryparam). The
workarounds I can recommend are
1. Disable maintain client connections in the cf admin - less desirable
2. Change the query ever so
what the heck is this?
19 = 19
The error occurred in
E:\Inetpub\wwwroot\tools\email_responses\respond.cfm: line 20
18 :A.*, B.name as PRMLNAME
19 : FROM dbo.results A left join dbo.results2 b on a.fromAddress=b.email
20 : where id=cfqueryparam cfsqltype=cf_sql_integer value=#id#
21 :
we'll have to go right to ludacris speed.
-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED]
Sent: Friday, April 14, 2006 11:51 AM
To: CF-Talk
Subject: 19 = 19 - query error
what the heck is this?
19 = 19
The error occurred in
E:\Inetpub\wwwroot\tools\email_responses\respond.cfm
And to balance out the argument some, writing all the columns takes longer
to write!
Go on, fire away, I'm in my bunker and the flaps are down :OD
Adrian
-Original Message-
From: Ben Nadel [mailto:[EMAIL PROTECTED]
Sent: 14 April 2006 20:32
To: CF-Talk
Subject: RE: 19 = 19 - query error
I had tried doing a to_char but that didn't work so I did some reasearch and
found if I used this select dbms_lob.substr( name, 32765, 1 ) I was able to do
this select to_char(dbms_lob.substr( name, 32765, 1 )) and then I was able to
do a query of a query.
Bob Everland
Does anyone know why a query of a query would return this error. The column was
description, but I changed it to bobTest to make sure it wasn't a reserved word.
Error Executing Database Query.
Query Of Queries runtime error.
Query Of Queries runtime error.
Failed to get meta_data for
Can we see your code?
-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED]
Sent: 12 January 2006 13:11
To: CF-Talk
Subject: Query of query error
Does anyone know why a query of a query would return this error. The column
was description, but I changed it to bobTest
I'm just trying to integrate the new changes to lighthouse into the 6.1
version, nothing crazy. I did a dump of the query and it has the column in it
cfquery name=issues dbtype=query
select *
fromissues
where 1=1
cfif url.bugtype_filter is not
Another thing to add is the field is a CLOB from Oracle, could that have
anything to do with why I can't query that field?
Bob
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:229362
Archives:
Ah, yes, possibly. CLOBS and VARCHARs are very different - if you want
to be able to do a LIKE clause in the QoQ, try using
to_char(theCLOBColumn) in the original query (assuming the text is
small enough).
On 1/13/06, Robert Everland III [EMAIL PROTECTED] wrote:
Another thing to add is the field
Here's an interesting one for anyone bored or obviously more
'in-the-know' than i.
Background:
We have site that gets a fair amount of activity (700,000 - 1.5 mil page
views a day). It's a data providing website for subscribers of the
service. About 4 months ago, we started caching a query on
Dave, thanks for your response. See my responses below:
My guess is that one of the following is true:
1. You don't have a datasource called coursesDB.
I do. I've been accessing it and making modifications to it. It seems
only to mess up when I try and do this UPDATE type query.
2. The user
can you post a more informative error message? Also, test it without the
queryparams. Also, maybe just build the SQL in a string and email it to
yourself to see if the SQL and inputed arguments are actually coming in
correct from Flash.
Aside fro this I'll not that you should VAR scope your
where 9 should be an integer, unless Remoting still sends it
as a string. If so, it seems there is no way to be sure it's
being sent as a number from Flash, is there a way in CF to convert
it from a string type (if that's really how its being sent) to type
numeric? Or at least find
Subject: Re: Query error
can you post a more informative error message? Also, test it without
the
queryparams. Also, maybe just build the SQL in a string and email it
to
yourself to see if the SQL and inputed arguments are actually coming
in
correct from Flash.
Aside fro this I'll not that you
-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, July 15, 2005 11:14 AM
To: CF-Talk
Subject: RE: Query error
where 9 should be an integer, unless Remoting still sends it
as a string. If so, it seems there is no way to be sure it's
being sent as a number from Flash, is there a way
can you post a more informative error message?
OK - I put in some pseudo variables instead of using the ones from Flash
Remoting and got this when I call the CFC from a CFM:
--
Error Executing Database
From: Merrill, Jason [mailto:[EMAIL PROTECTED]
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC
Socket][Microsoft][ODBC Microsoft Access Driver] The table
'Lessons' is already opened exclusively by another user, or
it is already open through the user interface
If you have that table open in design view or open at all in Access (I
think), you will get this error.
On 7/15/05, Merrill, Jason [EMAIL PROTECTED] wrote:
can you post a more informative error message?
OK - I put in some pseudo variables instead of using the ones from Flash
Remoting and got
Do you have the Access DB open on your workstation?
Oops! That seemed to be it. I feel like an idiot. I was doing updates
previously with the database without a problem when the file was open in
access. It only popped up now when I did the UPDATE for some reason.
Thanks Michael, Dave, Doug,
Any idea why I'm getting an Error Executing Database Query. With this?
I can take out the query and return lesson and row just fine.
Lesson and ID in the table are varchar and integer type fields
respectively.
cfcomponent
cffunction name=recieveData access=remote
cfargument name=lesson
Any idea why I'm getting an Error Executing Database Query.
With this?
I can take out the query and return lesson and row just fine.
Lesson and ID in the table are varchar and integer type fields
respectively.
cfcomponent
cffunction name=recieveData access=remote
cfargument
I'll do my part here...
recieve is spelled wrong too.
:)
Will
www.codefusiongear.com
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
Can't quite figure out why this would generate an error AND what
Operation must use an updateable query means:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Operation must use an updateable query.
The error occurred
Tim Laureska wrote:
Can't quite figure out why this would generate an error AND what
Operation must use an updateable query means:
Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC
Microsoft Access Driver] Operation must use an updateable
tim,
have you tried the sql drivers, vs. the odbc drivers?
tw
On 6/3/05, Tim Laureska [EMAIL PROTECTED] wrote:
Can't quite figure out why this would generate an error AND what
Operation must use an updateable query means:
Error Executing Database Query.
[Macromedia][SequeLink JDBC
Make sure you have a primary key on the table in question.
Then, perform a manual insert inside the database itself.
-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Friday, June 03, 2005 12:05 PM
To: CF-Talk
Subject: query error
Can't quite figure out why
You may want to check this techNote:
http://www.macromedia.com/cfusion/knowledgebase/index.cfm?id=tn_17282
Operation must use an updateable query error when trying to update Access
database
This is generally a result of ColdFusion not having appropriate permissions at
the Network Operating
On Wednesday 26 May 2004 19:07 pm, Alexander Sherwood wrote:
I'm not aware of any restrictions on the data types a CF query can contain.
Am I wrong?
It would be restricted to valid SQL types, wouldn't it ?
How the hell do you get a CFC into a query column to run a QoQ on anyway ? I
think you
Has anyone run into errors when doing a Query of a Query where one of the columns holds a CFC?
I'm not aware of any restrictions on the data types a CF query can contain. Am I wrong?
Thanks!
--
Alex
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I get the following error:
Query Of Queries runtime error.
Unsupported type comparison.
Here's my code:
cfquery name=qResults dbtype=query
select *
from variables.listings.qResults
where price between 1 AND 999
AND beds = 0
AND baths = 0
I get the following error:
Query Of Queries runtime error.
Unsupported type comparison.
Here's my code:
cfquery name=qResults dbtype=query
select *
from variables.listings.qResults
where price between 1 AND 999
AND beds = 0
AND
=qResults dbtype=query
select *
fromtemp
where price between 1 AND 999
AND beds = 0
AND baths = 0
/cfquery
-Brad
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 10:50 AM
To: CF-Talk
Subject: RE: Query of Query Error
I get the following error
Did you verify that your where clause is working? Theoretically, you should
be using WHERE bed is not null not where bed '' (assuming the original
column is a number column).
- Original Message -
From: Brad Roberts
Ok, I queried the original query to get only rows which had numeric
Ok, I queried the original query to get only rows which had
numeric values for price, beds, baths... Then, I queried the
new query.I get the same error.
cfquery name=temp dbtype=query
select *
fromvariables.listings.qResults
where price ''
AND beds ''
AND baths ''
/cfquery
cfquery
/cfquery
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Monday, April 05, 2004 11:15 AM
To: CF-Talk
Subject: RE: Query of Query Error
Ok, I queried the original query to get only rows which had
numeric values for price, beds, baths... Then, I queried the
new query.I
There's no database. The query is built dynamically from
data on another website.
When you populate the query object, try using Val to populate your numeric
columns.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
[Todays Threads]
[This
Mark Leder said:
cfquery name=indexCitations datasource= timeout=900
SELECT *
FROM citationsTable
/cfquery
I now want to move this over to CFMX 6.1, but running just a simple
query to return all records throws the following error (after about
15 seconds):
Error
Jochem,
That simple change to Unicode support worked. Query runs in about 1.5
seconds now.
Thanks!
Mark
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, October 17, 2003 5:07 AM
To: CF-Talk
Subject: Re: Access db Query error
Mark Leder said
I presently have a query run against an Access 2000 db in preparation for a
Verity CFIndex on CF5.This is 5 fields containing about 17,000 records -
runs fine (but slow) on the CF5 box.
Here's the query:
cfquery name=indexCitations datasource= timeout=900
SELECT *
FROM citationsTable
/cfquery
I
Good morning...
CF 4.5 / Win 2000 Pro
Trying to setup a shopping cart and was doing fine last night testing this
code.
This morning when I start running it, I get the error message:
(The CFLOOP at 21:1 to 21:29 is the CFLOOP Query=Session.Cart at the
bottom)
Why would the Session.Cart query
query error?
Good morning...
CF 4.5 / Win 2000 Pro
Trying to setup a shopping cart and was doing fine last night testing this
code.
This morning when I start running it, I get the error message:
(The CFLOOP at 21:1 to 21:29 is the CFLOOP Query=Session.Cart at the
bottom)
Why would
: RE: Why am I getting this not an available query error?
What is application.cfm defaulting it to? Perhaps the
default value you are setting is not a valid query/structure?
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED
First, try using:
CFLOOP Query=#Session.Cart#
CF needs to know that Session.Cart is a variable.
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 9:55 AM
To: CF-Talk
Subject: Why am I getting this not an available query error?
Good
:
CFSET Temp = QuerySetCell(Session.Cart, Amount,
DollarFormat(Evaluate(Form.Size4x6*3.95)))
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 9:18 AM
To: CF-Talk
Subject: RE: Why am I getting this not an available query error?
Hi
CFLOOP Query=#Session.Cart#
Coming in late as usual
Eh? Never used CF Loop like that before... is it not just a string that
goes into the query attribute of the cfloop?
From the docs...
cfloop query = query_name
startRow = row_num
endRow = row_num
ie query_name not the actual query
: RE: Why am I getting this not an available query error?
First, try using:
CFLOOP Query=#Session.Cart#
CF needs to know that Session.Cart is a variable.
~|
Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137485
Archives
!
Thanks!
Rick
-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 10:24 AM
To: CF-Talk
Subject: RE: Why am I getting this not an available query error?
First, try using:
CFLOOP Query
: RE: Why am I getting this not an available query error?
CFLOOP Query=#Session.Cart#
Coming in late as usual
Eh? Never used CF Loop like that before... is it not just a
string that
goes into the query attribute of the cfloop?
From
Subject: RE: Why am I getting this not an available query error?
No, then cf will try to resolve the variable as the name of
the query and you'll get:
Complex object types cannot be converted to simple values.
Am I correct
Heh.. I'm an idiot.
Maybe I should read the message a little more closely :)
-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 18, 2003 10:52 AM
To: CF-Talk
Subject: RE: Why am I getting this not an available query error?
Thanks for the tip
I'm performing a couple of verity searches, and then performing a query of a
query to union the results and I'm getting the following error, that I'm
really unfamiliar with...
Query Of Queries runtime error.
All resulting columns of queries in a SELECT statement containing a UNION
operator must
I've got this query of query that's working on CF 5... On MX it produces
this error:
Error Executing Database Query.brbQuery Of Queries syntax error./bbr
Encountered from at line 5, column 44. Incorrect conditional expression,
Expected one of [like|null|between|in|comparison] condition, The
Oooops!! the title of my last post was stricken by some random dyslexia. :)
should read works on CF 5 bombs on MX
I've got this query of query that's working on CF 5... On
MX it produces
this error:
Error Executing Database Query.brbQuery Of Queries
syntax error./bbr
Encountered from at
It's the other from -- the OR from = section. Perhaps [from]?
-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]
Sent: Thursday, 13 March 2003 1:31 p.m.
To: CF-Talk
Subject: query of query error -- works on mx bombs on cf 5
I've got this query of query that's working
So I'm guessing that MX is creating the msgid column as a varchar column
and
it's complaining about msgid #attributes.cleared# ... So does anybody
know how to set the data type on a query column created using querynew()
in
MX?
I've had success with this problem by putting putting Val()
awesome, thanks. :)
So I'm guessing that MX is creating the msgid column as a
varchar column
and
it's complaining about msgid #attributes.cleared# ...
So does anybody
know how to set the data type on a query column created
using querynew()
in
MX?
I've had success with this problem by
with the val() in the query.
Error Executing Database Query.brbQuery Of Queries runtime
error./bbr Unsupported type comparison. The specific sequence of files
included or processed is: C:\CFusionMX\wwwroot\dev\talkontap\index.cfm
damn this is frustrating.
So I'm guessing that MX is creating the msgid
#' AND '#enddate#' cfif storename
is NOT AllAND storename='#storename#'/cfif ORDER BY #orderby#
#updn# /cfquery
=
I thought it could be a query error in the QofQ (qNew) so I removed the
WHERE clause and it still fails. I can output the code from
1 - 100 of 126 matches
Mail list logo