links · people · groups · tags | My: links · tags · groups · watchlists · notes login · sign up now! | help · blog
Simpy simpy
 
Michael Shook, member since May 27, 2004
.
Search Everyone: "howto",

Top "howto" experts: synexo, alekseysergeevv, matagaskar, avatar, denilw, jvpigeon,

Groups about "howto": NoviceNotes™ Archive 2006,

11 - 20 of 96 « previous next »   Watch mshook
 
SELECT CONCAT( "[", GROUP_CONCAT( CONCAT("{name:'",`name`,"'"), CONCAT(",email:'",`email`,"'}") ) ,"]") AS json FROM users; CREATE TABLE `user`( `id` int not null auto_increment, `name` varchar(100), `email` varchar(50), PRIMARY KEY(id) ) ENGINE = InnoDB; INSERT INTO `user` (`name`, `email`) VALUES ('Cesar', 'cesar@craftyman.net'), ('Maria', 'maria@gmail.com'), ('Jose', 'j0s3@hotmail.com'), ('Albert','albertpr@yahoo.com');
by mshook 2009-08-10 08:54 via · json · popular · mysql · sql · howto · code · example
http://craftyman.net/mysql-to-json/ - cached - mail it - history
If you've installed the recently released "Service Pack 2" (SP2) for
Windows XP, you have automatically installed a new firewall on your
PC that might be blocking VNC connections. To create an "exception"
for VNC, follow these instructions:

   1. Click Start, click Run, type Wscui.cpl, and then click OK to open 
      Windows Firewall.
   2. Click the Exceptions tab, and de-select the "Don't Allow Exceptions"
      radio-button.
   3. Click Add Port to display the Add a Port dialog box.
   4. Enter port number "5900" or whatever port you've got VNC on that
      PC to listen on (port number = 5900 + "VNC Display Number").
   5. Select the TCP protocol.
   6. In the Name field, type "VNC".
   7. Click Change Scope to view or to set the scope for the port 
      exception, and then click OK.
   8. Click OK to close the Add a Port dialog box.
   
That should do it! More info here:

http://support.microsoft.com/default.aspx?kbid=875357#7
by mshook 2009-07-30 13:15 security · xp · windows · remote · vnc · virtual · network · howto · firewall · helpful
http://faq.gotomyvnc.com/fom-serve/cache/76.html - cached - mail it - history

Materials

Total cost ~ $110 (not counting what I already had lying around) If money is tight there are a few things that can make this cheaper by about fifty bucks:

by mshook 2009-07-09 23:03 howto · power · energy · emon · diy · arduino · how · avr · home · monitor · interesting
http://jarv.org/pwrmon.shtml - cached - mail it - history
<?xml version="1.0" encoding="UTF-8"?>
<Module>
  <ModulePrefs title="simple image gadget" />
  <UserPref name="myname"
    display_name="Module title"
    default_value="Image"
    required="true"/>
  <UserPref name="targetimg"
    display_name="URL of your image"
    default_value="http://www.google.com/images/logo_sm.gif"
    required="true"/>
  <UserPref name="imgwidth"
    display_name="Width"
    default_value="100%"
    required="true"/>
  <Content type="html"><![CDATA[
<!-- Simplification of bashennekam.googlepages.com/google_gadget_image.xml -->
<div align="center">
<a href="__UP_targetimg__" target="_blank">
<img src="__UP_targetimg__" border="0" align="center" width="__UP_imgwidth__">
</a>
</div>
]]></Content>
</Module>
by mshook 2009-07-09 10:55 google · gadget · howto · xml · code · image · simple
http://mshook.appspot.com/z/d4m.htm?/mshook/9+july+2009+b - cached - mail it - history
  1. Use HTTP
  2. Use your verbs
  3. Keep Your URL/URIs Consistent
  4. Use Your Status Codes
  5. Expose (And Accept) Multiple Data Formats
  6. Protect Your Users with OAuth
  7. Don’t Shut Off HTTP Authentication Entirely
  8. Document, Document, Document
by mshook 2009-07-05 22:14 rest · api · tips · howto · example · code · xml · json · emon
http://wonderfullyflawed.com/2009/07/02/get-your-api-right/ - cached - mail it - history
void httpRequest()
{
  byte theByte;

  xPortSerial.print("GET ");
  xPortSerial.print(PHP_PAGE_LOCATION);

  // value0 = 123 and value1 = 456
  // You should change these to be your sensor values or whatever you want to send
  // (see php code if you want to add more values or change the names value0/value1
  xPortSerial.print("?value0=123&value1=456");
  xPortSerial.print(" HTTP/1.1n");
  xPortSerial.print(WEB_HOST);

  while(!xPortSerial.available()) {} // Just loop until available
  theByte = xPortSerial.read();
  if (theByte != 0)
    Serial.println("Passed.");
  else
    Serial.println("Failed.");
}
by mshook 2009-07-02 05:44 arduino · ethernet · server · client · avr · howto · code · php · c · sheild
http://www.glacialwanderer.com/hobbyrobotics/?p=15 - cached - mail it - history
# General Questions

    * Do I need to have a gmail account to use Google Spreadsheets?
    * How can I switch off the autosave option
    * How can I have more than 100 rows ?
    * The format I want is not in the menu. What can I do?
    * How can I create a custom format ?
    * I have opened up a spreadsheet and it is totally black.
    * How does the autofill feature work?
    * How do I hide the gridlines.
    * Can I use names for ranges?
    * How can I make an email address live/clickable?

# Time and date related questions.

    * How can I calculate working times ?
    * How can I get the local time/date for my timezone?
    * How can I format time without hours?
    * How can I format time values without the seconds ?
    * How can I add times ?
    * How can I display time values which are over 24 hours ?
    * How to display the day of the week ?
by mshook 2009-06-28 22:14 google · spreadsheet · function · howto · tips · good
http://gssfaq.googlepages.com/ - cached - mail it - history
.nolist			; We don't want to actually include defs in our listing file.
.include "m168def.inc"	; m168def.inc defines all the pins on the Mega168 so we can
			; use them by their names rather than addresses (not fun).

.list			; We DO want to include the following code in our listing ;D

	rjmp	main 	; You usually place these two lines after all your
main:			; directives. They make sure that resets work correctly.

	ldi	r16,0xFF ; LoaD Immediate. This sets r16 = 0xFF (255)
	out	DDRB,r16 ; Out writes to SRAM, which is one way of accessing
			 ; pins. DDRB controls PORTB's in/out state.

	ldi	r16,0x00 ; r16 is where we'll store current LED state
			 ; 0x00 means all off. This is preserved over loops.
...
by mshook 2009-06-28 19:50 avr · arduino · minimal · blink · assembler · howto · example · code · asm · linux · good
http://www.arduino.cc/cgi-bin/yabb2/YaBB.pl?num=1218921378 - cached - mail it - history
hardware/tools/avrdude -Chardware/tools/avrdude.conf -v -v -v -v -pm328p -cstk500v1 -P/dev/ttyUSB0 -b57600 -D -Uflash:w:/home/michael/arduino/BlinkArduinoLED.hex:i
by mshook 2009-06-27 18:20 example · c · blink · asm · assembler · avr · arduino · code · howto · upload
http://code.google.com/p/tinyprojects/source/browse/trunk/avr/ - cached - mail it - history
You need to tell subversion what mime-type to use. Just use the command:

svn propset svn:mime-type 'text/html' FILENAME

or

svn propset svn:mime-type 'image/jpeg' FILENAME

For more info: http://svnbook.red-bean.com/en/1.4/svn.advanced.props.file-portability.html#svn.advanced.props.special.mime-type

It's also possible to configure your Subversion client to automatically set
each file's mime-type. For example, by modifying ~/.subversion/config to resemble

[miscellany]
enable-auto-props = yes

[auto-props]
*.html = svn:mime-type=text/html

For more info: http://svnbook.red-bean.com/en/1.1/ch07.html#svn-ch-7-sect-1.3.2 
by mshook 2009-06-25 10:47 svn · html · howto · serve · server · google · code · image · jpg · subversion
http://code.google.com/p/support/wiki/FAQ - cached - mail it - history
11 - 20 of 96 « previous next »  
Related Tags
 
- exclude ~ optional + require
Add Dates