Search results for query: *

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...

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...

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...

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...

Hi Can anyone help me with this relatively simple question? I would like to display on a page a repeating region which shows all records that are between 2 dates. I was thinking of having a form where you enter StartDate and EndDate and the records shown below this form are only those that...

Hi All - I am in desperation. Using Dreamweaver MX and MS Access I have put together a web application using ASP VB Script. When building this app, I was using a machine with Windows 98 and PWS. I am trying to move this application onto a machine running Windows XP Pro and IIS 5.1. I have set...

Hi Again All I have successfully managed to create a page that updates 2 tables and inserts into another. I did this by following Cheech's advice and having a seperate page which read in the variables, then did the inserts. I combined his advice with a DRDEV article on building Update Stored...

Hi All This is hopefully my last question for my current project. The problem is one that I know has been addressed many times on these forums and various tutorial websites, but I can’t find the answer now I need it (well not one that I can get to work anyway): I have a form which has a...

I have a page which has a recordset filtered by a session variable (OrderNo), it contains the following data: StockCode – Description – Qty – Total From this page I want to pass the ‘StockCode’ and the Session ‘OrderNo’ to the next page. I then want to filter another recordset on these 2...

Hi Does anyone know how to add together fields in repeating regions. I have a number of repeating regions on a page and I want to display a total at the end. Any tips gratefully received Cheers Sinista

Hi everyone I am having a stab at creating a web application and have hit a sticking point. I have a page which will (eventually) insert a record into the Order Line table. It looks a bit like this: StockCode----Qty----UnitPrice----Total Code1---------2------10----------- **** I want the...