Sorry for that!
Hey, I don't know why I didn't see about the mapping thing, that the dots means
the level of the folder.
Still funny, but I was able to make some pages to work after deleting and
uploading the ajax.cfc from the root to the components folder. Still a mistery,
but it's working so far.
I have been looking into my code for another page that is partially working.
The parts that are working are making ajax calls to a function and the function
has a query that executes a SQL command. No big deal. Now, other sections of
the page don't work because I am using a function that calls a SP called
sp_updateBasePKG.
Locally this work, but at the server it gives me the following error:
"The system has attempted to use an undefined value, which usually indicates a
programming error, either in your code or some system code.
Null Pointers are another name for undefined values."
You might have seen this error before, and I believe this is what is making my
ajax calls to crash. I notice this error because I have one button that it used
to upload files to the server, well, this button calls the same function that
calls that SP.
Here is the function:
<cffunction name="updatePKG" returntype="any" hint="Generic update">
<cfargument name="in_table" type="any" required="false" default="">
<cfargument name="in_column" type="any" required="false" default="">
<cfargument name="in_new_value" type="any" required="false" default="">
<cfargument name="in_where" type="any" required="false" default="">
<cfset var loc = structnew() />
<cfstoredproc procedure = "sp_updateBasePKG"
datasource="#Application.Global.dsn#" username="#Application.Global.dsnUN#"
password="#Application.Global.dsnPW#" >
<cfprocparam type = "IN" cfsqltype="cf_sql_varchar"
value="#arguments.in_table#">
<cfprocparam type = "IN" cfsqltype="cf_sql_varchar"
value="#arguments.in_column#">
<cfprocparam type = "IN" cfsqltype="cf_sql_varchar"
value="'#arguments.in_new_value#'">
<cfprocparam type = "IN" cfsqltype="cf_sql_varchar"
value="#arguments.in_where#">
<!---cfprocparam type = "OUT" cfsqltype="cf_sql_varchar" variable="results"--->
</cfstoredproc>
<!---cfset loc = {
r2 = "#results#"
} /--->
<cfreturn 1>
</cffunction>
I commented out the OUT parameter because that is where I was having the
problem, but now is the one above "in_where" that is causing the error.
Any thoughts on that?
Thanks again
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323664
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
