>- see footer for list info -<
I know this may appear a stupid question but I have a really weird thing going
on.
I have a stored proc which handles logins for me.
How do I know where the code is fetching the stored proc from?
The reason I ask is that the code is definately NOT pointing at the data that
it should.
I have a feeling that its pointing at an old server. -
The code ....
<cfset sp = "cfpages_Authenticate"><!--- Has the user entered a username and is
it not equal to "" ---> <cfif isDefined("form.entered_username") AND
Len(Trim(form.entered_username))> <cfstoredproc procedure="#sp#"
datasource="#Application.BackendDSN#"> <!--- Apllication ID --->
<cfprocparam cfsqltype="cf_sql_varchar" value="#Application.ID#">
<!--- LoginName ---> <cfprocparam cfsqltype="cf_sql_varchar"
value="#form.entered_username#"> <!--- Password ---> <cfprocparam
cfsqltype="cf_sql_varchar" value="#form.entered_password#">
<cfprocresult name="SP_Results"> </cfstoredproc>
The SP definatley runs ok checked with query analyzer (it always did work) in
fact it does work but if I change any of my data the changes aren't reflected
which makes me think I am looking at the wrong data set (maybe an old server).
Is there a setting in the administrator to make things point at the right
server?
I haven't explained this very well but I hope you get the idea.
Happy new year - Paul_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
>- cfdeveloper Hosting provided by www.cfmxhosting.co.uk -<
>- Lists hosted by www.Gradwell.com -<
>- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
