Search results for query: *

Thanks to both of you for your helpful inputs!

atlopes, If I simply modify date.msxsl.xsl to change the faulty statement within function seconds() from return oDate.Seconds() to return oDate.Seconds()/1000 , that corrects the result. Is that not the adjustment I should make?

..."xs:gYear")) ) return oDate.valueOf()/1000; -->Correct (seconds) else if (oDate = _validDuration(arguments[0])) return oDate.Seconds(); -->**Wrong** (milliseconds) else return Number.NaN; }else return Math.floor(new Date().valueOf()/1000); -->Correct (seconds) //current local...

mikrom, That is not my code. It's a snippet from code provided in the implementation of these functions provided June 2001 by Chris Bays in his file date.msxsl.xsl. (You can see a reference to it at http://exslt.org/date/functions/seconds/date.seconds.html.)

Hi atlopes, I looked further and found that we are using the Javascript implementation of these functions provided by Chris Bays 2001-06-12 -- /** <doc:module date="2001-06-12"> <doc:module>exslt:date-time</doc:module> <doc:name>dates</doc:name> <doc:version>2.0</doc:version>...

I'm using the date:seconds function (from the EXSLT date and time functions) to obtain the number of seconds in a duration string, but I'm getting incorrect results. For example, for the following xslt code, I would expect the result to be 85904. Instead, I'm getting a result 1000 times...

...uses an Oracle function as its datasource. Here is the function call that is contained in a Command object in the Crystal report file: select t.* from TABLE(rvx_gtb_voucher('{?ParamType}',{?ResID},'{?EmbarkDateFrom}','{?EmbarkDateTo}','{?Ship}')) t The report runs correctly in the...

No, the report has no subreports. It is a fairly straightforward detail report.

I created a Crystal report (version 11) which has an Oracle stored procedure as its datasource. The stored procedure contains 2 static date parameters. The Crystal report runs fine when run in the Crystal Report software. But when I run it in Crystal Viewer, I am prompted twice to enter the...

I have a Crystal report that has an Oracle stored procedure as its datasource. I've adjusted the stored procedure parameters in the Crystal Report file to contain dynamic values (from either a database view or a Command object query). The report runs correctly when run from the Crystal Report...

Turkbear, Thank you for your input, but I spoke to our head architect, and for reasons that haven't been really explained to me, we are not able to use synonyms. So I still need to know if there is a way to implement the custom table prefix on dynamic parameters. Thanks. Evelyn

Hi Turkbear, I'm not sure what you mean by that. Can you explain it? Thanks. Evelyn

Hello. I've created a CRv11 report against data in an Oracle view. The report contains a dynamic parameter which uses a select query in a Crystal Command Object to provide a list of parameter values. Then I published the report to the Crystal Server. We want the report query to be run by...

I want to display a value from a dataset within my report header. I placed the value in a hidden textbox named "FacilityName" which contains this expression: =First(Fields!FacilityName.Value, "dsFacility") In the report header, the expression is: =ReportItems!FacilityName.Value The problem...

I'm trying to implement a callback in Asp.net 1.1. When I do a simple test it works correctly, so I know I have all the pieces in place. The problem I'm having is in the RaiseCallBackEvent method in the server code. Since there is no postback, how do I access textbox values changed on the UI...

The same select list is contained in each of ~150 - 200 rows within a table. In order to reduce the size of the page, I don't want to populate the list for each row when the page is initially rendered. At the time the page is loaded, I only populate each list with only 1 selection -- the...

Is there a way to programmatically open a select list in javascript? I have a javascript function that populates a select list with new options when the selectlist is first clicked. But then it closes the list, so the user has to click again to open the list to select an item. To avoid the...

I got it to work by assigning a user password to the package.

The first part (about "...DTSSQLStgFlag_Default") is really not an issue. They're equivalent. I tried using "" instead of null. Still get the error. I think the issue I'm having may be a rights issue.

I have a separate login acct in SQLServer that I'm using in making ADO connections to the database. That's the login I'm trying to use when loading the DTS package, not the ASPNET account. Would the ASPNET authority still be an issue? I might have to check to see if the login acct I'm using...