Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sorting from several cursors
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...- diggy8
- Post #3
- Forum: Oracle: All versions
-
sorting from several cursors
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...- diggy8
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
comma delimiting queries
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...- diggy8
- Thread
- Replies: 0
- Forum: Microsoft SQL Server: Programming
-
Locking Records
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? -
persistent struct
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! -
persistent struct
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... -
persistent struct
How can I make a persistent structure without using the session scope? -
SQL dB, unknown column names with spaces
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... -
Display a week at a time
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>... -
Display a week at a time
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? -
saving cfldap results
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... -
cflocation to target frame
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. -
Redirect after login, using frames
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 "click here to login" outside of the frame that loads the login form in the frame. After the user puts in their info and is... -
Getting info back from <cflogin>
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 need a very good, cheap and felxible CFM host
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. -
I need a very good, cheap and felxible CFM host
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. -
Lost session variables
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... -
Lost session variables
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... -
Extracting data from a text file (CFHTTP)
Could you insert the double quotes, even for a NULL value, so make Steve be "Steve","","Smith"? -
read, parse, and insert an excel spreadsheet
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...
