Search results for query: *

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

This is probably a really stupid question and i've probably not thought it through, but that hasn't stopped me in the past! I'm getting an XML feed from a website using Server.CreateObject("MSXML2.ServerXMLHTTP") I've then got to move into two elements before I get to the one I want, I then...

ah ok. the background of the results is set to a light grey, as the most searched, so if the results returns more than one they should be seperated by a thing white line, but for some reason it's only showing up when it goes across the thin red vertical lines

Cheers Tarwn, I implemented some of the things and re-wrote parts of it. I can't remember why I put the headings in the include file so I moved them. Used the getrows method. Did the join of the array, and I read the article you pointed to and decided on response.write for the results instead of...

OK, I was trying to avoid posting the code just from a 'it's very long' point of view. But here you go: 'RESULTS INCLUDE FILE PUBLIC caseAnd, caseOf, CaseIf, caseOr, caseTo, caseWhen, caseIT, caseDo, caseFor, caseOn, caseThe, caseIs, CaseI, removed FUNCTION Results() DIM oRS, strSQL, strSearch...

OK I did what Tarwn said with the response.flush. It turns out that it's just taking an age to bring the responses back and write them out. Might have to look at paging the results. thanks for the help