Derek at Potters Clay's Q&A profile

• SQL Server Transact-SQL equivalent of MySQL LIMIT

  In mySQL for example i could have: ORDER BY ID DESC LIMIT 5,25 where it would start from 5'th row found and return up to 25 rows. How do i achieve the same in Transact-SQL The LIMIT 5, 25 part. Now i have this but its complaining about line 23 near 'WHERE'. Any ideas SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE getMessages @username varchar ( 10 ), @startFrom int AS BEGIN SELECT ID , Sender , Subject , Date , New , Unread FROM ( SELECT ID , Sender , Subject , Date , New , Unread , ROW_NUMBER () OVER ( ORDER BY ID DESC ) [RowNumber] FROM Messages WHERE Username = @username ) WHERE ...Show All

• SQL Server Dependant assemblies in CLR

  This is related to one of my previous posts. I am running a CLR stored proc that goes to an EDS (Novell) server with LDAP and returns records into a SQL table. I am using the Novell ldap library. I want to do this with SSL so my code referneces the Mono security library as well. However when I make the call to the stored proc to run in SSL, I get an object not found error. I do not think that the the Novell assembly can "find" the Mono assembly. Two points: 1/ I can do the SSL if I run it as an asp.net page (so I know the SSL works) 2/ The proc runs and pulls all the records in non-SSL (so I know the proc works) Any ideas Thanks, BIG That is the solution for a different problem where Xml Se ...Show All

• Visual C++ about dll problem,thank:)

  about dll problem,thank:) i have two file a static dll file ,another static Exe file i think Exe call List Class in dll,but.......... ************************static dll****************************** <<<<<List.h>>>>>>>> #pragma once class AFX_EXT_CLASS List:public CListCtrl { public: __declspec(dllexport) List(); __declspec(dllexport) ~List(); __declspec(dllexport) void CMCreate(CWnd *pWnd); DECLARE_MESSAGE_MAP(); public: __declspec(dllexport) afx_msg void OnNMClick(NMHDR *pNMHDR, LRESULT *pResult); }; <<<<<<List.Cpp>>>>>>>>> #include "Stdafx.h" #include "List.h" List::List() {} List::~List() {} BEGIN_MESSAGE_MAP(List ...Show All

• Visual Studio Team System Exporting files with check in date

  Hello, We have already found out that files always (and not customizable) carry the current date and time when they are fetched with a "get" from the Team Foundation Server. Due to this, we run into the following problem: Some headers from other teams are only available as plain files on a deployment server, along with the corresponding binaries and libraries. They are built each night and then exported to the deployment server (ordinary file server). In order to get it straight, the nightly build server deletes everything first, and then gets the sources. After the succesful build, the headers, libs and binaries are copied to the deployment server. This means that the headers have a new date each day. Which in turn means that th ...Show All

• Visual C# Unmanaged to managed code

  I have funtion wich was written in C++ and has the signature like this : "DWORD XPTO(BYTE **aux)" I want to use it within C# code but the function has to be declared like: static extern xpto( aux )), I dont know how to translate it!!! Can Anyone help Thanks a lot! Barbara   First : Thanks for all the help.   What is returned by char** aux is a photo buffer pointer and I am not understanting how can construct the picture from this value. I have applied several functions in order to get this info from IntPtr (and return the picture) but without any kind of sucess! Can someone please help again with this one.   ...Show All

• Visual Studio Express Editions Can I Move The Program Files?

  Visual C++ Express installed under E:/Program Files when i want it to go under C:/Program Files. How can I move it from my E: drive to my C: drive I don't remember the installation asking for an install path. I figured that the registry had something to do with it, that's why I asked before I went and started moving files all willy-nilly. I uninstalled and reinstalled it to the correct place. It did in fact ask me for an install path when I reinstalled. I think the thing was that I had previously installed VC++ EE on my E:/ and didn't remove the application data and/or registry data before reinstalling this time and it remembered. Thanks for your help, guys. ...Show All

• Visual C# Windows enumeration (in C#)

  How can I enumerate windows How can I get handle of window Is it possible Thanks for any answer or links on net. S I'm assuming you mean enumerating windows running on the desktop/Windows level and not just those within your own application... if that is the case, take a look at this Code Project article which has some code to do just that, ...Show All

• Visual Studio Express Editions how can i program this! using vb?

  1.) ********** ********* ******** ******* ****** ***** **** *** ** * 2.) * ** *** **** ***** ****** ******* ******** ********* ********** I already do that! thanks! like this structure * ** *** **** ***** and ***** **** *** ** * but i don't know! what to do this structure! ***** **** *** ** * and * ** *** **** ***** ...Show All

• .NET Development System.Collections AND System.Collections.Generic

  other then the Collections.Generic are strong typed, is there any difference between them will Collections.Generic perform better what the benefit using Collections.Generic thankyou Another benefit relies in using structures (classes inheriting from System.ValueType, such as enum, int, bool, ...) with generic lists/collections. If you used the old ArrayList, structs needed to be boxed when you added them to the list. Boxing means that they have been packed in an instance of System.Object (wrapped by that instance). They have also been unboxed by the runtime on each get from the ArrayList. This was very time consuming but needed to be done because structs are managed in a different way then classe ...Show All

• SQL Server Row yielded no match during lookup

  I have configured a lookup transformation to 'redirect error' all no-matched rows to a text file using the flat file destination. Now I want to send the same text file as an email.I Know email can be send using the send email task but i need to know where to place send email task and how to check whether flat file contains the error data. Can we use the send email task on eventhandler and invoke the same in case of such error "row yielded no match during lookup" so that we can send the such non matching rows as an email. Or else any other way to send an email after generating the text file ocntaining the non matching rows. Please suggest using steps or example There's likely t ...Show All

• SQL Server Need Performance Tips - Zip Code Locator

  I have a stored procedure used to lookup ad's similar to ebay. We want to allow the customer to search based on their zip code in relation to the items location. This query works but it takes too long. We only want to return the top 100 records. It also uses indexed searching for the main search terms. Any ideas what we can do to improve performance CREATE PROCEDURE Search @SearchText varchar(200), @CategoryID int = Null, @TxtDesc bit = 0, @PriceMin money = 0, @PriceMax money = 250000, @ZipCode varchar(5) = Null, @Distance smallint = 0, @ManMul int = 1000, @ModMul int = 1000, @TitMul int = 100, @DesMul int = 1 AS BEGIN DECLARE @CenterLat float DECLARE @CenterLon float -- Earth Radius In Miles DECLARE @EarthRadi ...Show All

• Visual Basic How do i fix to make this code work properly?

  This is my mainform's code This is my main form's code Imports System.Runtime.InteropServices Imports System.Text.RegularExpressions Imports System.Threading Public Class Form1 Public Delegate Sub _idDelegate( ByVal found As String ) Public Delegate Sub _postDelegate( ByVal html As String ) Public Delegate Sub _linkDelegate( ByVal link As String ) Public _onID As New _idDelegate( AddressOf ID) Public _onPost As New _postDelegate( AddressOf Post) Public _onLink As New _linkDelegate( AddressOf Link) Private Sub link( ByVal link As String ) End Sub Private Sub Post( ByVal html As String ) End Sub ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. 1280x720 For Space War??!?!?

  OK... maybe it's just me but... The SpaceWar starter kit requires that the machine is capable of 3D display of 1280x720 isn't that a little bit big for normal users For an actual game, yes that would be appropraite for the 360 and high end systems. But SpaceWar is supposed to be a starter kit demonstration for students and beginner programmers to learn with, most normal notebooks which students around my area carry only supports displays of up to 1024x720 and with rudimentary graphics acceleration. The aging Toshiba M200 which I use have a GeforceFX but it also can't muster up a 3D display of 1280x720 (code died trying to run). I changed the code so that the window would be smaller, but the whole game seems to be hard coded to wor ...Show All

• Visual FoxPro Update AND Insert SQL text field (over 256 characters) into FoxPro memo field using OLEDB - VBScript version

  I've seen many responses in the various 200+ documents I've reviewed to solve this issue, but I can't seem to find an example that actually works. Just a simple example of using VBScript to insert more than 256 characters into a FoxPro text field. I'm using SQL DTS ActiveX Script task to export data from SQL 2000 into FoxPro (there are many reasons for using this method as I have various tables to update and people to notify) I'm using the latest FoxPro OLEDB provider. I've attempted using a recordset and updating using appendchunk. That didn't work. I have to test each line for an error and I originally thought that there was an issue with the appendchunk method, but I discovered that none of the recordset type ...Show All

• Visual Studio Express Editions Can you convert this code?

  Can somebody convert this code to VB for me I would be very greatful. http://www.codeproject.com/useritems/LoggedOnUsersPart2.asp Thanks...     For a fee   For consulting services There's a lot of expertise here but I don't think anyone wants to do what you are being paid to do.   ...Show All