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 be
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 found it. I guess I have to many records to perform an IN search against
the table and will need to use a temp table to do it. According to MS and
using SQL2000
Doug B.
- Original Message -
From: Doug Brown [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Tuesday, February
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
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
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 this
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
Just add t_subcat_id to a GROUP BY statement:
CFQUERY NAME=q_mostrecent DATASOURCE=uspc
SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID
FROM t_msg
GROUP BY t_mess, t_subcat_id
/CFQUERY
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002
You could either use the GROUP BY statement:
SELECT MAX(t_mess) AS RECHIGH, t_subcat_ID
FROM t_msg
GROUP BY t_mess, t_subcat_id
or do a subquery:
SELECT t_subcat_ID,
(SELECT MAX(t_mess) FROM t_msg) AS RECHIGH
FROM t_msg
__
steve oliver
cresco technologies, inc.
9, 4, 1
So, if 85 were the most recent record, I would want 85 and 4.
Thanks for your assistance.
Mark
-Original Message-
From: Steve Oliver [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 8:54 AM
To: CF-Talk
Subject: RE: Query error in aggregate function
You could either use
SELECT t_mess, t_subcat_ID
FROM t_msg
WHERE t_mess IN (SELECT MAX(t_mess) FROM t_msg)
-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: maandag 21 januari 2002 15:56
To: CF-Talk
Subject: RE: Query error in aggregate function
I still have been unable to get
That worked - thanks.
Mark
-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 10:12 AM
To: CF-Talk
Subject: RE: Query error in aggregate function
SELECT t_mess, t_subcat_ID
FROM t_msg
WHERE t_mess IN (SELECT MAX(t_mess) FROM t_msg
Do You realy need the ; at the end of the Query?
Jason Lees
National Express
Email : [EMAIL PROTECTED]
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 11:36
To: CF-Talk
Subject: query error
Hello,
Must be having a brain spasm todayI am getting
Possibly not.but its not generating the error. I still get it with or
without the ;
Cheers
Will
-Original Message-
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 12:40
To: CF-Talk
Subject: RE: query error
Do You realy need the ; at the end
This message is usually caused by a permissions problem with the
database. Is it set to read-only?
Also suggest making that thread_time field an ODBC date/time.
Nick
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 14, 2001 12:36 PM
To: CF-Talk
Subject:
Is your OperaID an autonumber field perchance? Trying to insert a value into
an autonumber field is not going to happen.
Steve
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: 14 May 2001 12:36
To: CF-Talk
Subject: query error
Hello,
Must be having a brain
I seem to have figured this out, in case anyone is interested. It is due to
a weird permissions issue with Win2000.
BAsically, the folder that the DB was in had full permissions set to
'Everyone', but I had to add the system profile to this as well, as
obviously as far as Win2000 is concerned,,
28 matches
Mail list logo