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!

Register Log in
  • Congratulations Chriss Miller 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. philclare

    Using fsockopen to retrive compressed HTML page

    Hi, I am using fsockopen to retrieve an HTML page that has been compressed, but when I try and decompress the string I get the following error : Warning: gzuncompress() [function.gzuncompress]: data error I found a bug report on the PHP pages at sourceforge that said it was something to do...
  2. philclare

    Load file from mapped network drive

    Hi, I am trying to load an XML file from a mapped network drive (w in this instance) but the MSXML component is reporting that the "system cannot locate the specified file". Any ideas? Thanks Phil Clare Hope this helps, Phil Clare http://www.trinipoint.co.uk
  3. philclare

    Calculating the minimum value in a set of columns

    Well as it turns out my columns are in order so I can gut the lowest by using COALESCE (since that returns the first value that isn't null) Thanks anyway Hope this helps, Phil Clare http://www.trinipoint.co.uk
  4. philclare

    Calculating the minimum value in a set of columns

    Hi, Is there any way to select the minimum value in a set of columns in a single row. eg. I have a table with 6 numeric fields, some of which may be null, and I want to find the lowest number in these fields for each row... I can find the first number by using COALESCE but not the lowest Any...
  5. philclare

    Reading a file sequentially

    Well, the file is a list of SQL statements but I can't do an import in phpmyadmin or anything because the upload times out due to my ISP, the script is only for me to use and will be in a password protected folder so I don't have to worry about other people using it. I think the record counter...
  6. philclare

    Reading a file sequentially

    Hi, I have a file consisting of a number of lines of text, I want to read the file in order and execute some code based on the content of each line. My problem is that I only want to access each line once and because of the size of the file, my script times out, so only gets so far down the...
  7. philclare

    Getting Count of all rows when using LIMIT

    Is there anyway that I can get the number of rows that a query would have returned if I hadn't used the LIMIT clause? I have a database with 6000 records and when I execute a query I want to page the results, but also need to know how many results there are altogether so that I can work out how...
  8. philclare

    Hi, I want the data that is ent

    You are missing some bits of your SQL: # setup SQL statement $sql = " INSERT INTO " . $_POST['dropdownselection'] . " "; $sql .= " (PART_NUMBER, MACHINE, NEED_DATE, NOTES)VALUES "; $sql .= " '$PART_NUMBER','$MACHINE','$NEED_DATE','$NOTES') "; should...
  9. philclare

    only show 10 newest records

    in your select query do SELECT * FROM newstable ORDER BY newsdate LIMIT 10 Hope this helps, Phil Clare http://www.trinipoint.co.uk
  10. philclare

    Modifying Multiple Records Functions

    You might need to wrap your regexes in delimiters i.e. change them to: $string2 = preg_replace("/\n(.)/e", strtoupper('\\1'),$string2); $string = preg_replace("/\b(.)/e", strtoupper('\\1'),$string); Hope this helps, Phil Clare http://www.trinipoint.co.uk
  11. philclare

    SQL UPDATE command

    sorry, just noticed that they are timestamps and the first one is automatically updated... sorry to waste time, thanks for the response sleipnir I guess that is where you were going!
  12. philclare

    SQL UPDATE command

    I have a table in my mySQL database consisting of a number of fields including two date fields. In a page I perform an update changing the value of one field, however the update also changes the value of the first date field to NOW() (i.e. today's date). It doesn't however update the second...
  13. philclare

    Adding Zeroes to a string value

    string("0",3) creates a string of 3 zeroes... simply concatenate that onto the beginning of the string Hope this helps, Phil Clare http://www.trinipoint.co.uk
  14. philclare

    How can I show the page title

    response.write &quot;<title>mytitle</title>&quot; Hope this helps, Phil Clare http://www.trinipoint.co.uk
  15. philclare

    I'm trying to use this code as a hy

    Hi Paul I dunno, try changing it to this (remove all the jscript) <a href=&quot;KBUpdate.asp?KBID=<%response.write(iEdit)%>&Delete=y&quot; target=&quot;DELETE&quot;><img src=del.gif title=&quot;Click to delete entry&quot;></a> The only problem with this is that you won't be able to switch off...
  16. philclare

    I'm trying to use this code as a hy

    try <a href=&quot;javascript:window.open('KBUpdate.asp?KBID=<%response.write(iEdit)%>&Delete=y','DELETE','toolbar=no,statusbar=no,scrollbar=no')&quot;><img src=del.gif title=&quot;Click to delete entry&quot;></a> Hope this helps, Phil Clare http://www.trinipoint.co.uk
  17. philclare

    posting data to same form

    Hi Patrick, Unfortunately if a disabled field is disabled the data does not get submitted as part of the form. If you don't want the user to see it try using a hidden field (type=&quot;hidden&quot;) or if you do want them to see it, use a label and a hidden field to the same effect. Thanks...
  18. philclare

    loaded new 5.5 scripting engine - now PWS not working - please help!

    Hi, try reinstalling the nt option pack to reinstall pws Hope this helps, Phil Clare http://www.trinipoint.co.uk
  19. philclare

    server validation - getting drop downs to reflect value

    Hi, There are a couple of things wrong here: firstly, you need to check whether your form method is POST or GET (it's usually post but your code seems to be assuming a GET method) if it using POST then you need to change request.querystring to request.form whenever you use it to access a form...
  20. philclare

    reply to header using CDONTS

    Hi, that's not possible I'm afraid, it depends entirely upon the software that the email is being read in. As far as I know what you are trying to do is impossible Thanks Hope this helps, Phil Clare http://www.trinipoint.co.uk

Part and Inventory Search

Back
Top