Search results for query: *

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

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

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

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

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

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

Hi, is there an online guide to ALL the JS events, methods, syntax's? I was surfing the web and came across some methods that I didn't even knew existed. So I was wondering if there was an online guide that showed all of them. Thanks a bunch.

Hi. I was wondering if this is doable in Outlook. We want to send an HTML email via Outlook, and we can do this just fine. The problem lies when we try to use this tag: <a href=&quot;#test></a>, also known as the &quot;jump links&quot;. When this link is clicked it's supposed to take you...

What i'm doing is having 4 forms on one page, 3 of the 4 forms have different e-mail addresses and some fields that need to be answered (the user chooses which form they are interested in filling out), then the 4th form has the contact info. Now is it possible to have any one of the first 3...

Hello, I am starting to learn RegEx, can anyone tell me what this means exactly: re = /^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,})+$/; I know what it's supposed to do, I know it's an e-mail validation, but don't know why there is a '+' after the 'w' and what the string inside the '[]' does...

Hello, need some help with emailing forms. What I would like is, have the user fill out any one of the sections, click the continue button, enter their contact info. and have the form emailed. The form must have the correct section information AND the contact information emailed. I'm using...

Hello, I have a question. Can I pass a variable from one form to another form, on the same page? What I want to do is, on form have the user fill out some general information then when they click a button they go to the bottom where they enter their contact info and submit the form. BUT...

Hello. Not sure if this is doable, but no harm in asking. I have a page that has 3 forms on it, all three forms go to three different email addresses. On top of the page is a drop down list, when you select one option, and hit the button, it takes you down the page to the appropriate section...

Hello, I have 8 fields (fields A-H) in my access file, when I try to sort one field in ascending order, lets say field D, only A,B,C, and D sort ascending, the other fields are left untouched. I thought that maybe the page-break might be causing that to happen, so I changed the page-break to...

Hi, i'm looking a tutorial on how to create a food can. Like the ones you buy in supermarkets. I already know hot to do cereal boxes, but the food can is giving me some problems. Thank-you.

Have an interesting question. What do I do when an Oracle application shows no results but also displays no error messages? I have re-installed Oracle, re-installed the application files and restarted everything. The application used to work just fine, but we were hit with a virus last...