Recent content by diggy8

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.