Project BigResource

Since 2005, our team is working 24/7/365 to maintain one of the World's largest resource center for webmasters and programmers. The project comprises a directory of 50,000 Scripts & Tutorials relating a wide range of programming languages from PHP, .NET, ASP and Java to emerging Android & iOS development.

We also maintain an index of over 3 million questions/answers posted over internet relating aforementioned technologies. To learn more about Tracker, click here.

It took us 10 years of hard work to build an index of 3 million plus qualified Q&As by humans, not the bots. Just Crawling and building a database of messages is not an art. The success of this unique project lies in the human editing of these messages by professionals for content validity and definitive solution to various problems to stay focused on the issue & saving time. Compare and see the difference between an original post on a forum and the same edited message added to our index here. No unanswered posts, salutations, lengthy code lines, images, avatars, attachments, closing remarks, reference URLs, signatures etc., just the core issues and solutions to them.

As of June 2014 stats, 50,000 unique visitors/webmasters visit us every day to get benefited from this index. We are working hard and striving harder to provide programmers an unmatchable resource index to their unanswered questions.

Recently Indexed Messages:


Editing Refreshable Data Tables From Web
I have multiple data tables that are linked to a site. My issue is that there are breaks in the data every 15 cells with a row that shows the column categories. I locked my top row so I don't need the recurring column categories at all, but when I delete them and refresh the data they reappear.

How to delete these rows? Could I possibly run a macro that deletes the rows upon hitting refresh? Or is there a simpler way? ...

Calculate Percentage Of Individual Months Between 2 Dates And Populate Different Cells With Results
I want to display the percentage of occupancy for each month for condo rentals.

I have columns with dates that represent bookings throughout the year. check in and check out dates to be more precise. (A1 and B1 for example) and I have columns with months Jan, Feb, etc. (C1, D1, etc. for example)

The problem I run in to is that I can calculate the number of days between the dates and the fraction of the year (*12 to get a monthly value, but I fail to understand how I can break that up so that I can populate each month with a correct percentage of the total term.

E.g. A1=1-jan-2014 and B1=20-jan-2014 is an easy one because it only covers 1 month:
formula: =(YEARFRAC(A1,B1,3))*12 gives me 62,47% which I could just use as is for that month.

So far so good, but when the period covers more than one month or when the months overlaps, I don't know how to break the outcome up into the appropriate months to display the correct percentage for each month in its own column.

e.g. A1=1-jan-2014 and B1=20-Mar-2014 gives me a result of 253% with the same formula.
100% for November, 100% for December and 63% for January, which I could somehow formulate to break up over different Months.

But then it gets more tricky. What if the booking starts on a day other than the 1st of the Month?

e.g. A1=5-jan-2014 and B1=20-Mar-2014
The result of the formula (243%) is correct, but isn't sufficient to put the correct percentages for each month in their respective column.

What formula(s) should I use to break down the percentages to match the correct fraction of each individual month?

I attached an example of what I have so far for your review : test.xlsx‎ ...

How To Count (Equal To) Signs In A Row With Arguments
I'm creating an Excel sheet with statistics for a yearly salary review.

In the document that the managers will fill in there is a column for the employees performance (+, = or -).

I want to use this to compare how much salary raise employees has gotten depending on their performance rating. This is all fin with the + and - just using the regular countifs formula, but when it comes to the = Excel refuses to count them? ...

Selecting A Range Using VBA Code
I have attached a spreadsheet...I'm trying to select Range A1:N16 using VBA code...


When I use this code is only gets A1:N6...: is there anyway to get it to select the range all the way to the end of the data. I tried CurrentRegion and some other stuff but can't get it to work.: The range may go upto line 500 or 3 I just never know. ...

For Statements For Multiple Variables With Similar Names
Basically I have a list that user can select up to 6 values from. I have set them as individual strings.

Public IH1 As String
Public IH2 As String
Public IH3 As String
Public IH4 As String
Public IH5 As String
Public IH6 As String

What I want to be able to do is loop through them and do certain actions. How can I get a for statement to do that.

I tried something like that but it doesnt work. How to get it working I need to do tests on the variable strings and I want to be able to reference them and I'm not sure sure how

For i = 1 To 6
If "IH" & i = vbNullString Then
MsgBox "IH" & i
End If ...


Trick Lambda Expression In VB
I know in VB Lambda expressions must return a value and can only have one statement. But in my case I just need to execute a Sub that does not return a value. Is there a way to trick it by somehow returning a dummy value yet still call my Sub? If possible what would the syntax be like? ...

Vs2008: Why Form Is Not Opening
I have a project in VS2008.Net3.5 with a Module1, form1 and form2.


Question: At the beginning I am opening form1 from sub Main(). Now from the menu I am openning form2. In form2 I am clicking Done button to hide form2 and go back to form1. It works fine in the 1st trial. Keeping form1 open for the 2nd time, I opened form2 from the menu. Now when I Click the Done button 2nd time it just hides up everything. Form1 does not show UP. It just exits the whole application. But in my btnDone event, I have ...

How To Recognize Time Past
How do I make my program know that time is passing and interact with it? Currently I'm trying to use a method like this:
Imports System.Globalization
Private Sub CurrentTime_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CurrentTime.Tick
Dim date_info As DateTimeFormatInfo = _
ToolStripLabel1.Text = Now.ToString(date_info.ShortTimePattern)
End Sub

That sets the current time to ToolStripLabel1.Text it looks like: 10:25 PM. Then I made another timer, realizing I couldn't interact with Toolstriplabel1.text because the time contains " : and PM", and this timer does this:
Private Sub Timer2_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer2.Tick
TextBox48.Text = Val(ToolStripLabel1.Text)
End Sub

Basically it takes the value of toolstriplabel1 which would be "10" it gives a variable 1-12 in accordance with the current time. Then I have another timer that handles the main process, and in My.settings I have a variable:

So I was going to use My.settings.12hourspassed as a variable such as My.settings.12hourspassed = My.settings.12hourspassed + 1 - whenever the time (textbox48.text) goes to 12.
Private Sub Timer_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer.Tick
If Val(TextBox48.Text) = 12 Then My.settings.12hourspassed = My.settings.12hourspassed + 1
If Val(TextBox48.Text) = 12 Then TextBox48.Text = "1"
End Sub

The problem is that I cant do textbox48.text = "1" because another timer is making it the value of the current time.. So whenever textbox48.text = 12 it constantly does: My.settings.12hourspassed = My.settings.12hourspassed + 1...

I know that this method completely skips an hour and such.. accuracy isnt all that huge. Any way to tick off whenever 12 hours have passed? and if the program is turned off a way to compare the current date with the date the program turned off at to see how much time has passed while the program is off? ...

Get The Color Of The Top-left Pixel Of The Desktop Window?
I need to get the color of the top-left pixel of the desktop window, here's my
<DllImport("user32.dll", SetLastError:=True, CharSet:=CharSet.Auto)> _Private Shared Function GetDC(ByVal hwnd As IntPtr) As IntPtrEnd


But GetPixel always returns -1. I tried to get it to work using different coordinates (1,1 for example) but no luck. Does anybody know what might be the case?

P.S. Is there any alternatives for obtaining the desktop pixel colors? ...

Sorting Listbox Items Numerically In VB?
I need to sort the items in a visual basic listbox numerically, that is, I have a collection of numbers I would like to be sorted increasingly.

I tried to simply use the listbox's Sorted property, but found that it treated the numbers as if they were strings, that is, it would look at the first digit, then the second, etc. to determine the order. That meant that 13 would show before 5, for example.

I thought of dumping all the numbers into an array, soring the array, and then pushing them back to the listbox, but, honestly, I don't know how to go about the sorting. I figured the array would be useless, since the listbox already acts as a pseudo array. ...


GIMP :: Enhance Contrast And Darken Highlights
I'm planning to start using Gimp for editing my photos. However, I've been looking through the functions, and I've also read the online manual. But there are two things I can't find.

1. How can I darken the highlights in a photo?
2. Is it possible to enhance the contrast in more detail than on a general level, e.g. midtone contrast only? ...

Lightroom :: Images Are Not In Order In The Import Dialogue Box?
using lightroom 4.3...  when I import photos, they appear in random order in the IMPORT viewing window.  With pervious versions of lightroom, they were always in order of file name.  It becomes more time consuming to select specific files to import to a file if there are 2 or more jobs on one CF card ( I have photos of my kids skiing mixed up with a portrait session.).  Is there a way to sort the photos (by file name, or time) before import?  I do know how to sort post import. ...

VideoStudio :: Overlapped Buffer Is Full?
"An internal error occurred when overlapped buffer is full."

That is the message I am receiving when I try to make my project into a video or audio file.

I have two audio tracks which have only two effects added to them.

What is wrong? ...

AutoCAD Civil 3D :: Open Channels Or Corridor Storm Network Analysis
As I know we can import and export storm and sewer pipe lines between C3d and SSA. But how about open channels? I am workin on a project which is contain sewer pipes (close sections like circle pipes) and open channels(maybe as corridor in C3d) and some ditches with irregular sectios. it is pretty easy to define assemlies for open channels and ditches in C3d but if we can not pull the in SSA in order to analyze then we need to do the job twise in both software. I've tried to pull my network into SSA. but it just import pipe networks not open channels. is there any way to import them or any other software that can import from C3d and analyse the network? ...

Photoshop Elements :: Activating 12 On One Of Two Computer?
I get a message when opening PE that the triIal version has expired. I never had a trial version. The next screen ask me to sign in and then tells me I am not connected to the web when in fact I am. Next it ask for a  response code which I do have. ...


$_POST Array - Get All Posted Fields Which Are Extra_something And Return Each
I need some advanced help with a PHP script. I am submitting a form to a script, which has constant fields ie: price, quantity etc. However, I want to submit extra fields, which are called Extra_OptionName. I have a form, which has price, quantity, itemcode, Extra_Colour, Extra_Size as its fields. It is posted to a php script. I need the PHP script to do, is to get all posted fields which are Extra_something and return each, with the name of the field minus the Extra_ bit.

$option1 = Colour
$option1v = Red
$option2 = Size
$option2v = Large ...

Dynamic PayPal Button Generation - Unsecure?
I am just wondering here.. Aren't the PayPal buttons that are dynamically created, very unsecure, and easily "hackable"?

Like so:

<form name="_xclick" target="paypal" action="url">
<input type="hidden" name="cmd" value="_cart">
<input type="hidden" name="business" value="">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="item_name" value="HTML book">
<input type="hidden" name="amount" value="24.99">
<input type="image" src="url">
<input type="hidden" name="add" value="1">

Changing the price of the product is straight forward when you can modify the code with, say, FireBug.

The reason I am asking, is because I might/will start developing an E-Commerce kinda system, where the products can be added in that system, without doing it in PayPal. ...

Validate With Zend_Validate_Date On A Time String
I'm trying to validate a 'time' field using Zend Framework. The docs seem to be pointing out that the following:

$tstarttime = $form->createElement('text','t_start_time');
->setLabel('Start Time')
->addValidator(new Zend_Validate_Date('H:i'));

I've tried this but no luck. Any ideas or alternative ways to validate a time in the format of HH:MM (H:i in php) ...

Unix And Windows Php Script Compatibility
I'm a php novice and am developing a shopping cart application for a
client who is hosted on a unix server. The hosting service requires that
each php file have #!/usr/local/bin/php at the top. When I test these
pages on my developer Windows php installation I get errors because
Windows does not recognize the bang command so it is passed on as
content to the php server.

Any suggestions on hiding the first line from windows while still having
unix see this? ...

Magento CE - Discount On First Order?
Is there any plausible way to give a customer a discount on their first order? I imagine it would require the user to sign up for a free account, which is fine. But after that, I'm stumped. The Promotion feature in Magento doesn't cater for anything like this and Google doesn't find any good leads. ...


BB Bold :: 9900 - Headset Not Working Automatically?
I use a corded headset with my blackberry, I have owned a bold 9000 and a Torch and just upgraded to the Bold 9900. I have two headsets, one in my vehicle and one in my office. They both work fine and work with other blackberry's and devices.The problem is when the headset is connected to the blackberry the software does not select this device as the default device for answering or placing calls. This is a real flaw in the programming and is a complete nuance. Every time I place or receive a call I must select the headset manually on the touch screen.All the other blackberry's make the transition automatically. Meaning they all send the call to the headset without any intervention from me. I do not understand how this feature could have been left out if all the previous blackberry's worked just fine. ...

LG :: Songs Not Showing Up On Env
it shows the song on the micro sd card and i can play the song from the card when it is in the card reader on the computer but the phone doesnt see the songs i have on the card and its in the same file the rest of my music is in and they will play and show up on the phone.i have reinitialized my data base so what can i do to make the songs show up on my phone? ...

BB :: How To Protect Personal Information
I am trying to understand how I can protect my personal information stored in Outlook Contacts from being stored on my employers enterprise server? The blackberry torch 9800 I have is my personal equipment and I have several email accounts that go to it. However, I'm also on my employers enterprise server and they now have all of my passwords to various websites. Is there anyway to keep specific contacts off an employers enterprise server while still having them appear on the blackberry torch? ...

Sony Ericsson :: K800i Enabled To Using Flash Wallpaper
it's enabled to using Flash wallpaper in k800i? can someone tell me the way? ...

BB Storm 9530/9500 :: How Do I Setup Email O2 Network?
I've bought a Storm and I'm struggling to get the email setup. Whenever I go to the o2 blackberry internet service and type in the device pin & imei, it tells me that the device is registered with another carrier. I've spoken to vodafone (the previous network) and they've told me it's never been registered with them. When I go to advanced options-host routing table it shows that there are no entries.How can I get this to work? ...


How To Calculate Top Customer In Each City With Maximum Order
I had create table name customers orders and order details as follow

CREATE TABLE `customers` (
`customerNumber` int(11) NOT NULL,
`customerName` varchar(50) NOT NULL,
`contactLastName` varchar(50) NOT NULL,
`contactFirstName` varchar(50) NOT NULL,

After that I have to find out top ordered customer from each city.I had calculated total order by each customer as given below but I don't know how to select top one customer from each city with maximum order.

SELECT o.customerNumber, ROUND( SUM( od.priceEach * od.quantityOrdered ) , 2 ) AS totalOrder
FROM orders AS o
INNER JOIN orderDetails AS od ON o.orderNumber = od.orderNumber
GROUP BY o.customerNumber
ORDER BY totalOrder DESC

I'm using mysql. ...

Storing Voicemail In Database
I have been working with MySQL for a while. I am looking to make Asterisk Voicemail Highly Redundant and able to handle load balancing. I can accomplish this by storing my Voicemail messages in a MySQL cluster. I read that it really should only store textual data. I have successfully set up Asterisk to store voicemail in MySQL but I don't know how well this scales with MySQL from a storage/performance perspective.

So my questions are Is MySQL really suppose to be used to store voice/audio data? How big can a MySQL database get? ...

Java - Return Default Timestamp Object Instead Of Null?
I have a Timestamp object-

java.sql.Timestamp time = null;

and I have a datetime value val_time in a DB table.

val_time datetime

The situation is, while performaing an operation, this val_time is not getting updated (which is pretty normal in my case). While reading from DB, naturally the datetime value will be null. So the timestamp object will also be null. My question is - can we get some default value other than null? ...

Php - Timediff Returning Two Different Values
I have one query that I'm testing times with.

I get two different times and this is making me doubt the correctness of my data.

Here are the two examples :

users.fname as counselor,
count(session.anum) as students,


Why does this happen and which result set am I supposed to trust? ...

Redirect Output To Logfile From Script
I'd like to execute a SQL script file from mysql command line tool, like

mysql database < script.sql

where the script script.sql contains a statement that redirects the output to a file.

I thought this should be possible by placing a tee into the script like this:

tee script.log;

SELECT sysdate() AS "Start" FROM dual;
UPDATE table SET column = 'off';

Unfortunately, this does not work, no script.log appears.

Is there any possibility to redirect the output to a file from the script itself?

Use case: These scripts will be executed by our Service Department when deploying the application. They would like to execute the script with as little steps and effort as possible, so placing a redirect (> script.log) at the end of the command prompt is not a real option, at least if they must execute a bunch of scripts at once. ...