Assuming change is required, the following 170 results were found.
-
** ** ****************************************************************************************************************** ** Change History: **...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
TOP (@random) ID FROM #Scramble WHERE Chosen IS NULL ) A IF @ChosenID IS NULL RAISERROR('There are no values left to change the Data',16,1) UPDATE #Scramble SET Chosen = 1 WHERE ID = @ChosenID SELECT @UpdateData = Data FROM #Scramble WHERE ID =...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: *
-
non-numeric values to map to... Well the system thinks I might so it fails. I realised then the equals sign ("=") could be changed to a "LIKE" which will mean both values are expected to be a string. So with this in mind: SELECT r1.MapIn ( SELECT...
- Type: Article
- Author: Joel Lipman
- Category: Transact-SQL
- Language: en-GB
-
think that developers should not be able to send a 1000 queries a minute or why a developer has to refresh the page, make a change, upload, etc. well it's beyond a joke and no one should waste their time with such companies.
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
year is specified (2010), I have a variable posted from a HTML form in my PHP. Also note: The association to a user can change because anonymous guests count as guests until they login, which is when they are associated to a UserID and identified as...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
(“\”) character. \% A “%” character. \_ A “_” character. Additional An alternative in SQL to escape apostrophes is to change these to paired apostrophes, so: INSERT INTO myTable VALUES ('1', 'It\'s amazing!'); -- equally valid INSERT INTO myTable VALUES...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
a column called introtext in a database table called MYTABLE_content. First let me find all the articles that need this change: SET @stringtoFind=' '; SET @stringtoReplaceWith=' '; SELECT `id` , `title` , IF(LOCATE( @stringtoFind,...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
system). Content Review List all pages (and their web address) published on the website Spelling, grammar checks Comments, changes, suggestions, additions, exclusions Functionality and feature checks Initial content to be finalised (this is content that...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
this took me the good part of an hour just to find out, I'm posting it here so I never have to look for it again. A client changed their website domain address and wanted any person visiting the old domain to be redirected to the new domain. Why? I...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
appear on this page, it is because I have only copied over some of the entire directory (the icons I want to use). Note, change the width of your browser if the below list is not displaying nicely. 4.4 fa-500px [] fa-adjust [] ...
- Type: Article
- Author: Joel Lipman
- Category: Web-Development
- Language: *
-
it. By increasing the size of the asterisk, this often increases the line-height and causes the overall line height to change for other objects in the same row. The problem afterwards was that the asterisk character would overlap the item beneath it (in...
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
a good bit of information from the source link listed below but the settings didn't solve the problem. The solution was to change the options on the mac firewall by going into Settings > Security & Privacy > Firewall Click the lock to make changes...
- Type: Article
- Author: Joel Lipman
- Category: File Transfer Protocol
- Language: *
-
of code that replicates any HTML table. How? I've been trying various ways so I'm posting them here. My opinions on them change with the weather so until I do some benchmarking I won't know which ones best: Method #1 This method replicates the table in...
- Type: Article
- Author: Joel Lipman
- Category: Hypertext Markup Language
- Language: en-GB
-
Apache. This is the full path to the folder that you will be uploading the files to and should be 755 (ie. rwxr-xr-x). The change ownership command in shell is 'chown -R apache:apache '. 3. Check that your PHP ini specifies a reasonable maximum file...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
and ', array_slice($a3,0,2)).' ago'; } When could I possibly want to do this? Well I've previously used this for password change reminders but on this occasion for a listing of reviews laid out as per the following screenshot:
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
in the xsl:stylesheet tag so that "xsi:nil=true" is valid. Test for a string length of greater than 0 (not blank) and change the attribute of the element so that it's tag displays "xsi:nil=true". If...then...else... will be emulated by the XSLT...
- Type: Article
- Author: Joel Lipman
- Category: XML Stylesheet Language Transformations
- Language: *
-
Version Platform ChangeLog Options 3.1.1 Artur - Enhancement: Added parameter: Weblink separator height. - Enhancement: Added parameter: Display submitted by. - Enhancement: Added parameter: Display category. - Enhancement: Reorganized parameters...
- Type: Article
- Author: Joel Lipman
- Category: Downloads
- Language: *
-
Here's a complete PHP script of a basic example of getting the agencies belonging to a company (note you will need to change the keys and relevant IDs to match your own solution): // specify provider ID $my_provider_id = 1234; $my_timestamp = time(); //...
- Type: Article
- Author: Joel Lipman
- Category: API Miscellaneous
- Language: *
-
above, open a Microsoft product Bang "Head" against wall. Bang "Head" against wall. Bang "Head" against wall. Alternatively Change the SQL query so that the date returns in yyyy-mm-dd format (eg. 2012-03-04) Reverse Dates Order If you have a date filter...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
116°42′30″E Note that I tend to copy the coordinates off a website which has strange apostrophes and double-quotes. You can change this but remember to put two double-quotes if you are searching on it, eg: FIND(""",B1) // will NOT work! FIND("""",B1) //...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB