

Videos
Blogs
February 1, 2025
CFSTORED problem
Having a hugs CFSTOREDPROC problem … do I submit it here? Tried to before but got an error.
This is my Cfstoredproc:
<cfstoredproc datasource=”#application.dsn#” procedure=”upMidTempIDAdd”>
<cfprocparam type=”In” cfsqltype=”CF_SQL_INTEGER” dbvarname=”@acbd” value=”7″>
<cfprocparam type=”Out” cfsqltype=”CF_SQL_INTEGER” dbvarname=”@new_temp_id” variable=”new_id”>
</cfstoredproc>
This is the proc
ALTER PROCEDURE [dbo].[upMidTempIDAdd]
@abcd int,
@new_temp_id int out
as
insert into memberResTempID
(drama)
values(@abcd)
set @new_temp_id = @@identity
GO
This is my table (cannot upload???)
This is my error:
Error Executing Database Query. |
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Procedure or function ‘upMidTempIDAdd’ expects parameter ‘@abcd’, which was not supplied. |
Similar Blogs
.png)
[Posted originally in Jan 2021, with the following updates: Sep 2023: added Java
21. Jul 2023: added CF2023 and confirmed state of 2021 and 2018. Aug 2022: minor
refinements. Mar 2022: removed references to Java 12/13 and added mention of
Java 17. Ma...
8 comments
9 likes
.png)
Cloud Firestore is a flexible, scalable NoSQL cloud database to store and sync
data for client- and server-side development. It offers seamless integration
with other Firebase and Google Cloud products. Here are some use cases where
Firestore can be ...
.png)
Someone asked how they could get CF to track the "real" ip address for someone,
when their CF server was operating behind a particular proxy/caching
solution--in their case Cloudflare, but it could happen with any number of such
solutions. Often, suc...
17 comments
6 likes
Upcoming Events
Was this helpful?
Yes
No
By clicking Submit, you accept Adobe’s terms of use.
Find more content on our Homepage