Hi Guys
Thanks for your responses.
Jamfool, thank you, I had tried this and it didn't meet my needs as I wanted to round up, but thanks anyway.
Terry, spot on mate, thank you very much.
Digga
Sharing Knowledge Saves Valuable Time!
Hi
Can someone tell me how to round a decimal datatype value up to the nearest .5 in MS SQL.
For example:
1.2 = 1.5
1.4 = 1.5
1.6 = 2.0
1.8 = 2.0
etc., etc.
Many thanks in advance.
Digga
Sharing Knowledge Saves Valuable Time!
Hi
My understanding od CDO for Win2K is that you need to create a Server.CreateObject("CDO.Configuration") object as well.
Digga
Sharing Knowledge Saves Valuable Time!
Does this help?
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q197/6/19.ASP&NoWebContent=1
Digga
Sharing Knowledge Saves Valuable Time!
Hi All
I wanted to share the solution to this issue as it's not documented anywhere so far.
It appears I had a couple of problems.
Firstly, I have cdoex.dll installed, which is cdo for exchange and was installed with office xp. This cdoex.dll is a superset of the cdosys.dll and all cdo calls...
Hi Karmic
Thanks for the reply, I have read the top link before and it didn't help, the second one will not resolve the problem either.
Something I forgot to say is I'm running Win2K Server SP4, so installed dll's kernel32, user32, ole32 are all the SP4 version files.
Thanks again Karmic...
Hi
I have a rather odd problem. When trying to script against cdo, I've found out that cdosys.dll isn't registered with the OS. I have tried to register cdosys.dll using regsvr32 without success, error message below:
-----------------------------------------
DLLRegisterServer in cdosys.dll...
Compliments to codetoad.com and benmeg.com
<%@ Language=VBScript %>
<%
' FTP via ASP without using 3rd-party components
' Ben Meghreblian 15th Jan 2002
' benmeg at benmeg dot com / http://benmeg.com
'
' This script assumes the file to be FTP'ed is in the same directory as this script.
' It...
Hi,
I use this kind of thing on a fornightly basis, but to get the job done it takes a little work.
It's not fully automatic (semi) as you needs Outlook running an user interaction. It's a recurring task, that when marked as complete, creates an e-mail based on a custom form and then e-mail's...
Hi,
I've tried the same as I needed a similar document in the past and the PDF doesn't display, I don't think there are PDF filters in Word. I'm also unsure if it's possible at all as Word calls the Adobe application you have installed to view the file, maybe someone knows of another way around...
Hi Rick,
my understanding is that you cannot run the IIS SMTP service if Exchange has the IMC (internet mail connector [5.5 terminology, not sure what 2000 is) installed, so the CDONTS doesn't know where to put the mail.
Installing Exchange removes the smtp service for IIS.
You may want to...
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.