Search results for query: *

I have a drop down box that is dynamically populated with a query. It contains peoples names. I want to be able to select a name in that box, and have it automatically fill in a field below on the form with thier ID number. So every time I select a different employee on this form, their ID...

Hello All, I have a default value in a table I need to be calculated from 2 other fields in that table. here is the SQL query that does it, but I cannot get it to work as an expression in the default value field. UPDATE [ToP] SET [ToP].TOPWeight = ([ToP]![RWAttacker]+[ToP]![RWDefender])/2...

Ok, here's what I want to do, I want to select information from my database specific to the user that has loged into the site. Kinda like this: I log in, it sets a session variable based on my username, I want to have a query that goes somethin like: Select * from table Where userid =...

Ok, here is my problem, I have an application.cfm, and I set application variables, everything is cookie driven,on my testbed the site works great, when I move it to a simulated production server (our back-up site) the site goes into a login loop when you try to log in. The CFM pages are still...

Ok, I have my application.cfm setup, and everything is working, what I want to know is how do I remove the code below, and have it send the user to the URL they originally requested, either via link, or just typing in. As it currently stands, when the user logs in, no matter what link they...

I need to know how to check to see if there is a session active(any session for any user) in a particular CF app, and if not(no users logged in) I want to perform an action to delete data from my DB. How could I set up a CF page to do this automatically, either when a person logs out, or at...

I have a CF chat site that users log in and out of, my problem is two parts, 1) How can I write something in to the logout page so that when the LAST user logs out the database that holds all of their chat is cleared? and 2) How can I set it up, or can I, so that when their text scrolls beyond...

Ok, I've been around the bend with this about 8 million times, someone PLEASE HELP!!!! I have a page that in included in my application.cfm file, via CFInclude, that is to redirect a user based on a database variable. I cannot get it to work at all!! Here is my redirection page code, please...

Ok, I've been around the bend with this about 8 million times, someone PLEASE HELP!!!! I have a page that in included in my application.cfm file, via CFInclude, that is to redirect a user based on a database variable. I cannot get it to work at all!! Here is my redirection page code, please...

I have a CF chat site that users log in and out of, my problem is two parts, 1) How can I write something in to the logout page so that when the LAST user logs out the database that holds their chat is cleared? and 2) How can I set it up or can I so that when their text scrolls beyond the visble...

Ok, I have a problem that is two fold. 1) I have 2 CFIF statements (see below) and I want to use them to send a person to a location based on their membership in a group. So far CF picks up the first CFIF, but not the second. It immediatly goes to the CFElse if the first CFIF is not true. How...

Ok, here's a new twist on a previous post I have not gotten a response on: I have a secure area on my web site, the users are authenticated in the CF page against a database. Session variables are on, and my security model works properly, What I need: I need to have a page where the user clicks...

I have a database that contains my users information, usernames, passwords, etc... In that DB I have two fields that are check boxes, I want to send a user to an FTP site based on which of the two check boxes is checked. One FTP for one box, a different FTP for the other. I have tried to do a...

I have a text formatting problem I need some assistance with. I am trying to bring over a large text field from an SQL database, and I want the data to retain most of it's original formatting. The data is from a CRM software package, and the text is formatted in paragraphs. The problem I have is...

I have a help database that I am pulling a detail field query from and the text in the field is already formatted with line returns, But when I use CFTable to bring the data over it does not wrap the text. I need the text to wrap automatically and still retain it's basic formatting properties. I...

Ok, let me start this by saying many thanks to those that helped me on my last issue, I think I've got that one worked out completly. Now on to my next.... (Do they ever end??) I want the users session to end when the user closes their browser window. Currently I have session timeout set to 5...

I am developing a CF based page that I need to have users log in to, and have different levels of authorzation. I have a database already exisitng with usernames and passwords in it, and I would like to use it as the source location for the login information. I want the users to be authorized to...