How connect my project

Dev Shed Forums Sponsor:

Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!

April 30th, 2008, 05:25 PM

dba_raf

Registered User

Join Date: Apr 2008

Posts: 6

Time spent in forums: 3 h 54 m 13 sec
Reputation Power: 0

How connect my project

have folder tom on another machine and I'd like to move in my server.
I created CF data source name = raf
I tried with url
but I get this error (after connection):

Error Executing Database Query.
Data source not found.
The error occurred in E:\Inetpub\wwwroot\tom\afmlogincheck.cfm: line 31

29 : SELECT 1 FROM afm_users
30 : WHERE user_name = {fn UCASE( '#AfmUName#' )}
31 : AND user_pwd = {fn UCASE( '#AfmPWord#' )}
32 : </cfquery>
33 :

This is my afmlogincheck.cfm
[CODE]
<CFQUERY NAME="test_AfmUName" DATASOURCE = "#Cookie.AFMDSN#" >
SELECT 1 FROM afm_users
WHERE user_name = {fn UCASE( '#AfmUName#' )}
AND user_pwd = {fn UCASE( '#AfmPWord#' )}
</cfquery>

<body>

<TABLE>
<tr><td><a href="/afm/afm_hotlist.cfm">
<IMAGE SRC="/afm/afminet.gif" ALT="ARCHIBUS/FM" ALIGN="CENTER" BORDER="0"></a></td>
<td colspan=3 ALIGN=LEFT>
<Font face="Arial" size="+2">
<b>ARCHIBUS/FM Web Central Login validation</b></FONT>
</td>
</tr>
</TABLE>

<CFIF #test_AfmUName.RecordCount# LT 1>
<CFLOCATION url="afmLogin.cfm?var_invalid=true">
<CFELSE>
<CFCOOKIE NAME="AfmUserName" VALUE=#AfmUName#>
<CFIF IsDefined("cookie.AFM_SCRIPTNAME") IS "TRUE">
<cfoutput>
<SCRIPT language="JavaScript1.2">
self.location = "#cookie.AFM_SCRIPTNAME#"
</script>
</cfoutput>
<CFELSE>
<CFLOCATION url="/afm/afm_hotlist.cfm">
</cfif>
</CFIF>

</body>
</html>

this is my application.cfm:

<CFIF #IsDefined("cookie.AFMDSN")# IS "FALSE">
<CFCOOKIE NAME="AFMDSN" VALUE="wcentral">
</CFIF>


<CFCOOKIE NAME="UseAfmSecurity" VALUE="TRUE">
<CFIF #Cookie.UseAfmSecurity# IS "TRUE">
<CFIF #IsDefined("cookie.AfmUserName")# IS "FALSE" OR (#cookie.AfmUserName# IS "") >
<CFIF #IsDefined( "AfmUName" )# IS "FALSE">
<CFIF (CGI.SCRIPT_NAME IS NOT "/afm/afmLogin.cfm") AND (CGI.SCRIPT_NAME IS NOT "/afm/AfmLoginCheck.cfm") AND (CGI.SCRIPT_NAME IS NOT "/afm/reports/projectchooser.cfm") AND (CGI.SCRIPT_NAME IS NOT "/afm/reports/projectset.cfm")>
<CFCOOKIE name="AFM_SCRIPTNAME" value="#CGI.SCRIPT_NAME#">
<SCRIPT language="JavaScript1.2">
self.location = "/afm/AfmLogin.cfm"
</script>
</CFIF>
</CFIF>
</CFIF>
</CFIF>


<CFCOOKIE NAME="UseInternationalDates" VALUE="FALSE">

<CFIF #Cookie.UseInternationalDates# IS "FALSE">
<CFCOOKIE NAME="DateSeperator" Value="/">
<CFCOOKIE NAME="AFMDateFormat" VALUE="mm/dd/yyyy">
<CFCOOKIE NAME="AFMDateType" VALUE="0">
<CFCOOKIE NAME="AFMTimeFormat" VALUE="hh:mm:sstt">
<cfelse>

<CFCOOKIE NAME="DateSeperator" Value="-">

<CFCOOKIE NAME="AFMDateFormat" VALUE="dd-mm-yyyy">

<CFCOOKIE NAME="AFMDateType" VALUE="1"> 

<CFCOOKIE NAME="AFMTimeFormat" VALUE="HH:mm:ss">
</cfif>



<CFCOOKIE NAME="AFMDATEDDDDMMMDDYYYY" VALUE="dddd, mmm dd, yyyy">



<cfset locale = SetLocale("Italian (Standard)")>


<cffunction name="AFM_LSDateFormat">
<cfargument name="AFM_Date" required="YES">
<cfargument name="AFM_DateFormat" required="YES">
<cfif AFM_Date is not "">

<cfset AFM_Date = "#DateFormat(AFM_Date, "dd/mm/yyyy")# 00:00:00">
<cfreturn LSDateFormat(AFM_Date,AFM_DateFormat)>
<else>
<cfreturn "">
</cfif>
</cffunction>


<cffunction name="AFM_LSTimeFormat">
<cfargument name="AFM_Time" required="YES">
<cfargument name="AFM_TimeFormat" required="YES">
<cfif AFM_Time is not "">
<cfreturn LSTimeFormat(AFM_Time,AFM_TimeFormat)>
<else>
<cfreturn "">
</cfif>
</cffunction>

Which file I must modify to connect at my project tom?
Have someone any idea?
Thanks

April 30th, 2008, 06:16 PM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,475

Time spent in forums: 1 Week 3 Days 17 h 7 m 51 sec
Reputation Power: 42

Sorry, but unless you can pare that down to a simple example that demonstrates the problem, I can't help you. I just don't have the time to go through all that code.

__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian.
How to Post a Question in the Forums

April 30th, 2008, 06:24 PM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,475

Time spent in forums: 1 Week 3 Days 17 h 7 m 51 sec
Reputation Power: 42

Also, are you aware that storing any important data in a cookie is a massive security hole, since cookies can be simulated by hackers?

April 30th, 2008, 06:26 PM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,475

Time spent in forums: 1 Week 3 Days 17 h 7 m 51 sec
Reputation Power: 42

Finally, what this is telling you:

Code:

Error Executing Database Query.
Data source not found.
The error occurred in E:\Inetpub\wwwroot\tom\afmlogincheck.cfm: line 31

29 : SELECT 1 FROM afm_users
30 : WHERE user_name = {fn UCASE( '#AfmUName#' )}
31 : AND user_pwd = {fn UCASE( '#AfmPWord#' )}
32 : </cfquery>
33 :

This is my afmlogincheck.cfm
[CODE]
<CFQUERY NAME="test_AfmUName" DATASOURCE = "#Cookie.AFMDSN#" >
SELECT 1 FROM afm_users
WHERE user_name = {fn UCASE( '#AfmUName#' )}
AND user_pwd = {fn UCASE( '#AfmPWord#' )}
</cfquery>

Is that whatever value is defined in Cookie.AFMDSN is not a valid ColdFusion data source name. So you need to set up a data source on the new server if that is the case. And I would strongly recommend not storing the data source name in a cookie.

May 1st, 2008, 02:03 AM

dba_raf

Registered User

Join Date: Apr 2008

Posts: 6

Time spent in forums: 3 h 54 m 13 sec
Reputation Power: 0

Quote:

Originally Posted by kiteless

Finally, what this is telling you:

Code:

Error Executing Database Query.
Data source not found.
The error occurred in E:\Inetpub\wwwroot\tom\afmlogincheck.cfm: line 31

29 : SELECT 1 FROM afm_users
30 : WHERE user_name = {fn UCASE( '#AfmUName#' )}
31 : AND user_pwd = {fn UCASE( '#AfmPWord#' )}
32 : </cfquery>
33 :

This is my afmlogincheck.cfm
[CODE]
<CFQUERY NAME="test_AfmUName" DATASOURCE = "#Cookie.AFMDSN#" >
SELECT 1 FROM afm_users
WHERE user_name = {fn UCASE( '#AfmUName#' )}
AND user_pwd = {fn UCASE( '#AfmPWord#' )}
</cfquery>

If I change DATASOURCE = "#Cookie.AFMDSN#" with DATASOURCE = raf in afmlogincheck.cfm run correcly but after I get new error Data source not found.
How can I change DATASOURCE = "#Cookie.AFMDSN#" with a correct variabile?
Thanks in advance!

May 6th, 2008, 04:59 PM

kiteless

Moderator

Join Date: Jun 2002

Location: Raleigh, NC

Posts: 3,475

Time spent in forums: 1 Week 3 Days 17 h 7 m 51 sec
Reputation Power: 42

You're missing the point: you have to set the cookie to a valid data source name or you will always get this error. Use the cfdump tag to look at the values in the cookie and you'll see that you don't have a valid data source name set.

<cfdump var="#cookie#">

Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > How connect my project

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump

Free IT White Papers!

Accelerating Trading Partner Performance
One in five. That's how many partner transactions have at least one error. That is an amazing statistic, particularly given the extraordinary leaps in innovation across the global supply chain during the past two decades. Download this white paper to learn more.

Competing on Analytics
This Tech Analysis is designed to help identify characteristics shared by analytics competitors, and includes information about 32 organizations that have made a commitment to quantitative, fact-based analysis.

Cost Effective Scaling with Virtualization and Coyote Point Systems
An overview of the industry trend toward virtualization, how server consolidation has increased the importance of application uptime and the steps being taken to integrate load balancing technology with virtualized servers.

Five Checkpoints to Implementing IP Telephony
Implementation planning for IP PBX software and IP telephony has become vital as businesses replace discontinued legacy PBX phone systems. This informative whitepaper outlines five "checkpoints" for any implementation plan that will help make IP communications a successful proposition.

Hosted Email Security: Staying Ahead of New Threats
In the last two years, email has become a fierce battleground between the nefarious forces of spam and malware, and the heroes of messaging protection. The spam volumes increased alarmingly every month, bringing clever new forms of phishing and virus propagation attacks.

More Free IT White Papers!