Escape Sequences Used In MySQL

From the MySQL website:

For input, if the FIELDS ESCAPED BY character is not empty, occurrences of that character are stripped and the following character is taken literally as part of a field value. Some two-character sequences that are exceptions, where the first character is the escape character. These sequences are shown in the following table (using “\” for the escape character). The rules for NULL handling are described later in this section.

\0 An ASCII NUL (0x00) character
\b A backspace character
\n A newline (linefeed) character
\r A carriage return character
\t A tab character.
\Z ASCII 26 (Control-Z)
\N NULL

For more information about “\”-escape syntax, see Section 8.1, “Literal Values”.

Posted under Freeware, MySQL

Problem: unprivileged scripts cannot invoke the Cut, Copy, and Paste commands in the Mozilla Firefox rich text editor

I had a problem pasting text into a rich text editor using Firefox 3.0 on Windows Vista. I found a way to allow it to work.

This may help, however I’m not sure about the security implications involved in changing this setting:

Open a new tab, and go the URL “about:config”
Find the setting “noscript.allowClipboard” and set it to “true”

This worked for me, hopefully it helps for you.

( I posted this originally at http://forums.mozillazine.org/viewtopic.php?f=38&t=624240&p=5356385#p5356385 )

Posted under Browsers

This post was written by Content Curator on December 31, 2008

Tags: , , , , , , , , , , , , , , , ,

Firefox tip: Moving tabs between Firefox windows

So, you have two or more Firefox main windows open, and you need to close Firefox, but you’ll lose Firefox’s memory of all tabs in windows that are not the last one closed. Bummer.

This process assumes that you have Firefox set to “show my tabs from last time”.
Well, there are two ways to fox this. One is easy and requires no plugins. Here is the process:

  1. Pick one firefox window to be the recipient of all tabs. Maximize that window, or at least make it so you can see the tab bar, and it is near the top of your screen.
  2. By clicking on its icon on the Windows taskbar, open the other window that has tabs you want to save.
  3. Make sure that this second Firefox window is not maximized, and is small enough so that you can see the original Firefox window’s tab bar.
  4. Now, drag tabs from the second, smaller Firefox window, and drop them above on the original, bigger Firefox’s tab bar. NOTE: Read the next step too.
  5. If the original Firefox’s tab bar is full, or if it fills up as you drop tabs on it, then you can continue dropping tabs on the right-arrow button at the extreme right of the Firefox tab bar.
  6. Repeat step 4 for all tabs that you want to keep.
  7. Close the second, smaller Firefox window.
  8. Repeat steps 2 through 7 for any other Firefox windows that you want to retrieve tabs from.
  9. Make sure that only your one main Firefox window is open. Now close it. It will remember all those tabs you put into it now.

The second way to make this happen in the future is to download the Session Manager plugin for Firefox.

Posted under Browsers, Freeware

This post was written by Content Curator on October 17, 2007

Tags: , , , , , , , , , , , , , , , , , ,

Convert & Trim DVD video to MPEG-1, freeware style

Download DVD Shrink 3.2 and Flask MPEG 0.594

This procedure assumes: “Files”-type rip of DVD to decrypted VOB using DVD Decrypter

DVD Shrink

  1. Click button Open Files
  2. Navigate to the VIDEO_TS subfolder of the directory that holds the DVD’s decrypted VOB files.
  3. Click button Re-Author
  4. Drag titles from the right-hand pane to the left-hand pane.
  5. To trim: on left-hand pane items, right-click and click Set Start/End Frames…
  6. Set the beginning and ending frames of the segment that you want to keep.
  7. Click button Backup!

Flask MPEG

  1. File >> Open DVD. Find your IFO file made when you trimmed the VOBs
  2. Select the streams you want to include, click Flask this DVD!
  3. Options >> Global Project Options
    1. Video tab
      1. Frame Size – This dictated the output resolution of the video, as far as quality goes. It does not dictate the viewing size of the video, since this MPEG-1 video is locked in at 352 x 240 for viewing. What this means is that this setting controls video qulity only.
    2. Files tab – set the path and filename for output video.
    3. General Tab
      1. Compiling Time – you can compile the first n frames/seconds of the project, instead of the whole thing. Good for testing settings.
    4. Click OK
  4. Options >> Output Format Options
    1. Video Stream Settings tab – select MPEG-1 and leave the rest defaulted
    2. Program Stream Settings tab – select MPEG-1 and leave the rest defaulted
    3. Audio Stream Settings tab -lower Bit Rateto reduce final file size, and leave the rest defaulted
    4. Click OK
  5. Run… >> Start Conversion
  6. Click Start on the bbMPEG screen that pops
  7. When finished, click Ok on the bbMPEG screen
  8. Test your finished video (segment)

Posted under Freeware, Video Editing