James S. Jan's Q&A profile

• Internet Explorer Development ActiveX / JScript / IE bug

  Tried running the following page and it evaluates all of the conditionals and writes text to the screen for all error cases, to produce the following: "Go back to the base page and click a link! You cannot open this page directly!!EH! WRONG! You didn't specify a valid page! " < html >< head > < script lang ="type/javascript"> <!-- /** * This script is a dirty, dirty hack to get non-compliant IE browsers to display the page * (yes, this includes IE7..). * * Basically, by bruteforcing the browser to read in the Javascript files using * WindowsScript/ActiveX, one by one, and then printing out everything using document.write() * within one <script> tag, IE f ...Show All

• SQL Server TRANSFORM Query

  I'm new to SQL Server 2005. I used the TRANSFORM query in Access to display the data I had stored in columns into rows. I want to do something similar in SQL Server 2005 but it doesnt let me. I have used the same query here, but it gives an error. This is the query I was running in Access and it was working: TRANSFORM Max(Schools.Expense) AS MaxOfExpense SELECT Schools.[FiscalYear], Max(Schools.[FIPS]) AS [Total Of FIPS] FROM Schools GROUP BY Schools.[FiscalYear], Schools.[FIPS] PIVOT Schools.[DataID]; If there some other syntax for SQL Server or it doesnt support this command or what ...Show All

• Visual Studio Express Editions Combo Boxes - Filling from Database

  Hi, Thanks in advance. I was given some assistance with obtaining a single value from a database using a select in VB. I now need to read in a column of unique values and then fill a combo box . ie. SQL = "Select holding_identifier from tbl_holding order by holding_identifier" I need to read the result into a recordset (or the like) and then use it to populate a combo box. I have searched high and low and would appreciate some assistance or direction to a good resource, internet or book on using VB to work with databases. Thanks interesting as the DefaultView should show you the correct values. I've never worked with mysql. I dont know even if using a different connection (O ...Show All

• .NET Development SNMP how can i?

  hello. how can i use winsnmp32.dll in c# project.any sample code in order to use that dll in C# you will have to use interop capabilities provided in C# and you will hvae to port the structures used and declare the methods on ur own and will be a hefty process . how ever you can use the sockets in c# and easily do ur work as compared to that interop procedure . Following is the link that will give you a kick start and i hope it wiull be helpful PLease check this out it can help you to get started http://www.java2s.com/Code/CSharp/Network/SimpleSNMP.htm ...Show All

• Visual Studio Team System Restoring Documents from Document Libraries

  Hello I have two questions about the document libraries on sharepoint / in team explorer of visual studio 1) is there a way for restoring documents in the document library. also if there is a way to restore a complete deleted library. if so, where do i see the deleted 2) is there a way of receving alerts when something on the documents has changed or has been deleted. in the project alerts i can't find anything like this thanks for your help Hello, Unless you are explicitly backing up and restoring those documents, I don't think this is built into existing versions of WSS. Here is an article that talks about a solution: http://msdn.microsoft.com/msdnmag/issues/05/02/RecycleBinforWSS/default.aspx ...Show All

• SQL Server DTS package "Index Not Found Error"

  The Scenario is we have a development machine that is actually a virtual machine and we have a test server. Virtual machine is XP professional based machine and Test Server is Windows Server 2003 based machine. We have created a DTS package in Sql Server 2000 which copies data from 7 foxpro .dbf files to Sql Server 2000 based Database. This package when we test at our Development machine(Virtual Machine) works very fine, but when same DTS package is executed at Test Server it gives an Error, Below is the error which we found in DTS Logs. Package failed because Step 'DTSStep_DTSDataPumpTask_1' failed. ************************************************************************** Step Error Source: Microsoft JET Database Engine Step Error Des ...Show All

• Visual Studio Problem with the office 2003 addin

  Hi, I have created an office 2003 addin with teh code given in the site http://msdn2.microsoft.com/en-gb/library/aa218648(office.11).aspx but the addin is being created and i was not able to get the addin with the frontpage. When i tried to manually add the addin to the front page it is giving an error saying invalid office addin. please help me i have no time...... Thanks, phani In advance Thanks Carlos, Sorry for that previous post i was a bit unstable these days due to this addin.I have tried with this link earlier only.Th eproblem is the same that was given in this page but their work around have not worked for me. May be i have missed something. And regarding posting here as ...Show All

• Visual Studio Team System WssTasks.XML and target filename

  Hi, I'm trying to customising the filename under < documentLibraries > in the WssTasks.xml file. Is it possible to set the filename to the corresponding project Shortly, I want to prefix my files with project name. I tried to use the $$PROJECTNAME$$ variable the is used in the workitems.xml file, but got an error when uploaded the new template. See the example below: < file source = " Windows SharePoint Services\Test\[Project Name] - Test Plan.doc " documentLibrary = " Test " target = " $$PROJECTNAME$$ - Test Plan.doc " /> It it possible to get this automatically when creating new projects The " [Project Name]" is just my ...Show All

• .NET Development Runtime Error

  Hi I dont know if this question is well placed in this forum. If its not, tell me where to put it, no problem. The thing is, im working in MS Access, and making some functions in visual basic to work some data. The number of data is big, like 3.000.000 rows, and when i run a function that try to get data and write it in another table, i get the error 3001 in runtime. Is this happening cause a memory problem How can i free memory in visual basic Txs. I'm having the same problem with the runtime error '3001' in Access 2002 with huge table and a VBA function that is doing inserts. The data is very consistent with other row inserts that went in just fine. Does Access have memory or disk space limitations ...Show All

• Visual Studio Express Editions Can someome PLease help me!! i HAVE no idea how to use this!!!!

  I have no idea how to use C+. I would reall reall like to learn. I have looked at some sites allread but i did not find anthing helpfull. Can someon lead me threw the steps of making a game or how to get started Or if anyone knows a good site I could go to. Thank You - Ryan Hi I an using a book from wrox and it is a very very good book and lerns to make gams and the language as wall if you wnat more info about the book i will gladly help you : ...Show All

• SQL Server Alter View Hangs - Merge Replication SQL 2005

  Background - I have a publication that propigates schema changes. I have a view in which I want to remove a column. Error - Going by what the BOL says, I use Alter View and delete the column from my select statement. I issue the alter view command against the Publication database and it just "churns". I do not get any locking errors or any other type of error, but the statement never completes execution. I watched it run for 10 minutes and cancelled the query. Executing the same statement against a copy of the database that is not being published executes in 1, 2 seconds. Here is what I am doing: Old View: Select table1.record_number, table1.record_date, table1.status_code, table2.status_desc, table2.txt_sort_ord ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Troubles extending the Game class

  I'm trying to create a base game class for my library that my program's game class will inherit from, but am running into some confusing trouble. Intellisense isn't giving me hints for any of the Game class member variables (like graphics or content for instance). If I go ahead and use them anyway, I get errors when I compile. I can't imagine why the following code wouldn't work, but I suppose I am overlooking something. ...Show All

• Visual Studio Express Editions Dynamically adding RadioButton controls to windows forms: Can only get one radiobutton to appear

  I'm trying to dynamically add some controls to a panel on a windows form, including 5 radiobutton controls (to function as a group). The code i'm using to create and add the radio buttons is shown below: 'First i declare a new panel which the radiobuttons will be added to Dim NewPanel As New Panel 'next i declare an array to hold my radiobuttons and a counter Dim NewRadioButton(5) As RadioButton Dim j As Integer 'next i make the radiobuttons For j = 0 To 5 NewRadioButton(j) = New RadioButton NewRadioButton(j).Visible = True NewRadioButton(j).Name = "Radiobutton" + j.ToString If j < 5 Then NewRadioButton(j).Text = j.ToString ElseIf j = 5 Then ...Show All

• Community Chat My creation: Galaxy war (2D game using DirectX)

  Hello there. This is my game: Screens: Selecting a map, lets start on Easy Shooting stars in game, fun multiply backgrounds Lets see my score Download game: Galaxy war Official website (for more information) The game saves progress as you advance (the save is encrypted so forget cheating ;) There are multiply backgrounds and multiply ships. The design of the game is so good that the user can create ships himself. It takes about 2 second to add another level on the map, the information is kept in an array inside the program. I have created a version containing songs in the background (the ending background music was set to Back to the Future theme song) but first: It was a .wav file over 30 mb and I still haven't learned how to play m ...Show All

• SQL Server Differences between mined data and queried data : Association rule

  Dear all, I have a table containing call records, and made a mining model from that table only. The model has 3 columns : calling_number, called_number, and target_operator, using Association Rule algorithm. The key is calling_number, input was operator, and predicted column called_number. The result shows no rule, but there are results with item-set size of 1 (column) and 2 (column). On the top record of the result, SQL Server says there are 1891 support for called_number = 1891 and operator = 'INDOSAT'. I queried the table with this query SELECT DISTINCT calling_number FROM call_records WHERE called_number = '07786000815' AND target_operator = 'INDOSAT'; It returns 2162 records instead of 1891. If I removed the DISTINCT qualifier, SQL S ...Show All