Search results for query: *

I have an important CFHTTP which is a post, submits from my site to other site form, scrape results and returns to my site. It was working fine until a week or so ago when i started getting "Connection failure". I tested CFHTTP's on other web addy's and it works fine, but when I try it on the...

I have this line of code in a proc: CASE WHEN DATEDIFF(n, mbx.date_received, GETDATE()) BETWEEN 0 AND 10 THEN 'DATEDIFF(n, mbx.date_received, GETDATE()) min ago' END as USE_DATE How can I get the DateDiff function to output the actual value when inside quotes? At the moment it just outputs...

I would like to output messages from my select statement in my proc based on the value in my datetime field. ideally I'd like to check if the date in the field is less than 30 mins from now then say "X minutes ago", if it's more then i say "Less than 1 hour ago", more than 1 hour i say "X...

I have a table where I need to insert the primary key field after it has been inserted into the same row (but another column). I could do an Update after the Insert obviously using SCOPE_IDENTITY or IDENTITY into the other column but I'd like to do it within the same insert if its at all...

I have a div which is hidden when the page is loaded. When the user clicks a link it shows the DIV and inside the DIV is a small comments form to complete. The comments form has two fields, a subject and a message field. I want the subject (input type text) to have focus (ie, cursor in field)...

I'm building an affiliate system on my website. The users get to choose an image to put on their website and they select and paste the code etc. The thing is, I need the link of the image to click and open up a popup window with height/width etc all defined by me. I just want the user to...

I want to add the functionality of my website to remember logged in users. So when someone logs in and clicks "remember me" I want them to be automatically logged in when they come back to the site. I know how to do this with cookies etc and checking in the application.cfm if they're logged in...

I have a table of members which has 5 tinyint fields labelled Love, Friendship, Marriage, Casual, Anything (these are options that the member might be looking for). A member can select one or all of them (if it's selected it's 1, if not it's 0). I'm doing my search proc at the moment and am...

I have a Coldfusion website running SQL 2000 and I've got some pages that hang (forever) until I reboot the server. The more of these pages that hang it ends up stopping all requests to my website until I restart everything. It's becoming quite annoying! There are 3 pages on my site that are...

I have a CF site with SQL server. I have installed Fusionreactor to monitor the site real time. For the past 2 weeks my signup page (and one other) has been locking up and running forever in my Fusionreactor. If too many pages do this the server ends up jammed. The web server memory is fine...

I have two pages on my website which for some reason just completely lock up. One is worse than the other, it's my sign up page. The proc is below: declare @regionnamt varchar(40) set @regionnamt = (Select FullRegName from Regions Where RegionID = @Region) Insert Into Members (Country...

I have a dedicated server and I need to buy SQL Server 2000 for it. It's just one processor hosting a few sites all using the DB. I've done some searching and found lots of different types (standard/enterprise), and the processor/cal options. It's all very confusing! What would I need for my...

Can I not create more than 1 clustered index on a table? I have a table with the primary key ID.. and I have another column called memberid which I often use in joins etc on the members table. I want to create an index on this memberID column and I thought a clustered index was what i was...

I've got a dating site which is starting to buckle under some heavy load. I have a few problem areas but this code in particular is slow. SELECT Smiles.Viewed,Smiles.SID, Members.MemberID, Members.Nickname, Members.Age, Members.Country, Members.Region, Members.Gender, Members.Looking...

I have a table of members with a country column in it (tinyint). The country column will either 1 through to 7 depending. I want to do a query which will order the members depending on the country the user is in (I have 7 domains for 7 different countries). So if someone is at my Canada site...

I have a varchar field which has 88 numbers in it.. it might look like this for instance: 111112221121221222 etc. Each number will either be a 1 or a 2. What I need to do is build a query where I pass in a number, let's say "20", and I need to bring back results where the 20th number in that...

I have a url which looks like this: /f-search_results.cfm?type=online?page=1. I've been able to write a rewrite rule for it: RewriteRule /search/singles-(.*)\.htm /f-search_results.cfm\?type=$1 [I,O] this works for "type=online" part of it, but how do i modify the rule so that the "page=1"...

Hi have a brand new server with 1and1.com, and I logged in today via remote desktop to find 2gb had been wiped off my disk space. I searched in my "Websites" directory where the websites are hosted and found lots of random files and folders containing 14mb .rar files called "dr.x" and "jeepers...

I have a dedicated server with a hosting company. For a while now my Inetpub/mailroot/queue folder has been filling up daily with thousands upon thousands of .EML files (email messages). They are not being generated from my website. I've opened the email files up and they contain garbage...

I need to dynamically create .pcl files on my website. I'm running CFMX. Does anyone know the best way to get this done? I've looked around and can't seem to find much.