Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: WannaLearn
  • Order by date
  1. WannaLearn

    issues with "having"

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

    issues with "having"

    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...
  3. WannaLearn

    issues with "having"

    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...
  4. WannaLearn

    issues with "having"

    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...
  5. WannaLearn

    issues with "having"

    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...
  6. WannaLearn

    issues with "having"

    Forgot to mention I am using SQL Server 2000
  7. WannaLearn

    issues with "having"

    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...
  8. WannaLearn

    PayPal IPN

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

    using replace() to get rid of ascii code

    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...
  10. WannaLearn

    ClusterCats

    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...
  11. WannaLearn

    Constant JRun issues

    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.
  12. WannaLearn

    Constant JRun issues

    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...
  13. WannaLearn

    Constant JRun issues

    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...
  14. WannaLearn

    Date

    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...
  15. WannaLearn

    Trouble with session.userid

    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">...
  16. WannaLearn

    validation.

    Hi, is this doable? I want to do a validation to check if the user entered 3 of the same numbers or 3 digits in a sequence, and 4 of the same numbers back-to-back, and 4 digits in a sequence. EX: 111 (do not want) 123 (do not want) 156 (ok) 3333 (do not want) 5678...
  17. WannaLearn

    Alternate Row Colors

    You put me in the right path! I did this, and works exactly like I want: bgcolor="###IIf(form.afield_id EQ rInfoz.afield_id, DE('efefef'),DE('ffffff'))#" Thanks.
  18. WannaLearn

    Alternate Row Colors

    Hello, I would like to change the color of a row after that row has been updated. How can I do that? I know this code: <tr align="center" valign="middle" bgcolor="###iif(currentrow MOD 2,DE('ffffff'),DE('efefef'))#"> changes the row color. But I would like to only color the row on any/all...
  19. WannaLearn

    load images

    Thanks for responding so fast. Will this change the image on refresh?
  20. WannaLearn

    load images

    I was wondering if it's possible to load a different image upon reload? What I want to do is, I have 5 images which I want to change upon refresh. How can I do that? I was thinking of using the randrange() function. But i'm sort of clueless on how to implement that. Any help is much needed...

Part and Inventory Search

Back
Top