I am trying to build a url to access ms exchange, and some of the folder have spaces. I want the string
"BIS QA EDM Calendar"
to become
"BIS%20QA%20EDM%20Calendar"
I see Server.URLEncode(), but that convert spaces to a plus sign, not %20. Java has a nice URLEncoder class that works great. I...
I want to create the following XML document
<?xml version="1.0" encoding="utf-8" ?>
<root xmlns="http://www.usa.gov" xmlns:minn="http://www.minn.gov">
<Author>
<Name>Joe Johnson</Name>
<minn:Age>47</minn:Age>
</Author>
</root>
The closest I have got is
<?xml version="1.0"...
Well, I found a solution. If you add the paramater -Xrs to the java command, it will reduce the use OS signals. Thus it will ignore the hook that Windows has.
It turns out this was a bug in version 1.3. For some non-light reading and more info, see...
I have developed a program that monitors a MQ queue, I want the application to be running on the machine in the background. I have installed this on a Windows 2000 Server machine.
So I setup a "scheduled task" to start on system start up. When I start the machine, the application...
You could use the like operator, something like
declare @Status varchar(10)
select @Status = '[135]'
select distinct status
from tblTable
where convert(char(1), status) like @Status
the above query would return the status of 1,3, and 5
Because date is not a key field you will need to use sub-queries
SELECT T1.Date, T1.SumOrds, T1.SumValue, T2.SumOrds, T2.SumValue
FROM
(Select Date, Sum(Ords) as SumOrds, Sum(Value) as SumValue FROM Table1 GROUP BY Date) as T1 INNER JOIN
(Select Date, Sum(Ords) as SumOrds, Sum(Value) as...
Try this
SELECT Table1.Date, Table1.Ords, Table1.Value, Sum(Table2.Ords), Sum(Table2.Value)
FROM Table1 INNER JOIN Table2 on Table1.Date = Table2.Date
GROUP BY Table1.Date, Table1.Ords, Table1.Value
ORDER BY Table1.Date
On some of my error handlers I am attempting to output to a log file the current values of different of the variables. The problem I have is determining if I have created the object yet. For example
on error goto main_err
dim bob as client
... <a>
set bob = new client
... <b>...
Nevermind, I fixed the problem
using this code:
Dim CRXSubreportObj As CRAXDRT.SubreportObject
Dim CRXSubreport As CRAXDRT.Report
Set CRXSubreportObj = Report.Section5.ReportObjects.Item("Subreport1")
Set CRXSubreport = CRXSubreportObj.OpenSubreport
For...
I am creating reports with VB6 and CR8 using RDC. These reports will be run at different locations with different database names. I have successfuly been able to change the database for the main report by using this code:
Const sDevDBName As String = "CSTS_Test_DB"
Dim...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.