Search results for query: *

I am trying to convert this to an update statement in which I want to update tb2.effdt = tb1.startdt where tb2.type = 'zenster' and tb2.effdt< tb1.startdt select distinct * from Table1 tb1, Table2 tb2 where tb1.id=tb2.id and tb2.type='zenster' and tb2.effdt< tb1.startdt; I have tried...

How can I flag (true or false) if there are two @ symbols in a cell

I have two date parameters DT1 and DT2. If I enter two dates - return data from within those two dates. If no values are entered in the parameters, return everything. Not sure how to incorporate both.

I have a pdf file on my web server. I want to be able to have the user download the pdf file from an asp page - a link. For security purposes would it be possible to hide the actual path of the file on the web server, etc... C:\temp\test.pdf.. On the asp page have Download File Here.. When you...

I am using Crystal Reports 10 Report Structure: GrpHeader1a - d (ClientLastName) GrpHeader2 - Registration Number In GrpFooter1d - I have New Page After This put a new client on each page. However if the client starts on a even page number I want to insert a blank page so that the client...

I keep getting this err on our server logs. Can anyone help me out here: Rule Details:- Log File Type - application Event Type - Error Event Id- 35301 Source - ANY Category - ANY User - ANY Check for the String in Description - ANY The Following Events Matched with the Rule Source : Event...

I am checking the status of a scheduled report. I need to use a loop in which I check the status of the scheduled job when the "status" is = 1 then exit the loop... I tried this and it did not work it stays in the loop.. Dim infoObjects Set infoObjects = IStore.Query("Select Top 1* From...

Ce 10 I am using the ASP COM SDK to schedule reports using the smtpoptions. The requirements are to send the report VIA email - this is successful. The other requirement is to send only the link and not the report. I am able to send the link but the attachment of the report is included in the...

I have a dictionary object and would like to store the following items into a session variable : dicParams.Add "FName", objElm.nodeTypedValue dicParams.Add "LName", objElm.nodeTypedValue dicParams.Add "@City", objElm.nodeTypedValue How can I do this?

I am scheduling a report VIA email using ASP and CE10. In the body of my email I put this %SI_VIEWER_URL% which will send a hyperlink to the report in the email. This all works great but when I click on the link in the email I get prompted with the Viewer Log On screen. Is there any way to by...

I am successful in scheduling a report directly using the CE 10 CMC. However when I try using my asp code provided in the SDK, I keep getting: address error. CrystalEnterprise.Smtp: SMTP_E_MAILBOX_UNAVAILABLE_2(550) Any ideas?

In Access 2000 in a module I have the following: Function Tes(pTd1 As String, _ Optional pTd2 As String = ",") _ As String I want to replace the "," with a carriage return. I run a query that calls this fucntion... I know this is simple but just cannot figure it out...

Access 2000 Table1 Columns: -ContactName (text) -Notes (text) Example: John Smith Test1 John Smith Test2 John Smith Test3 Dave Brown Test1 Using a query how can I group by ContactName and conactenate the Notes into 1 column Example: (one record) John Smith Test1 (carriage return) Test2...

In Crystal can we use conditional formatting. I have a string and would like to make specific phrases bold in a string ie: If {Table1.Memo} in ("<" to ">") then formula = crBold

On my report I have a string value with a (test). I need to take the value between the "(" and ")" and store it into a stringvar.. How can I do this so that the value in stringvar var1 is test?

CR10 SQL 2000 Stored Procedure I added two new parameters and I reference the parameters in a supress condition. When I do a refresh the two new parameters are not in the list... Why???

Are there any known issues using a string containing a comma? We are using ASP to pass parameters from a free form text box to a Crystal Report. We use escape which changes the comma to a %2c and then unescape will decode as comma but anything after the comma does not appear.

We are using CE10 on a Windows 2000 server. We use a custom app that uses the RAS and we schedule job using the job server. What maintenance should we do to the server to keep the app up to par. Someone mentioned to me about the temp files that are built up...

Using FileSystemObject how can I display the names of the files in the subfolders within that folder and include the subfolder in which the file is located. IE: Folder structure: Parent Folder("c:\temp") Subfolder1 Subfolder2 test.doc code.doc test1.doc code1.doc test2.doc code2.doc output...

I want to take record where empname = 23 from db1 and insert it into db2. Both db have the same structure... How can I do this through a script to run through query analyzer Database: db1 Table: table1 column: empname to Database: db2 Table: table1 column: empname