Assuming example is required, the following 175 results were found.
-
the table after the DELETE clause. Rather straightforward but I got this answer from StackOverflow. Based on the previous example, here's the query to only delete records in Session and SessionStudent represented by aliases s and sst respectively and to...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
to potential publishers. Technology demo – a prototype that demonstrates the website’s technology, illustrating for example the presentation and registration services. This is produced for review so as to decide if concept is marketable. Browsable...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
name that has been abbreviated to the first letter of each word, and is pronounced as a series of individual letters. For example HTML (the computer language used to author webpages), is an initialism of HyperText Markup Language, and is pronounced:...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
obviously incorrect. This is because the script is not changing the date at the stroke of midnight. Take the last row as an example, the equation that's happening is: $thisDateSQL=date("Y-m-d", strtotime($sub_row['DateSession'])); $this_time_from1 =...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
once in the page Customize your feed and Copy & Paste the code where you want it to appear // example: replace myPinterestAccount with your account
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
CSS: STABLE AND CONSISTENT !!! */ background-color: #f7f7f7; background-clip: padding-box; border-radius: 0 0 5px 5px; Example Additional The above issue happened when using Google Chrome v23 or MS Internet Explorer v8 (so Webkit and MSIE appear to be...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
I saw a lot of articles that would cover this but I wanted an example which includes headers and footers and how to get an automatic page-break-inside to not overlap these. Fine on screen but this is obviously for when it comes to printing. Why? I...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
text changes and the transition between the two is controlled smoothly. Why? At time of print, I couldn't find any clear example demonstrating this so here's my take on it: What I have » Home / Products / Lanterns What I want (on mouseover) // if I...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
of a field of a form from it's default when it is clicked on so that it auto-clears and changes to how it normally works. Example? Note the value in the below field. Now click on it and it disappears, allowing you to type normally. Clear whatever you...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: en-GB
-
An article on how to quickly adapt an array code and sort by its values. Surprising how many examples are on the web and everyone saying you're doing it wrong... Which is true but quite unhelpful. The original code is not my own either but that's not an...
- Type: Article
- Author: Joel Lipman
- Category: JavaScript
- Language: *
-
Split the first string "myFolder" with the slash (/) as a delimiter, controlling the syntax/format of your site URLs. For Example http://www.mysite.com/blog/videos/2010/january/21.html // sends index.php?myFolder=blog/videos/2010/january&myFiles=21...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
take a date in the past and return the number of years, months, weeks, days, hours, minutes and seconds. Why? Here are some examples of what we want to achieve: 1 year 2 months 3 weeks 4 days 5 hours 6 minutes 7 seconds // full string 1 year 3 weeks 5...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
An article on how to declare an XML element as NULL using the attribute "xsi:nil". I'm going to use a very short example by providing a blank date of birth value: -- What I have: // -- What I want: Why? Outputting from SITS:Vision to our staging...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
Receiver: Script #2: Send to third-party in XML format: (because that's the format they accept) Note that in the following example, the XML is sent as a url encoded value paired with a key (posted variables must be key1=value1&key2=value2...) Script #3:...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
to display the longest data value. Cause 3: Fields and objects in the same column do not have the same text alignment For example, the column heading text object is aligned to the right, while the database field is aligned to center. To ensure all...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: *
-
put the formula: =IF(J1="E", L1, L1 * -1) There we go! Column M has your latitude and Column N has your longitude. With the example above, this should return: A B C D E F G H I J K L M N -------------------------------------- ----------------------...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
all the data to apply this to (eg. $A1:$W36000). You are then prompted for the number of rows per sheet (eg. 3000). In my example, this will produce an extra 12 worksheets in this file. Using the above module, overwrite the code you previously pasted...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
This is an article to remind me how to search a column in an Excel file for values found in another column (in this example, on another worksheet in the same workbook). How? So for demonstration purposes, I'm using a new Excel file with two worksheets...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
custom parameter then press So to use these now, simply append 2 hyphens/dashes and the name of your custom parameter, for example: /imagine a beautiful face --portrait Effects So I can now build a prompt combining any of the following in a table (this...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
statement written in a small amount of code, usually on one line, and exists in most programming languages. For Example, the statement: If (ThisCondition = true) ThisVar:=1 Else ThisVar:=2 Converted to Ternary this would look like:...
- Type: Article
- Author: Joel Lipman
- Category: AutoHotkey
- Language: en-GB