Search results for query: *

I'm new to Oracle, having a SQL Server background. The situation here is that I have three cursors, one brings the client details (name, city, etc), another gets the client sale count, the other gets the client repair count. I broke it into three cursors, from one, because as a single query...

I'm working on security for a website built with ColdFusion MX and an MS SQL 2000 back end. The security consists of a table for ... users roles email lists and tables associating users to roles and users to email lists. I want to pull a list of all the users along with their roles and email...

How can I make a persistent structure without using the session scope?

I'm working on converting an app from ASP and ColdFusion. It's all powered by SQL stored procedures that I can't change and with one of the procedures, the returned columns are dynamic and some of these columns have a space in the name. One such column is "BAR CODE" and when I evaluate it, get...

I'm building a time tracking application and I want to display one work week at a time, default being the current week. Any FAQs out there about this?

I want to pull information from LDAP, then let the user either search within the LDAP query (as in a refined search), or resort the query. But in the interest of saving on load time and server resources, I don't want to pull from LDAP again everytime. How can I save the LDAP query results...

How can I have a <cflocation> tag go a certain frame? I want to have a login form in the main frame and when the user logs in, reload the navigation frame.

My site has an inline frame where all the different pages load and the navigation sits outside the frame. When the user first goes to the site, there's a &quot;click here to login&quot; outside of the frame that loads the login form in the frame. After the user puts in their info and is...

The example Dreamweaver gives for how to use cflogin sets a name, password, and roles. But then it only shows you how to get back the name, with getAuthUser. How do you get back the other fields?

I'm working on an intranet application that let's employees update the status of applications they're working on. It uses session variables to pass the application ID between the different update pages. I defined the session variables in application.cfm and most of the time it works fine. But...

There are two xls files we get from another department every week and these files need to get into the database. We have a few other fixed space txt files that we already have built cfm pages to parse and insert into the database. But reading the xls file isn't as clean. Is there a way to...

We built a departmental intranet website that can have all the content modified through the site by a series of web forms. We'd like to put in change tracking so that if something happens to the database, we'll know who's made changes since the last backup. The best idea we've come up with is...

I have a cfgraph that shows a summary of monthly information for a whole year. I'd like to make it so that you can click on the name of the month in the graph and bring up more detailed information for that month. Is that possible?

The site I'm currently developing has a page where visitors can post updates to projects. There's a space for them to put in their login name, which is the same they use to log into the system (WinNT 4). I'd like to grab the login ID of who is signed into the computer so we'll know who really...

I've only recently started using Access, so this could be an easy fix that I'm just not seeing: I need a report to display the number of projects that are Started or Completed in a given time period and also show how many pending projects are currently in one of four status options. I have the...