Assuming server is required, the following 128 results were found.
Manager (eg. phpMyAdmin) Recommended if you are working remotely as these tend to let you carry out the actions on the server itself. (ie. Fast & Reliable) Compress/backup LIVE files to ZIP file. Export LIVE database to SQL file. (Export > Custom > Save...
How to run a .RUN filehttps://joellipman.com/articles/linux/how-to-run-a-run-file.html
ways of running a downloaded .RUN file. Note: Bear in mind that the following is all case-sensitive. Through the terminal server Download the .RUN file to your desktop Open a terminal by going to Application > Accessories > Terminal Type 'CD Desktop' to...
is a quick note on finding the last occurrence of a string in a longer string. This has to be in Transact SQL for a SQL Server instance only and not filtered by other code. Why? I have a string such as the following (column positions added for demo...
lowercase name with no spaces). tick the checkbox Run with highest privileges. set "Configure For" to Windows 7, Windows Server 2008 R2 Under the Actions tab, Click on New... Leave "Action" as Start a program for Program/Script, Specify the command path...
to: - MS Windows 7 Enterprise What? So I can ping the server the Oracle 11g database sits on. I've installed the Oracle 11g client tools and can connect using sqlplus. But if I tnsping any oracle database, I get something along the lines of: Message...
to extract all the data values from an AwStats report. Advanced Web Statistics or AwStats, is a reporting system for server logs. This gives data as to your unique visitors (referred to as visitors), the visits these generated (visits), the number of...
a htaccess rewrite rule I'm liking. What does it do? What I type: http://www.mywebsite.com/blog/videos.html Sends this to server: http://www.mywebsite.com/index.php?myFolder=blog&myFiles=videos How? Options -Indexes +FollowSymlinks RewriteEngine On...
Invalid arguments passed in /home/.../public_html/includes/router.php on line 325 Where "..." is the path on your server. If you're writing a component, then ask yourself if you really need the router.php file. Mine was generated by...
bookings based on a user and given a date range. The problem is that there are a few thousand users and Microsoft's SQL Server Reporting Services interface isn't the most fun to scroll endlessly down. Advanced users can type the name really fast for it...
CDate(cstr(month(today.now())+1) + "/1/" + cstr(year(today.now()))) ) This idea was based on Bob Griffin's post on SQL Server Central.com forums where he subtracts 1 day from the first day of next month to get the last date/number of days in this month.
Drop If Object Existshttps://joellipman.com/articles/database/t-sql/drop-if-object-exists.html
Some people have been suggesting you can use "CREATE OR REPLACE... VIEW... FUNCTION" but my SQL Server 2008 Management Studio doesn't like this and refuses to understand what I'm trying to do. Why? As this data seemed to be across various websites, I...
3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How? For SQL Server 2005 or later, using T-SQL: DECLARE @myStringToParse VARCHAR(max), @myXML XML; SET @myStringToParse = 'Title,Forenames,Surname';...
CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and...
a javascript-enabled client-side page. The tool analyzes any input on-the-fly without sending or receiving data to a server. The page used to be a part of a Password Security System I wrote back in 2008 and I missed the analysis capability so I have...
is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings : Database Tables Prefix It should be a short alphanumeric value with a trailing underscore (eg....
it to the target system. For our package to decode what "M" means, it needs to look this up in a table on the original server. We had around 12 lookups to do, so you could do this: But we didn't want to do this. How? As a proof of concept, I created one...
encoded in UTF-8. // set headers for JSON file // header('Content-Type: application/json'); // seems to cause 500 Internal Server Error header('Content-Type: text/javascript'); header('Access-Control-Allow-Origin: http://api.joellipman.com/');...
errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using PHP as the server-side programming language and cURL, a sub-component of PHP that allows you to send and receive requests as the server (as opposed...
on 3.1.x and 3.2.x) - Fixed Bug: Support for German, Chinese, French, Arabic, Hebrew and Slovak - Enhancement: Update server added (for when Joomla supports this) - Date Uploaded: Wed, 15th Jan 2014 3.0- Enhancement: Hardcoded DS value for Joomla 3.x...
an article on how I connected to the Apimo WebService. The Apimo Webservice is an API provided by apimo.com and requires a server request over HTTPS using the GET method. Why? This was quite difficult to connect to and to determine what was wrong with...