I DO have # signs for my vairable values and not for my constant values
.... and I continue to get "wrong type/number PLSQL error"
I didnt know that CFPROCPARAMS need a closing / tag. After looking at your code
I added these - but didnt help
This is how my CF code is (with the actual input values)
<CFSET x=2>
<CFSTOREDPROC procedure = "METADATA.get_Metadata"
dataSource = "#Request.Site.DataSource#"
returnCode = "No"
debug="Yes">
<CFPROCPARAM type = "IN"
CFSQLType = "CF_SQL_INTEGER"
value=#x# />
<CFPROCPARAM type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "Column Layout"/>
<CFPROCPARAM type = "IN"
CFSQLType = "CF_SQL_VARCHAR"
value = "FIC_Inherit_Template"/>
<CFPROCRESULT name = "metadataResult" />
</CFSTOREDPROC>
>On 9/23/05, kugh ng <[EMAIL PROTECTED]> wrote:
>
>You need pound signs around your values!! Otherwise you're just
>sending in string values representing the field names. Try this:
>
><cfstoredproc procedure="METADATA.get_Metadata"
>dataSource="mydatasource" returnCode="No">
> <cfprocparam type="IN" cfsqltype="cf_sql_numeric" value="#pageid#" />
> <cfprocparam type="IN" cfsqltype="cf_sql_varchar" value="#myFormName#"
> />
> <cfprocparam type="IN" cfsqltype="cf_sql_varchar" value="#myfieldName#"
> />
>
> <cfprocresult name="metadataResult" />
></cfstoredproc>
>
>Regards,
>Dave.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:219149
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
