Recent content by AndyApp

Not sure if this is the best place for this question but does anyone know of a program that will re-size images automatically? Our client wants to be able to call the program from his internal system (called TaskCentre, just seems to run programs and tasks at a specified time), re-size a bunch...

I managed to solve it. I was being a fool! I didn't need to inner join so many tables that were causing the duplicates for this particular search. doh! thanks for the help

yeah it's a bit awkward but I am paginating the results. It doesn't display all 300,000 as a lot are duplicates. I loop through them and just display each record once.

The search is working ok for searches that bring back less results. however, when i took GetRows out and just printed the ID straight from recordset it fell over as well. i.e. instead of GetRows i just did response.write(ors.fields("id")). This worked for the smaller search but still failed for...

Is there a limit to the amount of data that GetRows will bring back? I've two versions of my site and two sets of data. The development version works perfectly but the live one is falling over at the getrows statement. When I changed the development site to look at the live data it too fell...

Can someone tell me why this script isn't running properly in Firefox yet it does in IE: var s = ""; var queryString = window.location.href.substring((window.location.href.indexOf('?') + 1)); var array1 = queryString.split('&'); // Each array element is in format "fieldname=value" for(var i =...

here's the SQL i've currently got: SELECT Profiles.ID, Profiles.CompName, Profiles.CompOutline, Profiles.CountryID, lkp_Country.ID AS CountryID, lkp_Region.CountryID AS RegionCountryID, lkp_Region.ID AS RegionID, FieldChosen.ProfileID, FieldChosen.TrainerRefinedJoinID, lkp_TrainerRefinedJoin.ID...

Hi Can someone help me please. My SQL isn't up to scratch. I'm having to bring back data from a number of tables that are linked via IDs etc. The main table 'Profiles' is linked to 'RegionChosen'. There can be many regions to one profile. There's also a 'FieldChosen' table which is also...

I was sure i'd tried that. anyhow it worked, didnt think it would be that easy. cheers clflava

I'm pulling data back from SQL to ASP at the moment via two recordsets but I'm having trouble paging with two recordsets so am wondering if there's a way to combine the SQL as they look at the same things anyway. It all pivots around a 'ListingType' column that is either 1 or 2. When the...

cheers sheco and eyeswideclosed decided given i'd have to save the data eventually may as well use the database option. I just put a flag on the data to stop it going live till it conforms. cheers guys and gals.

festerSXS - I thought about using sessions but are they not intensive on the server? What the users are filling in is a kind of CV, but some of the fields could be quite a few paragraphs of data. DotNetGnat - didn't want to rely on javascript for the validation for the reason festersxs gave.

As the querystring is limited to the amount of characters you can place in it, and I'd sooner not user it if I can help it anyway, is there another way for me to move text from one page to another? I've got a form that when a user submits it takes the data to an ASP page which then checks...

I've got a search page and whatever the user puts in is subsequently built into a SQL statement in the LIKE clause. So if someone wants to search for "peter piper" my SQL looks like LIKE '%peter%%piper%'this is great however some of the entries are 'piper, peter' and the statement doesn't seem...

So, let me just check, whereas before I was doing: FOR EACH a in b.getElementsByTagName("Thing1") ..do stuff FOR EACH z IN a.getElementsByTagName("Thing2") ...do more stuff NEXT NEXT I now do: FOR EACH a in b.getElementsByTagName("Thing1") ..do stuff SET z =...