Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Andrzejek on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. AndyApp

    Image resizing

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

    GetRows

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

    GetRows

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

    GetRows

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

    GetRows

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

    Script not working in Firefox

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

    Pants @ SQL

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

    Pants @ SQL

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

    Sort order (I think)

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

    Sort order (I think)

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

    Moving large amounts of text between ASP pages

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

    Moving large amounts of text between ASP pages

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

    Moving large amounts of text between ASP pages

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

    order of LIKE values

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

    NOT looping through elements

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

    NOT looping through elements

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

    Odd page keeps loading error

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

    Odd page keeps loading error

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

    Odd page keeps loading error

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

    Odd page keeps loading error

    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

Part and Inventory Search

Back
Top