Search results for query: *

Thanks Candyman! I will look into the errors - the original template was not my design, but I know I have loads to look at! :) The problem with specifying px dimensions to the image is that if I limit the image size to say 500px then when I view the page in 800x600 screen res it looks fine...

Hi There I have been working on a Joomla website for my company. I have a large image on the front page. I have used the following code to scale the image to fit the screen: ========================================================= CSS: #image_container { width:90%; height:90%; border:3px...

Hi All I have been trying to write a macro to run through a column of an excel sheet and basically validate the data. At the moment it runs through and changes the cell formatting based on 1 condition. eg. Where the data is longer than 10 characters it colours the cell background Red and sets...

Hi All A wierd one this. I have a page where I want to submit a 'Quote Reference' from an insert page to a redirect page. I have searched the internet and found out that you have to use session variables because of the way DMX does the insert. I also found where you should put the code: If...

Hi All I have a client who wants to start a website where people in lots of locations are able to log in and upload photos, then have them viewable in an album. The thing is the users aren't going to be over technical so I am trying to identify some way of doing this simply. Literally I would...

I've figured out what the problem was - I wasn't selecting a 'Collation' for each column of the table when I set it up. Does anyone know which one would be best? I'm using ASCII_General something now!! Cheers Sinista

Hi There I have set up the site properly and set up the connection correctly. (I followed a tutorial from Macromedia!!) If I enter data into the database through myPHPAdmin, then I can retrieve it in a recordset and display it in a dynamic table. So I think the connection etc is working...

Hi All I have just set up my first test mySQL database. I downloaded EasyPHP to get all the bits and I created a database using myPHPAdmin. The database has a single table 'testTable' with 2 columns (although for some reason myPHPAdmin seems to call these fields!). The fields are called...

Thanks for that. Which bit do I need to download as there seem to be hundreds of possibilities. Do I need to purchase the Commercial license if I am selling the web app I design? Thanks Sinista

Hi All I am looking to build a website for a client which allows him to display cars he has for sale. Basically I want to build an ASP frontend and a single table database 'Cars'. In the past I have built applications using an MS Access database backend as I could then use access to make any...

Hi Again everyone About a year ago I set up an ASP application on Windows XP Pro. The user now wants to install it on another XP Pro machine. Unfortunately I have to try and talk him through this on the phone and I can't remember what needs to be done. Basically the user has taken a backup of...

HI All I'm sure this has been brought up many times before, but I need a little help ordering my recordset by numerical characters. Basically I have ordered my Invoices by Invoice Number but I get this: 1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110 etc. Basically I'm...

Hi All I'm fairly new to access, but I have built ASP pages to interface with an Access back end in the past. The problem is I just upgraded my PC and now have XP Home so I can't locally host a website. My problem should be fairly simple to you guys though: I have a database that consists of...

Hi All I have a situation where I would like to merge multiple recordsets on one page. Basically I have 2 tables - Invoices an Credits, I am trying to put together a 'Statement' page which shows activity on an account by date. So I would like to have something that looks like this: INV1____...

Hi all I have done a very basic calculation: strDriverPay=(strNetTotal/100)*strDriverPayRate This basically calculates how much to pay a delivery driver based on a percentage (strDriverPayRate) of the sales invoice he delivered. The problem is that sometimes that when I display the result...

Cheech Are you putting this straight into the code or using the DMX recordset query? Cheers

Hi Cheech Sorry, small syntax error in my original post. The dates are saved as Date format in access, so when I use '#varStartDate#' I get a data type mismatch, but if I use #varStartDate# I get a syntax error! Any ideas? Cheers

Hi again all I have a simple invoice page which contains invoice details and a company logo. I would like to be able to send this page by e-mail to customers. Unfortunately this page is not uploaded to the internet, it is a local IIS website and therefore the image is held locally. At the...

I am still having problems retrieving records that are between 2 dates! This is what I have done: ==================================================== SELECT * FROM Invoices WHERE InvoiceDate BETWEEN 'varStartDate' AND 'varEndDate' ORDER BY InvoiceDate VARIABLES: varStartDate 1...

I can't seem to get this to work at all. No matter which way I try to do it, I get no records being shown HELP PLEASE!!!!! Thanks Sinista