Knowledge Base - .NET, C#, SQL Server 2005, PHP and Actionscript 2.0 / 3.0 etc

Running a store procedure in query analyzer:
declare @success int
exec sptriggerexport @retval = @success out
print @success

Using a file to insert data on the command line:
cat directory/filename.sql | mysql -u user_name -p database_name

Shuts buffer: ctrl -x #
Print environment variables: env
echo $DISPLAY
export DISPLAY=
echo $DISPLAY
undo: ctrl shift hyphen
Switch window: ctrl x o
ctrl x then ctrl c shuts down

Diff: cvs diff -u
Change a files tag to kilobytes: cvs admin -kb *.gif
Remove and delete a file from cvs: cvs rm -f ‘*.*’

cvs up -A puts the sticky tag back to head

cvs up -D 2006-06-20 updates to a day but adds a sticky tag

Get the history: history
Hit a history number (bang): !56
Finding things in the history: history | grep export
Print working directory: pwd
Find a file: find . -name *.*

Funky find and replace:
nice perl -p -i.bac-2006-03-31 -e ’s{/dealerextranet}{/dealers}’ ` grep -rl ‘/dealerextranet’ . `

Search history:
ctrl - r

Find in what commands use that function: apropo
for example: apropo cut - finds all of the relevant uses for cut

chmod lots of files:
find . -type f -exec chmod 0644 {} \;

chmod lots of directories:
find . -type d -exec chmod 0644 {} \;

-type d = directories

cut -d: -f1,1

Tars up and then un-tars to the correct directory!!!!!!!!
cd for_upload && tar -cf - * | ssh jhinton@dt ‘(mkdir -p testsite && cd testsite && tar -xf -)’

run two commands in a line: first command && second command

wc -1
gives file count eg:
grep -rl ‘test’ . | wc -1
will output the number of files found in that grep

jobs —- lists all the current jobs running

kill %2 —– will kill job 1
kill %1 —– will kill job 2

mount ——- gives you all the info about the drives including their permissions and file format

Found this whilst getting captions working for a FLV.

http://www.brajeshwar.com/reference/as2/NetStream.html

Visual Studio Example files

http://osflash.org/projects

Register It:

<configSections>

<section name=”mySection” type=”System.Configuration.NameValueSectionHandler, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089″ />

</configSections>

Then include it:

<mySection configSource=”MySection.config”/>

Thats about it I think!

Remember the include also has to go in the correct section:

<system.net>
<mailSettings>
<smtp configSource=”Smtp.config”/>
</mailSettings>
</system.net>

A new approach to developing Flash apps.

http://www.flashdevelop.org/community/