Search results for query: *

Thanks lewisp I'm web developer, not a DBA and it was a DBA that suggested I break it up, so I did as told :) I might be possible an index isn't set up properly. In our dev and test environments, the package comes back in at most 1 second, but production it's taking forever to come back...

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

I just came up with this same question. And if the record could be locked, how could it be reopened automatically if the user just closes the brower?

Well I wanted to avoid using a bunch of different scopes, but I guess if session is only used for combat, that'll be fine. There's a 2 hour timeout with my hosting, so it shouldn't cause any problems. Thanks!

I'm actually making a game with ColdFusion, an RPG. I'm using client variables because I'm trying to avoid the timeouts with the session scope. I'm now working on the combat system within the game and want to store the information for the instance of the monster you're fighting in a struct...

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

Thanks webmigit! I modified this some and ended up using the below code which is exactly what I need! <cfparam name="url.datedistance" default="-1"> <Cfset to_day=DayOfWeek(Now())> <!--- If today is not Sunday (1) subtract the difference between what day it is, and 1 ---> <cfif to_day gt 1>...

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?

Well, cfm is cheap and flexible, just not good at all. Ignored customer service emails, the only way to get a problem fixed is to call them long distance... Experthost looks nice and it gets cheaper the more you host, I like that a lot.

cfm-resources.com, based in Florida, has a wide range of plans from $30 one time set up to $100 a month. More space costs $10 year for 100 megs. But they're not at all reliable, they go down all the time and are rather slow.

Thanks for the help. I'm just waiting now for someone to have the problem so I can test these out. Everyone's logging on to different machines, some with WinXP, some with WinNT, IE 5.5 and 6.0, and on two different domains within our network. I thought it might be a problem with all that, but...

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

Could you insert the double quotes, even for a NULL value, so make Steve be &quot;Steve&quot;,&quot;&quot;,&quot;Smith&quot;?

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