Search results for query: *

I have an OpenRowSet calling an excle spreadsheet and it works fine except one column has numbers as a General format and the numbers that start with 0 have been preceded by an apostrophe in excle show they show. WHen the sql query runs, they come back as null. I have tried casting to no...

I have the following code: Dim result As String Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Set cn = New ADODB.Connection Set rs = New ADODB.Recordset Dim var As String cn.Open "Provider=sqloledb;" & _ "Data Source=server;" & _...

I have 2 tables, and table1 has 2 fields that point to records in table2, one to many. I need to do a query to get one record back but populated with the data from 2 records in table2 and the single record in table1. Any thoughts?

Anyone know of compatibility issues with viewing a 2003 PP doc with an image in 2000? I have 2000 and was sent a 2003 PP and the image is a broken link. (x in corner) Is there a backward issue here?

I am not the greatest at VBA, but we have some guys in our company tinkering with VBA in excel. These are sales guys and not tech's. What are the chances of them ding something stupid and causing big problems if another user uses that excel file. Assume the sales guy will not purposely write...

Can you edit an AD users mobile field thru a web page?

I have an ASP (old classice asp) that runs on a Win 2003 server box. I have set IIS6 to run in IIS5 isolated mode and have "allowed" asp to run in the web services area of IIS. When I use a browser to access any .asp's in that virtual dir, I get "requested resource is in use" and no other...

Is there a way to set perms on the AD object of a user so he/she can modify there own telephone number, cell phone, etc..., but not any other attributes?

Anyone written a c# web app taht queries SMS Asset Management? If so, difficult? Point me in the right direction? Thanks

Our company has mandated a spcific folder be present on all machines. Is it possible to set a web based file download to go to this location? ie, all downloads from the company web site automatically go to said folder, or at least autofill the download popup with the location.

I have written my own docuemtn management system with c# and sql. I have a folder table (folderid, parentid, name, etc..) and a file table (file id, folderid, name, etc...). I then have foldersecurity table (folderid, userid, accesslevel) and well as one for filesecurity(similar to...

In AD, you have a cn which usually is the user's username(it appears to actually be the object name). There is also the userPrincipalName which is the email-like name. In AS there is an account tab in which there is a field: user logon name. Does anyone know what the programmatic name for...

We have an image server that runs on IIS. How can you insert image into a word dock that src to a url??? i.e img src="http://server/imagerserver/big.gif

Is there a way to save a word doc as an html without all of the commented out code as well as the bracketed code ( looks like this: [!if vml] ) ?? Want to display on a web page that is already tied to a stylesheet.

I have a .net app that write html to excel. The files tend be come out around 2mb for 4000 rows plus formatting(they want it pretty). When I openit in excel, it take 2 minutes to open, is this the norm?

I have a table with an ID(autonumber), parent_id, name, etc... fields. It is a one to many relationship with itself. I.E. each rows parent_id points to the ID of another row. (with one exception, the first records parent_id = -1 to designate the root of the tree). How can I query down and...

I have a udf called Split. It was create like so: CREATE FUNCTION dbo.Split It returns a table of values from a comma separated nvarchar sent to it. No matter how I call it, I get Invalid object name 'dbo.Split' Any thoughts?

How can you set a c# tab control to resize with the parent form. The eintire contents of my app are in tab pages and when user maximises, I need it to do so as well. Thanks

Can a VB6 app return a string?

We have an app on a machine on the network that must stay there due to required api's and dlls to run. SQL resides on another machine on the same network. I need to call that app(with params) from the sql agent of tail end of an stored proc. We currently use an rcommand, but network admins...