Recent content by RobertSBoyle

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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?