Search results for query: *

What I'm trying to do is create a SQL query that internally generates the following result set without querying an actual table/view... DESC ABBR CALENDAR_YEAR Next Year N 2013 This Year C 2012 Last Year L 2011 Older Year O 2010 The respective values...

I've had a good search for the answer to this, but I'm struggling to find anything. In Excel 2007, I've created a chart consisting of two clustered column series. Series 1 is plotted on the primary (left) y-axis, whilst Series 2 is plotted on the secondary (right) y-axis. Both series share the...

Hi there, On running a macro (originally written in Excel 2003) in Excel 2007 I get a "Run-time error '9': Subscript out of range" error which arises from the following code: Public Sub GoToChart() ' check which text box button called the macro and activate appropriate sheet If...

Hi there, Throughout today I've been trying to setup Apache 2.2.12 (installed as part of XAMPP 1.7.2) in a local development environment such that http://apache/ maps to http://127.0.0.3. I have forced Apache to listen on 127.0.0.3:80 so that I can run IIS concurrently on 127.0.0.2:80 (I have...

Hi there, Unfortunately, I've inherited a large site which I believe to have many unused files. Could anyone recommend the most effective way to obtain an accurate listing of such files? Your advice would be much appreciated. Clive ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "To err...

MySQL version: 5.0.67-community-log I've recently added a significant number of stored routines (i.e. stored procedure and stored functions) to my database. I checked the output of my automatic backup PHP script (which executes a call to mysqldump) today and discovered that the stored routines...

I am interested to know your views as to which technology you would recommend for creating a very simple animated banner which would rotate through 6 images. Are there any inherent advantages/disadvantages in using Flash as opposed to Javascript (perhaps using jQuery) as opposed to an animated...

What I'm trying to do should be very simple. I'd like to assign a submit handler to a form and pass that form into the handler (I then wish to interrogate the id of the form argument and perform appropriate validation according to which form it is). The following code doesn't achieve the desired...

Hi there, I have a Vista laptop where I am using the only user account. I was trying to configure some software that requires me to allow "Full Control" of a certain registry key (via regedt32). The "Allow" tick box was disabled, so I stupidly thought that by ticking the "Deny" box it might...

Hi there, Does anyone know the range of values returned by the following PHP call: date("O"); I would think it should be -1200 to +1200, but I can't be certain. If you could reference your answer that would be most helpful. Many thanks in advance! Clive...

Hi there, I'm completely new to classic ASP, but have a fair bit of server-side experience with PHP. I've cobbled together the following simple ASP script (called xml_echo.asp) which echoes the XML output from a PHP script (due to constraints imposed on me, I'm not permitted by my employer to...

Hi there, I'm a subscriber to Sitepoint's Design View newsletter, and in this week's newsletter I noticed that they're making a free Photoshop e-book available (until 13th June). Simply click the following link, enter your email address and Sitepoint will send you a link to download the e-book...

Hi there, I have a PHP page which lists downloads available to our customers. In the last few months, we've been getting a lot of customers informing us that IE reports "Download Complete" even though the file size of the download indicates that it has not managed to download the entire file...

I did a quick search and couldn't see any mention of achieving semi-transparent web images using the PNG8 export format and alpha transparency in Fireworks, so I've added an FAQ which quotes a SitePoint newsletter on the topic by Alex Walker: faq726-6738 Clive...

I'm using the following code to serve up exe files as downloads on a site: $filename = 'Update123.exe'; $mimetype = 'application/octet-stream'; if (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE 5') or strpos($_SERVER['HTTP_USER_AGENT'], 'Opera 7')) { $mimetype = 'application/x-download'; }...

I have a site which is password-protected via Basic HTTP Authentication. I would like to add a menu option in my Windows desktop application which automatically logs in so that the user is not prompted for login credentials if using this route. I therefore wondered if it's possible to send...

Hi there, A while ago I created a noticeboard page on one of my websites using the equivalent of the following code. I now want to add a little RSS image (16 x 16 pixels) and link neatly into the top-right of a noticeboard-item so that it lines up with the text of the h3 tag. I've tried several...

Hi there, I'm hitting a wall of blanks with this after much experimentation and googling! I have a page which allows "comments" to be entered via an html textarea. If the user has included a carriage return in the text they have typed this is stored in the MySQL field as "\r\n". I should point...

Hi there, I am interested in hearing what PHP programmers here use in terms of testing tools. Do you utilise features built into the IDE you use or do you use separate testing tools? If the latter, which testing tools do you use? Do you conduct regression testing (i.e. testing which...

Hi there, A while back, I wrote a file upload script which has worked fine for file uploads less than 12MB (a limit I set via a php.ini file). I've now increased the limit to 30MB and files still upload without a problem. When a file is uploaded an email is generated which contains a URL...