Search results for query: *

I'm unable to drop a DLL into ComponentServices since the install of SP2 on our Windows 2003 server. I get the following: An error occurred while processing the last operation. Error code 80131700. The event log may contain additional troubleshooting information. It appears that it may be...

*red face* I looked closer at my function and discovered I had my return variable declared as a varchar instead of an int. Thanks anyway.

I have a pagehit function returning the error: "Syntax error converting the varchar value '*' to a column of data type int." The function does a count() on an integer column (pagehits), with a where clause matching pagename, and returns the integer pagehits. The function is actually...

Transact SQL, I guess... I'm building a dynamic querystring. I'm trying to compare a date provided by a user with a date/time stamp stored in the database -- I want to disregard the time and look only at the date itself. I know there's no DATE_PART_ONLY_OF -- I was simply trying to show where...

I'm trying to do the same thing, essentially. Here's the gist of my SQL: SELECT * FROM TABLE WHERE DATE_PART_ONLY_OF(datetime column name) = '09/20/2002'; I tried format(columname,'mm/dd/yyyy') and it errors on me, that format is not a recognized function name. Thanks for any help.

ddnvleu, you need to add a line "prompt" in your text file after the connection is established to toggle off the prompt mode. If you write the line again later, it will toggle back on.

I'm using this to do FTP, but I need to return a file listing (results from LS command)... how might I do this? Any ideas?