Search results for query: *

anybody?

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

What is BOL?

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 changed it to "none" cos that's what in my css, and now its working but still bringing up the message "cannot chane focus because field is hidden or invisible etc

<a href="javascript:toggleLayer('commentForm');if (document.ReplyF.message.style.display!="hidden") {document.ReplyF.message.focus()}" title="Reply to this message"> This brings up a 'syntax error'?

Still brings up same error?

That's great and exactly what I needed, except when I click the button again to hide the div it tries to focus it again, and it brings up the error that the form field is invisible. <a href="javascript:toggleLayer('commentForm');document.ReplyF.message.focus()" title="Reply to this message">...

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

Beautiful! Thanks everybody!!

ok thanks for that. I also had to add javscript to the 'window.open'. but now for some weird reason when i click this: <a href="javascript:window.open ('https://secure.registeracompany.com.au/wl-start.cfm?wid=#session.proid#', 'mywindow','menubar=1,resizable=1,width=350,height=250');">open...

Thanks guys I think I'm on the right track but the following doesnt work: <a href="#" onclick="window.open ("https://secure.bob.com.au/wl-start.cfm?wid=123", "mywindow","menubar=1,resizable=1,width=350,height=250");">open open open</a> Am I missing something?

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

Would you be kind enough to post an example scenario of how this would work if the data was normalized?

Thanks Esquared - great simple stuff.

I don't quite follow what you have done there - can you explain it out? "Anything" is an option just like the other 4 - ie, it's doesn't mean "any of the options".

The 5 options on the search form are listed as checkboxes. So you can choose to search for people who have listed either Love, Friendship, Business, Physical or Anything. If you select Love and Friendship, then I want the db to search for members who have put either Love or friendship in. It...