Ask a Question related to Coldfusion Database Access, Design and Development.
-
supportcenter #1
Re: Results of update in CFQUERY
And what about delete? Seems like delete does not return anything neither.
supportcenter Guest
-
Cfquery Update Syntax Suddenly bad???
The following code has been working for 2yrs or so; And suddenly I get the following error; Error Executing Database Query. Syntax error in... -
CFQuery displaying old results?
No matter what i try, my cfquery is displaying old results. I've tried inserting cachedwithin="#createtimespan(0,0,0,0)#" into the cfquery, but it... -
MS Access UPDATE not updating with cfquery
Three columns will update (GolaCalls, GoalContacts, and GoalAppts). However, the two columns FirstName and LastName remain unchanged even if there... -
CFQUERY - Calling results from one to supply inputs foranother
Here's my code... ------------------------------------ <cfquery name="Recordset1" datasource="DB1"> SELECT * FROM dbo.tbl_Main LEFT JOIN... -
Error executing a cfquery update statement. PLEASE HELP
I have been over and over this. I am trying to update a simple table. I took this script from the same server using a different DSN. I keep... -
CF_Oracle #2
Re: Results of update in CFQUERY
It's similar to UPDATE just convert DELETE query to SELECT and run before deleting.
CF_Oracle Guest
-
mxstu #3
Re: Results of update in CFQUERY
If you're using sql server you might be able to use something like @@ROWCOUNT with a SET NOCOUNT ON statement to return the number of rows affected by an update or delete operation.
mxstu Guest



Reply With Quote

