... where solutions for script programming are found ...
Still remember the similar article I wrote regarding the title of this article? Well, if you want to implement breadcrumb using the SQL Server database, then here is the related Stored Procedures in SQL Server format. In other words, this following article will show you the same Stored Procedures in SQL Server instead of using [...]
Have you ever got difficulty when handling the duplicate records in a table in MySQL database, where you want to delete the records and pretty leaves one record from each duplicate records? This usually happens in the table who did not have the primary key, so that it can cause to store the duplicate records. [...]
Have you ever encountered the strange behavior while you were deleting the certain records from a table in MySQL database using an application you build, which those records cannot be deleted? Well, I have! Today, I encountered this problem. This is so weird, since I have never faced this situation before. Well, after doing some [...]
Yesterday I faced a situation while I was trying to get some sub-string values that derived from a single string that being saved in database, and displayed them to the checked CheckBoxes control in PHP. Let’s say I had 5 CheckBoxes control named Applications on my form, whereas the values stored in a single string [...]
Have you ever wanted to know which record has duplicate content based on the same content in a field in MySQL database? This information will be get after you select the records and display them which one have the same content by groupping them by that field. Well, here is the script how you can [...]
Today I faced an interesting situation while getting the certain characters from a field and wanted to display them by using SELECT DISTINCT statement in MySQL database. Suppose we had thousand records in a table and we wanted to get the certain characters from the first until the certain position counted 6 characters from the [...]
Actually, this modification is similar with another one that I made here: How to Avoid Duplicate Ticket Content in osTicket System. After client post message (reply) to his/her ticket that has been created before, then client reload/refresh that next page, the duplicate message will be saved in database. This modification will avoid that duplicate message [...]
Both in osTicket System version 1.6 RC4 and 1.6 RC5 have not saved the “0″ character if the phone number started with the zero character. For example, if the client’s phone number is 08157140595, then this number will be saved in database as 8157140595 (the first “0″ character will not be saved). This happens since [...]
In osTicket System, when a new ticket created, it executes INSERT INTO SQL, and then displaying the “Thank You” page afterwards. Unfortunately, when client reload or refresh that page, then it will re-execute that SQL again, since the primary key for the ticket table is an ID of the ticket which has the auto-number field. [...]
I have hundreds of records that need to be imported from one table and database (let’s say that this is the first database) to another table in different database (and the last one is the second database). Unfortunately, one of the columns in the table in first database has the Date value in 10 digits [...]
Recent Comments