[KCFusion] Cold Fusion Server
Hey all: I need to get my hands on a copy of CF Server, and i'm hoping atleast 4.5. I need to find it as cheap as possible and i'm wondering, can you upgrade a CF Server 4.0 to 4.5 for free or does that require a purchase? Anyone know? Anyone got any leads on finding the pro or ent version for dirt cheap? I've been checking Ebay and it looks like i'll end up paying several hundred for it, but I want the best deal I can get. Anyone got an old copy laying around they wanna unload for some cash? Thanks, Robert
Re: [KCFusion] DateDiff in SQL Query
Kory,
Thanks for the reply. I was able to figure
out my mistake. It was my own fault of syntax and not having the quotes
and such in the right place. I've abandoned that query, but I will say
thanks to all who helped.
Thanks,
Robert
- Original Message -
From:
Kory Bakken
To: [EMAIL PROTECTED]
Sent: Monday, August 04, 2003 8:10
AM
Subject: RE: [KCFusion] DateDiff in SQL
Query
You cannot treat
CustomerEnrollmentDateas a CF Variable until you are
outside of that query. The following where clause should get you what
you need:
WHERE CustomerRefer = #Affiliate_ID#AND
CustomerEnrollmentDate between '#DateAdd('d',-7,createODBCDate(now()))#' and '#DateAdd('d',7,createODBCDate(now()))#'
-Original Message-From: Robert
[mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:03
PMTo: [EMAIL PROTECTED]Subject: [KCFusion] DateDiff
in SQL Query
I am running into a problem and I can't figure
out why. I know i've had this problem before with using CF functions
inside of SQL queries, but I can never remember what it was the last time
that fixed it, so I wanted to post this query:
CFQUERY name="getcustomers"
DATASOURCE="x"SELECT CustomerName, CustomerPin,
CustomerRefer,CustomerEnrollmentDateFROM
CustomersWHERE CustomerRefer =
#Affiliate_ID#AND
#DateDiff("w",'#CreateODBCDate(CustomerEnrollmentDate)#','#CreateODBCDate(now())#')#
= 0/CFQUERY
I'm needing to run stats for affiliate programs
and so I want a daily, weekly, monthly view. Datediff in T-SQL didn't
seem to be able to do anything other than generic day, month, etc.
Anyhow, I get the following error:
Error
resolving parameter CUSTOMERENROLLMENTDATE
Obviously I
have the right name, but it bombs right there...if I change around my quotes
and my pound signs, it'll say it's Missing a parameter, Expected 1 or
Expected 2. Anyone easily point out what i've got in the wrong place
or what I am messing up because i'm at a loss. BTW, Affiliate_ID is
from another CFOUTPUT from a query that this is all running inside
of.
Thanks,
Robert
[KCFusion] Monthly Meetings
Hey All: I just wanted to chime in my two cents. I know I am not very active on this list, mainly just to see if I can help out with anyone else's problems and obviously to post some of mine when they occur. I am living in Topeka, and i'm not opposed to traveling to KC for the meetings, but does anyone have objections to having them in Lawrence or Topeka sometimes? I'd be willing to help out with organizing a meeting based in Topeka, finding a meeting place, etc...and i'm not volunteering anyone, but I know Adaryl is here in Topeka and may be willing to help out as well...what does everyone think? I haven't attended any meetings, but I am curious, how many people usually attend? Can we get some chatter going about organizing something? Thanks, Robert __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] DateDiff in SQL Query
I am running into a problem and I can't figure out
why. I know i've had this problem before with using CF functions inside of
SQL queries, but I can never remember what it was the last time that fixed it,
so I wanted to post this query:
CFQUERY name="getcustomers"
DATASOURCE="x"SELECT CustomerName, CustomerPin,
CustomerRefer,CustomerEnrollmentDateFROM
CustomersWHERE CustomerRefer = #Affiliate_ID#AND
#DateDiff("w",'#CreateODBCDate(CustomerEnrollmentDate)#','#CreateODBCDate(now())#')#
= 0/CFQUERY
I'm needing to run stats for affiliate programs and
so I want a daily, weekly, monthly view. Datediff in T-SQL didn't seem to
be able to do anything other than generic day, month, etc. Anyhow, I get
the following error:
Error
resolving parameter CUSTOMERENROLLMENTDATE
Obviously I
have the right name, but it bombs right there...if I change around my quotes and
my pound signs, it'll say it's Missing a parameter, Expected 1 or Expected
2. Anyone easily point out what i've got in the wrong place or what I am
messing up because i'm at a loss. BTW, Affiliate_ID is from another
CFOUTPUT from a query that this is all running inside of.
Thanks,
Robert
Re: [KCFusion] Implementing an Enterprise Single Login
Nicole, Are you worried that the cookie with be unreadable because the site will be 'secure' with a certificate? Because, if you're using session variables and cfapplication it isnt affected by having a SSL certificate. Is that your concern? Thanks, Robert - Original Message - From: Safley, Nicole To: Cold Fusion Listserv (E-mail) Sent: Wednesday, April 17, 2002 4:32 PM Subject: [KCFusion] Implementing an Enterprise Single Login We are attempting to implement a solution that will allow a user to enter our web "portal", log-on, and ,based on that log-on (verified in the LDAP directory), utilize any one of many secure applications. On the front side of things, we plan to set a cookie that will stay with the user throughout the session. My question is then how, as one of those many secure sites, can I decipher the cookie and read the authentication information to determine that the user is in fact valid. Any ideas? We've thrown around the idea of using a Java Servlet to do the decode, and then set the ColdFusion session variables accordingly. This is new territory for me, so any help that could be provided would be greatly appreciated. Nicole L. Safley Database Programmer/Analyst Administrative Systems Project University of Missouri-Columbia [EMAIL PROTECTED] (573) 882-6284
Re: [KCFusion] Implementing an Enterprise Single Login
Nicole, Sounds like you want a .NET/Passport type of setup, much like everyone's favorite Microsoftbut in the fact that there are several sites that refer back to the same authentication server for valid userswhy not look into Bryans suggestion of server variables? Thanks, Robert - Original Message - From: Safley, Nicole To: [EMAIL PROTECTED] Sent: Wednesday, April 17, 2002 4:54 PM Subject: RE: [KCFusion] Implementing an Enterprise Single Login Actually, the majority of the applications are on separate domains, and are not cfapplications. Basically, the idea is to have all entry to any of the applications pass through the proxy server where the user logs in. From there they would be able to access any of the enterprise wide applications which are hosted on various servers throughout our University. Doesn't seem like the server scoping would work in the situation. -Original Message-From: LaPlante, Bryan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 4:48 PMTo: '[EMAIL PROTECTED]'Subject: RE: [KCFusion] Implementing an Enterprise Single Login Do you mean that you want to share a login among multiple cfapplication's? You could use the server scope to store your variable. Using a cookie will cause some issues if you try to access it from a separate domain, server variables will over come that. I would be glad to help you set this up if you need help. Bryan LaPlante -Original Message-From: Safley, Nicole [mailto:[EMAIL PROTECTED]]Sent: Wednesday, April 17, 2002 4:32 PMTo: Cold Fusion Listserv (E-mail)Subject: [KCFusion] Implementing an Enterprise Single Login We are attempting to implement a solution that will allow a user to enter our web "portal", log-on, and ,based on that log-on (verified in the LDAP directory), utilize any one of many secure applications. On the front side of things, we plan to set a cookie that will stay with the user throughout the session. My question is then how, as one of those many secure sites, can I decipher the cookie and read the authentication information to determine that the user is in fact valid. Any ideas? We've thrown around the idea of using a Java Servlet to do the decode, and then set the ColdFusion session variables accordingly. This is new territory for me, so any help that could be provided would be greatly appreciated. Nicole L. Safley Database Programmer/Analyst Administrative Systems Project University of Missouri-Columbia [EMAIL PROTECTED] (573) 882-6284
[KCFusion] OT: EmployersMatch.com
Everyone: I know this is off-topic, but I wanted to pass this information on to anyone out there who is looking for a new career or job, and to any employer who is looking to fill open job positions. Take a look, feel free to let me know what you think, and pass this information on to others. http://www.employersmatch.com/ Thank You. __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
