Jamie Briant's Q&A profile

• Windows Live Developer Forums How to do search in sql server database for all properties (with long, lat) that fall within selected map area?

  Would like to create site with similar functionality tohttp://www.realtysouth.com/consumer/listing/ListingSearch.aspx SearchType=map&ListingType=1&ListingSearchID=&RECoJumpSearchID=&action=&defaultlevel= for our site www.mls.ca How to do search in sql server database for all properties (with long, lat) that fall within selected map area thanks steph exactly! is that easy ! Do you have to consider other variables like the zoom level, view type ie. 3d, 2d, birds eye the long1, long2, at1,lat2 would come from the map control boundary, rite same could be applied to drawing a rectangle over the map control (alt + left button drag), rite thanks steph ...Show All

• Visual C# How do i execute the standard email client with parameters?!?!

  hi everyone, im new to this forum. i am stuck in executing the standard mail client from within my c# code. i know, the simplest way is just to execute Process.Start(" mailto:email@blah.com ....") but this works just for the standard parameters. what i need is to give an attachment to the standard mail program. i didnt find a way to get this working for different clients (outlook, eudora etc), but i know there is a way, to do this. when rigth clicking a picture in ie for example, i have the option to send it via mail and then ie opens my standard mail client with the picture as attachment. so does anyone have a clue how i can solve the problem ! and no, i dont want to mail it directly through my ...Show All

• Visual Studio Tools for Office Question regarding creating, saving and emailing EXCEL document

  Hi, I am using C# and VSTO to populate an EXCEL document from a database. I then want to email this EXCEL document as an attachment to a specified number of users. Everything works except when I try to open the attachement. I receive the following error "The file could not be accessed. Try one of the following: Make sure the specified folder exists, Make sure the folder that contains the file is not read-only, Make sure the file name does not contain any of the following characters.......". I tried sending a file, .xls and .txt, that already exists and the attachment opens up correctly. I think VSTO is not properly closing excel before emailing it. Does anyone have any ideas on how to fix this Below is the code: ...Show All

• SQL Server Get datas filtering by only month

  Hello; i want to get some results but only for one month. like that; select * from News where PubDate = month (9 ) i tried use between dates but i got errors because all of months aren't 30 or 31 days ... For example February is 28 days sometime.. So how can i get a month results... thanks now for your helping ... If you only want to have every september rows you will have to do something like this: Select * from News Where Month(PubDate) = 9 HTH, Jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions A little help is needed for getting started...

  I tried to search the previous posts, but couldn't find any help. Could you tell me the exact orders what to do start a new project I'd probably try some C-stuff before going to C++. For example if I want to copy-paste the following code to the editor, and make it work, what to do #include <iostream.h> void main() { cout << "Hello world!"; } Probably new->win32 console application, but what next Or if you could give me a link for a good tutorial for Visual C++ Expression Edition, I would highly appreciate it. Sorry for being a n00b, but I just need this information for getting started. Thanks. 1) File->New->Project 2) In "Project Types", select "Visual C++&qu ...Show All

• Visual Studio Express Editions reverting to default radiobutton checkstates

  I have a dialog with some radiobuttons on it. I want to 'get' the .check value from each when it(the dialog box) loads-before any changes are made. Then when the OK button is pressed, the boolean values are renewed with the new values that the user clicked, but if the Cancel button is pressed, then no matter what changes were made, everything is put 'where it was', so to speak. Two thoughts: 1. You could use normal radiobuttons and store the state in the tag property, instead of defining a new control. 2. Unless they have been separated into several groups only one button can be checked at a time, so you only need to remember which button was checked when the dialogue loaded and set it back again when the Cancel button ...Show All

• SQL Server Attach database failed error 9004

  Hi, i need to attach my db, but i receive this error: an error occurred while processing the log for database 'xyj'. Could not open database 'xyj' . Create database is aborted. (Microsoft Sql Server, error 9004). Can you help me You have two options: You can create an empty database with the same name and physical file layout, shut down the server, swap in the files you want to attach in place of the empty DB files, and start the server. The database should come up in suspect mode. You can then ALTER DATABASE <foo> SET EMERGENCY to put it in emergency mode, and then run DBCC CHECKDB REPAIR_ALLOW_DATA_LOSS. This will pull as much data as possible out of the log to make the database consistent, but may have t ...Show All

• Visual C++ Missing MSVCP71D.dll error during deployment

  I've just recently completed a script writing program using several 3rd party dlls and mfc and compiled it. Upon executing the exe, it reported about 2 missing dlls from the 3rd party ones, but i just copied them to the release folder. The thing is, an error stating missing MSVCP71D.dll popped up on the test deployment pcs. I know its the msvC++ runtime library, but is there some setting or configuration in the project properties or tool option that i'm supposed to specify so that this thing doesnt bug users who dont have the ide and compiler I have defined the include, exe, and library paths for every related dll but the missing file errors still popped up. These files which end in "D" are use ...Show All

• SQL Server Cursor and cursorless performance

  Hi I am doing the Serial Balance Report The data is given in a range format i need to culculate the balance,for your information below is an example Given Stock In Serial Range 10000 - 19999 Stock Out 15000 - 15999 Balance (this is what i calculate out) 10000-14999 16000 -19999 First Loop BEGIN --Given the Stock Out Get the Source Stock In and put it into another cursor(Normarlly just 1 record will found) SECOND LOOP BEGIN --calculation END END Previously Im using 2 cursor to loop and perform the calculation, due to the slow performance i change it to cursorless. I have found that the first 1000 of 55492(2 Month) data its use almost 10 min to finish up the loop ...Show All

• .NET Development Publisher Policy to patch another Publisher Policy

  Is it OK to provide two publisher policy files for a single version of an assembly e.g.: PubPolicy 1.0.0.0 redirect to 1.0.0.1 PubPolicy 1.0.0.0 redirect to 1.0.0.2 How will the CLR loader respond to this Will it pick the latest version It would be nice if it worked this way since it would allow us to provide roll-up patches. I guess the other approach is to provide a redirect for the previous publisher policy file e.g.: PubPolicy 1.0.0.0 redirect to 1.0.0.1 PubPolicy 1.0.0.1 redirect to 1.0.0.2 This isn't quite as nice because it requires the 1.0.0.1 patch to be installed before the 1.0.0.2 patch can be installed. No, the first example will not work. You'll have to remember that publisher p ...Show All

• Software Development for Windows Vista Tablet PC Input Panel fails to recognize any writing after calling SetInputScopes API

  Hi, I found that a call of SetInputScopes API with certain parameter makes Tablet PC Input Panel bad state; it fails to recognize any writing and never recover except closing and re-opening the panel. OS: Windows Vista Ultimate Edition RTM Build Language: Japanese Prosessor: x86 Here is a reproduce procedure. Open the Tablet PC Input Panel. Call SetInputScopes API with passing Japanese character (such as " ") into ppszPhraseList . Select "英 語" (which means "English words") on the panel. Write something. Then the Tablet PC Input Panel never recognize on any window and in any mode. I tried SetInputScopes2 and IEnumString but the result is same. Will phrase list support non-English language in fu ...Show All

• Visual Studio 2008 (Pre-release) Mixed Authentication (Windows and Aspnet)

  Hi, Can anybody share your experience using mixed authentication I need that my client can uses Windows authentication or Username(username and password). A good example is SQL Server that can accept mixed type of authentication, and in the SQL Management Studio we can select the authentication type. I tried like it : < service behaviorConfiguration = " serviceBehavior " name = " Netwatts.suNET.Server.Services.suNETServices " > < host > < baseAddresses > < add baseAddress = " net.tcp://localhost:8000/sunet/www.netwatts.com.br " /> </ baseAddresses > </ host > < endpoint address = "" binding = " netTcpBinding " bindingConfigur ...Show All

• Visual Studio Team System Project Portal and document Libraries

  I am customizing whole process template and currently I am working on Project portal customization. I have changed WssTasks.XML file to (names and descriptions are in Polish): < xml version = " 1.0 " encoding = " utf-8 " > < tasks > < task id = " SharePointPortal " name = " Create Sharepoint Portal " plugin = " Microsoft.ProjectCreationWizard.Portal " completionMessage = " Project site created. " > < taskXml > < Portal > < site template = " VSTS_MSFAgile " language = " 1033 " /> < documentLibraries > < ...Show All

• SQL Server Manual validation of external metadata

  Hi, is there a way to start validation of external metadata manual My problem is this: The package uses a variable as connectionstring for flatfile source, and another variable for the destination table. Running the package gives a warning about external metadata that needs to be updated. Normally I update this data by just opening the data flow, and answering the question for updating with yes. This time that deosnt work, I think because the variable is not set, so there can not be any conflicts with external metadata. I dont want do disable validation, but just validate one time and then save the package. Any ideas Regards, Jan Hi Jan, I dont want do disable validation, but ju ...Show All

• Visual Studio Team System Error: Attempted to perform an unauthorized operation

  Hi I can't generate my build because the' Attempted to perform an unauthorized operation' error is raised In the build machine I have the domain\TFSSERVICE user like administrator and the two directories have full access t these user. Thanks in advance Javier Full descrption of error: Target InitializeEndToEndIteration: UpdateBuildNumberDropLocation BuildNumber='Diary Build_20060906.2' DropLocation='\\calamaro2\test\Diary Build_20060906.2' C:\Archivos de programa\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamFoundation.Build.targets(165,5): error : Attempted to perform an unauthorized operation. Done building target "InitializeEndToEndIteration" in project "TFSBuild.proj" -- ...Show All