Search results for query: *

Hi I am trying to insert into Northwind using bound paramters, the command returns the SQL Server error: Line 1: Incorrect syntax near '?'. Can anybody see what it is that I am doing wrong? I have seen similar code on the web. ... comm.CommandType = CommandType.Text; comm.CommandText =...

This relates to a problem I came across when using the tab key to move the focus around a page of text boxes. All textboxes have AutoPostBack set to true and the page also has SmartNavigation switched on. When you change a value in a text box and tab out, the page is posted back as expected. A...

Hi I do not know if this is at all possible but I would like to be able to copy rows from say an excel spreadsheet and insert them into a datagrid. The datagrid will then be submitted to bulk update a SQL Server table. Any pointers in the right direction would be greatly appreciated John

Hi Can you get to the Contacts folder in end users mailboxes (stored in Exchange Server, not local PC's) using LDAP. If so can anyone give me any pointers as to how to do this. thanks in advance John

Hi Does anyone know how I can go through each Contacts folder in every Mailbox on the Exchange Server and export the contacts to one delimited file (I have administrator access). All of our mailboxes are stored on the Exchange server (ie. we do not use .pst files). I have read about command...

Hi I am sending the output of an asp page to Excel using Response.ContentType = "application/vnd.ms-excel" so that the web page loads and displays as Excel in a browser. I have hyperlinks on the page which I want to use to open a new separate web browser. At the moment the link loads the next...

Hi Do you need to have the .NET framework installed on the PC that you are deploying to? I know that apps are compiled to byte code, but it seems silly if you also need to install .NET on all machines that you may be deploying to; if you compiled a program in C (not through .NET) then you dont...

Hi I have a varchar column holding numeric and text data. How would I be able to just extract the numeric data from this column? Thanks in advance John

Hi I have an array declared as Dim ar() as String This is set by a return from another function: ar = ReturnArrayFunction How so I test it the ar array has been returned any values? Thanks John

Hi I'm writing a menu using xml/xsl. I have an xml like: ... <item> <itemtext>LinkTo</itemtext> <itemaction>http://somewhere</itemaction> </item> ... where itemaction is a link. I want xsl output like <a href=&quot;http://somewhere&quot;>LinkTo</a> My question is how do I write the xsl so...

Hi How do I go about using a word document template as an Outlook form? I am designing a form for that will be used by an end user to request a change in our system. I want to be able to create a Word template that will have a standard set of questions for the user to fill in. This template...

Hi I have 2 spreadsheets, one primary and another secondary. What I want to do is write VBA code in the primary spreadsheet that will set an event in the secondary one. The event will call a method in the primary spreadsheet. I have read a little about WithEvent, am I on the right track? Help...

Hi I have an excel file with 2 worksheet, the 1st is updated with info based on a database, I have managed to copy just the data to the 2nd sheet leaving out any formulas etc. Now I want to be able to save JUST the 2nd sorksheet to a new file. Any suggestions? Thanks in advance John

Hi I have a rules wizard set up to move read receipts to a folder named Read. I would also like to automaticaly mark the item as read in the same rule so that i am not notified with an envelope being displayed in my system tray. Does anyone know how to do this? Thanks in advance John

Hi I am getting this error: error 'ASP 0115' Unexpected error /live/default.asp A trappable error occurred in an external object. The script cannot continue running. But the page has NOT got any external objects via CreateObject, all it uses is request.querystring response.redirect and a...

Hi The Security mode on my SQL Server 6.5 is set to Standard Security Mode. I have read in MSDN that you can override this from an applicatoin by explicitly requesting integrated security over trusted connections. So that for just a once off you can choose Mixed or NT Integrated. My question is...

Hi The Security mode on my SQL Server 6.5 is set to Standard Security Mode. I have read in MSDN that you can override this from an applicatoin by explicitly requesting integrated security over trusted connections. So that for just a once off you can choose Mixed or NT Integrated. My question is...

Hi I am calling a stored procedure (SQL Server 6.5) from an ASP page. The page uses the sa login via ADO and it should update user passwords. The stored procedure works ok from SQL Enterprise Manager but not from the ASP page. It doesnt return any errors Does anyone know a solution? Thanks in...

Hi I am trying to centralise changing user passwords on NT, SQL Server databases. In order to do this in a stored procedure I want to be able to call the dos command line net user username password /domain using xp_cmdshell. When I use just an ordinary command like Dir it works fine but when...

Hi I am writing an ASP page that will centralise updating user passwords. This includes NT4 passwords as well as other database ones. To change NT4 passwords I want to be able to use the command line net user username password /add /domain I am using the Windows Script object created like Dim...