- Plug your phoen with the USB cable to your computer
- Run usbmuxd with sudo
$ sudo usbmuxd
- Run idevice_id -l to check if the phone is reachable
$ idevice_id -l
|# SED = TEST SQL QUERIES SYNTAX|
|# Takes the table name and the WHERE clause to create a SELECT query with this values.|
|## UPDATE queries|
|sed 's|update\s\+\([A-Z0-9_]\+\).\+\(where\s\+.\+$\)|SELECT * FROM \1 \2|i' <text file with queries>|
|### example: UPDATE table_2 SET filed_1 = '123ab', field_2 = 123 WHERE field_3 = 'bla' and field_5 like '%lala'|
|### output example: SELECT * FROM table_2 WHERE field_3 = 'bla' and field_5 like '%lala'|
|## DELETE queries|
#Working with XML in ColdFusion
Cheatsheet with code examples to read, create and search xml files
ColdFusion provides many built-in functions for doing all sort of XML based operations.
###Reading XML Document Read the document then passes it to the parser to create an XML object
<cffile action="read" file="#ExpandPath('./some.xml')#" variable="myXML" /> <cfset myDoc=XmlParse(myXML) />
To interact with a database with CFML first you need to setup the data source in the administrator site.
#Install Apache server on Windows 7 64 with IIS running
Check first if you have the dependencies installed in your computer. You need Visual C++ 2008 Redistributable Package Open the control panel (window+r type "control" and press "enter") check if you see the package installed.
Get the Apache .zip. This is and official third party site, Apache does not provide a package to install in windows, you would have to build it manually.
Unzip the file and move or copy its content into C:\Apache22
To start Apache open a command prompt (windows+r type "cmd" press "enter"). Navigate to *C:\Apache22\bin* and type httpd.exe then enter
#Windos Network Commands
###nslookup The nslookup tool can help you to verify that DNS name resolution is working correctly. When you run nslookup against a host name, the tool will show you how the name was resolved, as well as which DNS server was used during the lookup. This tool can be extremely helpful when troubleshooting problems related to legacy DNS records that still exist but that are no longer correct. To use this tool, just enter the nslookup command, followed by the name of the host you want to resolve. For example:
###netstat -an The netstat command is particularly useful, displaying all sorts of network statistics when used with its various options. One of the most interesting variants of netstat is netstat -an, which will display a list of all open network connections on their computer, along with the port they’re using and the foreign IP address they’re connected to.