Recent content by WannaLearn

maswien, your last query was perfect! I still need to test it, which i will do on MOnday now. Thanks.

Ok, so I did this: select email, count(email) as emailcount from users where email in ( select email from users where user_id > 7146375 group by email HAVING COUNT(email) > 1 ) group by email And get back this: EMAIL EMAILCOUNT a@yahoo.com 2 b@NSO.UCHC.EDU 5...

I just tried maswien's idea but got errors stating that the 'group by' was missing, so I added that in: select user_id, email, count(email) as emailcount, FirstName, LastName, Address, Phone, city, state, zip, country, BirthMonth, BirthDay, BirthYear, Gender, IPAddress, gift from...

I am not getting any errors. I get no results at all. If I take out the extra fieldnames then it returns one email and shows it appears 2x. What I need is: 1) any/all email address and the number of times it appears in the table more then once. To answer jbenson001 I am tring to find all...

I want to find all email addresses in my users table that exist more than once, this works: select email, count(email) as emailcount from users where user_id > 7146375 group by email HAVING COUNT(email) > 1 The above code brings back one email and shows that it appered...

Forgot to mention I am using SQL Server 2000

I want to find all email addresses in my users table that exist more than once, this works: select email, count(email) as emailcount from users where user_id > 7146375 group by email HAVING COUNT(email) > 1 The above code brings back one email and shows that it appered twice. Now...

Hi, I am also having some problems when setting up my IPN with Paypal. Any ideas on how to do this? Thanks.

Hi, I have tired the following and does not work, any ideas why? <cfset clubname = replace(retrieveoutputtempfile.clubname, "#chr(38)##chr(35)#174", """","all")> and <cfset clubname = replace(retrieveoutputtempfile.clubname, chr(174), chr(160), "all")> I want to repalce all instances of the...

Hello, we uninstalled ClusterCATS, but for some reason, the uninstall didnt work properly, we even tried to delete registry key that also didnt work. We are using: Machine OS - Win2k SP3. ClusterCats Version : ClusterCats for CFMX Using CFMX 6.1 Keep getting this error on server boot. The...

Hello. No we are not using 'CFX_GIFGD'. I checked our site and the server. Aside from getting that error we also "cluster not found" error. This is soo confusing. Thanks.

The error I get is: Server Error The server encountered an internal error and was unable to complete your request. JRun closed connection. I am getting this now. Usually we restarted CF and the site is fine, but we need to do this ever couple of hours. I just double checked, and seems we...

Hi, everyone! We have been getting constant JRun errors which causes our site to crash. We are running CFMX 6.1 and using JRun 4. We have done everything we can but no matter what JRun errors persists to occur. We stopped and started CF, IIS, the entire servers on occasions, and no matter...

Is there anything wrong with this bit of code? I always get an error when someone tries to pass the date as 2/29/2005 or 2/30/2005. <cfif myYear neq "" and myMonth neq "" and myDay neq ""> <cfset myDOB = myYear & "/" & myMonth & "/" & myDay> <cfif not listfind("4,6,9,11",myMonth) and myDay...

I'm having some trouble creating a session.userid. No matter what I do, its not working. This is what I have: Application.cfm <cfapplication name="abc123" ClientManagement="No" SessionManagement="Yes" SessionTimeout="#CreateTimeSpan(0,0,30,0)#" SetClientCookies="Yes"> <cfset ds = "abc">...