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!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RobertSBoyle

    external strategy

    There are hundreds of tables after it is broken down into subject areas unfortunately.
  2. RobertSBoyle

    external strategy

    The point is that there are several hundred tables to report on and that it is very tedious to import each table, go on it and modify the aggregate type and Dimension/Measure field for each table that has dozens of rows that require reporting on. Is there a better way of doing this?
  3. RobertSBoyle

    external strategy

    Hi all I have a requirement to add some automation to creating a universe in so far as the import of the tables and their types are concerned. I can do most of this via an external strategy, but I don't see where I can add the specifics to indicate that the field is a Dimension and not the...
  4. RobertSBoyle

    Expired Oracle Password

    Thanks Richard. I have actually created a user with whose sole rights are to connect and to alter user with admin, when the password is expired then this user will log in and change the users password via an Oracle package. We actually store the users in a table at the moment and the...
  5. RobertSBoyle

    Expired Oracle Password

    Hi Guys, Hopefully you can help me ASAP with this one. I am running CF 4.5 and Oracle 8i, we are using the Oracle password system to authenticate users. We are having a problem when the password has expired. How do we change it via CF? The ORACLE command I know is "Alter user blah...
  6. RobertSBoyle

    Populate text box onchange of select

    Got it. I redrew the page as it seemed like the only way out! Thanks
  7. RobertSBoyle

    Populate text box onchange of select

    Hi there, I'm pretty new to Coldfusion and am hoping for some help. I have a form which contains a <cfselect> with a list of names. When I select a name I would like the address details for that name to be displayed in two text boxes. My query for the text boxes gives me an error when I try...
  8. RobertSBoyle

    Running report from web

    Hi there, I am going demented with 2 reports that run fine from Crystal Reports but when I run them from the web all I get is the initial screen and the cursor staying in place as if it is working and retreiving data, but nothing ever happens. No error message, no data, nothing. I have changed...
  9. RobertSBoyle

    Count function

    Hi all, I'm slightly confused here. I have a report which has 2 levels of drill down information on it. The first level drill down to a count of groups, grouped by the group owner and the next level would drill down to the count of people in the group, grouped by the group name. The first...
  10. RobertSBoyle

    Parameters to CR v8 from Coldfusion

    Hi there, I have a report where I am trying to pass two date parameters from coldfusion to Crystal Reports. At the moment I have 2 queries. I have defined the parameters in Crystal but when I refresh the report in the developer it doesn't restrict the results to dates between the 2 dates I...
  11. RobertSBoyle

    Can I use a foreign key where no pr

    No, you need to make a primary key first by using the ALTER TABLE command.
  12. RobertSBoyle

    Tab stripping

    Hi there, I am in a bit of stushi at the moment. I am an Oracle developer who has done a little pro*C in his time but have been asked to look at a c++ program that needs to have a bug removed as the guy who wrote it has left and the other c++ guy is on holiday (wish is were me ;oP) Ok, problem...
  13. RobertSBoyle

    Conversion from string to float

    Hi there, Has anyone come accross the problem of converting a string to a float and losing the leading zero? This affects the decimal places that is used for calculation of a longitude/latitude position. Is there a simple c function which will stop this from happening (I am using atof at the...
  14. RobertSBoyle

    What is wrong with Explorer ?

    Hi there, Recently my install of Win 2000 has started to act funny because whenever I try to copy a file in explorer I get the following error: &quot;The instruction at &quot;0x03083af6 referenced memory at &quot;0x0000000&quot;. The memory could not be &quot;Written&quot;. Click ok to...
  15. RobertSBoyle

    Coldfusion calling plsql package.

    We are trying to call a package that has 24 parameters, but it fails - we cut down the parameters to 15 and it worked - is there a limit on the number of parameters that coldfusion can pass?
  16. RobertSBoyle

    global latatude/longitude

    Hi SamP, it really depends on what you want to do with the data once you have loaded it. We use spatial data without using the spatial option supplied with ORACLE. The spatial option can be useful, but the time and training that may be involved might not be worthwhile depending on what you...

Part and Inventory Search

Back
Top