48 Hour Game Programming Challenge: Ludum Dare August 28th – 30th

Leave a comment Standard

I just found this site Ludum Dare (as a linkback, haha). Looks pretty cute! Now you can test your uber terriffic game programming skills by competing against other game programing fiends. Looks like they have fairly decent participation. The idea is simple, you’re given a theme and you have 48 hours to create and submit a game for judging.  The contest runs on the August 28th – 30th weekend. Looks like it could be fun. If I can squeeze in time between my other current game projects maybe I’ll give it a try.

ASP Binary Upload FIX: Request.BinaryRead Operation Not Allowed

Comments 4 Standard

IIS also has a maximum request size that will need to be reset if you’re uploading documents larger than about 200kb.

1) Open IIS Manager by going to start > control panel > administrative tools. Right click on the server name > properties. Click on enable direct metabase edit. If this box isn’t checked you won’t be able to edit the metabase.xml file.

2) Open my computer. In the address bar put this and hit enter: %SYSTEMROOT%\system32\inetsrv

3) Find the metabase.xml file and open it with some kind of text editor

4) Search for the line that says AspMaxRequestEntityAllowed. Change that to your max file upload size.

5) Go back to IIS and uncheck direct edit metabase checkbox.

SQL Tutorial: Select, Update & Delete Syntax

Leave a comment Standard

Select Statements

General Syntax

  • SELECT [column], [column], [column] FROM [tablename] WHERE [column] = [value]

Select All Columns

  • SELECT * FROM [tablename]

Limit # of Records Returned – MSSQL

  • SELECT TOP [number] * FROM [tablename]

Limit # of Records Returned – SQL

  • SELECT * FROM [tablename] LIMIT [# from], [# to]
    • this one works well for pagination. You can select results 0 – 30, then 31 to 60, etc.
  • SELECT * FROM [tablename] LIMIT [number]
    • use this one if you just want to cut off the number of records returned

Sum A Field By Status ID

  • SELECT sum([column]), status_id FROM [tablename] WHERE [column] = [value] GROUP BY status_id

Count A Field

  • SELECT count([column]) FROM [tablename] WHERE [column] = [value]

Sort By A Field Ascending or Descending

  • SELECT [column], [column] FROM [tablename] WHERE [column] = [value] ORDER BY [column] DESC, [column] ASC

Complex Where Values

  • SELECT [column], [column] FROM [tablename] WHERE ([column] = [value] AND [column] = [value]) OR ([column] = [value] AND [column] = [value])

Select From Result Subset

  • SELECT [column], [column] FROM [tablename] WHERE [column] IN ([value], [value], [value])

Select From Select Subset

  • SELECT [column] FROM [tablename] WHERE [column] IN (SELECT [column] FROM [tablename])

Inner Join Select All – records must exist in table B and table A matching on conditions

  • SELECT * FROM [tablename] A INNER JOIN [tablename] B ON A.[column] = B.column WHERE A.[column] = [value]

Left Join Select All – records must exist in table A

  • SELECT * FROM [tablename] A LEFT OUTER JOIN [tablename] B on A.[column] = B.[column] WHERE B.[column] = [value]

Inner Join Select All From One Table, Select Fields From Another

  • SELECT A.*, B.[column], B.[column] FROM [tablename] A INNER JOIN [tablename] B ON A.[column] = B.column WHERE A.[column] = [value]

Unions – results and columns must match in both SQL statements

  • SELECT A.*, B.[column], B.[column] FROM [tablename] A INNER JOIN [tablename] B ON A.[column] = B.column WHERE A.[column] = [value] UNION SELECT C.*, D.[column], D.[column] FROM [tablename] C INNER JOIN [tablename] D ON C.[column] = D.column WHERE C.[column] = [value]

Delete Statements

Always do a select statement first to make sure the records you’re about to delete are the ones you want. Also consider any triggers that may be fired as a result of deleting these records.

General Syntax

  • DELETE FROM [tablename] WHERE [column] = [value]

Check Yourself

  • SELECT * FROM [tablename] WHERE [column] = [value]
  • Now replace the text in red with the text in blue below to delete the records you found
  • DELETE FROM [tablename] WHERE [column] = [value]

Update Statements

Make sure you do a select statement before attempting to update records to ensure you only update the records you intended. Also consider any triggers that may be fired as a result of updating these records.

General Syntax

  • UPDATE [tablename] SET [column]=[value], [column]=[value], [column]=[value] WHERE [column]=[value]

Check Yourself

  • SELECT * FROM [tablename] WHERE [column] = [value]
  • Replace the blue section with what’s in red below, then add the columns and values you want to update as seen in green below
  • UPDATE [tablename] SET [column]=[value], [column]=[value], [column]=[value] WHERE [column]=[value]

Smart Tools For Smart Power: Simulations and Serious Games for Peacebuilding

Leave a comment Standard

You can find video/audio downloads from this conference here.

When: July 16, 2009

From: 9:00 AM – 3:30pm

United States Institute for Peace
1200 17th Street NW
Washington, DC 20036

Also available streaming online.

Cost: Free

RSVP: http://smarttools.eventbrite.com/

Please join USIP’s Center of Innovation for Science, Technology and Peacebuilding for a full-day multimedia showcase of state-of-the-art simulation and “serious gaming” tools that promise to transform the way that peacebuilding organizations train, plan and collaborate. Gain practical insights from a diverse range of innovators, including IBM, EBay, the Army War College, Lockheed Martin, and Second Life.
RSVP at http://smarttools.eventbrite.com/ to register and see specific tools being presented. Pre-registration is required. Lunch will be provided.

If you are not in Washington DC, you may also register to watch the live video stream and participate in online discussion.
Sophisticated new technologies are transforming decision-making for corporations and militaries, but the organizations that seek to mitigate violent conflict have yet to take full advantage of cutting-edge simulations, analytics, serious games and other technology-enabled decision-support and collaboration tools.
This session will provide hands-on demonstrations of cutting-edge, best in class “serious games” and simulation tools, some with current application to conflict management and some to inspire new ideas for the peacebuilding community. You will see how governments, militaries, businesses and NGOs are applying the latest online and scenario-driven simulations and 3D virtual environments to sharpen decision-making skills and lay the foundation for more effective operations, negotiation, and cooperation.

Please join us, and be part of USIP’s effort to help the peacebuilding community adapt these state-of-the-art tools to better prevent, manage, and resolve armed conflict.

• Col. Philip Evans – Director, Operations & Gaming Division, U.S. Army War College
• Jason Dechant – Strategy, Forces and Resources Division, Institute for Defense Analyses
• Colin Rule – Director, Online Dispute Resolution, EBay
• Stan Litow – President, IBM International Foundation
• Scott Sechser – Second Life Government Affairs, Linden Lab
• Charlie Hargraves – 3D Immersive Virtual Environment Program, Lockheed Martin
• Jon Wilkenfeld – Director, Center for International Development and Conflict Management, University of Maryland
• Skip Cole – Senior Program Officer, Education and Training Center, U.S. Institute of Peace
• Steve York – Producer, “A Force More Powerful,” York Zimmerman
• Sheldon Himelfarb, Moderator – Associate Vice President, Center of Innovation for Science, Technology, and Peacebuilding, U.S. Institute of Peace
This event is part of the Center’s ongoing “Smart Tools for Smart Power” initiative to identify cutting-edge technologies that may enable peacebuilding organizations to better prevent and resolve violent conflict through data-driven decision-making, information sharing, analytics, and online collaboration.

If you would like more information about the initiative, please contact Joel Whitaker (jwhitaker@usip.org) and Anand Varghese (avarghese1@usip.org).
The “Smart Tools for Smart Power” initiative is led by the US Institute of Peace’s Center of Innovation for Science, Technology and Peacebuilding, co-sponsored by USIP’s Education and Training Center and Center for Post-Conflict Peace and Stability Operations, in partnership with the 3D Security Initiative of Eastern Mennonite University and Lockheed Martin’s Center for Innovation.