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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by lowtide

  1. lowtide

    my.cnf optimizing MySQL

    Just wondering if anybody has a suggestion for tweaking the my.cnf file to reflect my server set-up. I'm running Dual pentium III 550, 1G Ram, mirrored 8G SCSI HD. Connections to the server are all through PHP about 90% SELECTS and 10% INSERTS/UPDATES. It is a college sports site so I get some...
  2. lowtide

    View thumbnails of FH5 files

    I have the clipart disc from an old Freehand 5 cd (totally legal, not pirated) that I used several years ago but have long since lost the application cd. I currently use Illustrator and no longer use Freehand. I would like to find a way to easily preview the clipart on the old Freehand disc...
  3. lowtide

    Excel 2000: "Unable to read file" after installing SP3

    Has anyone seen this problem? After installing the Office 2000 service pack 3 I can no longer open previously created files in Excel. I get a "Unable to read file" error. I can create and open new files with no problem. Thanks
  4. lowtide

    Right margin in Netscape

    Yep, that's it. Thanks
  5. lowtide

    Right margin in Netscape

    I am trying to create a table that covers the full width of the browser window. My code works fine in IE but in Netscape there is a margin on the right side. I am using the following for my body tag: <body bgcolor=&quot;#ffffff&quot; leftmargin=&quot;0&quot; rightmargin=&quot;0&quot...
  6. lowtide

    Alpha-numeric only

    Thanks kapok, The ^ was what I needed. One more question. How would I also include &quot;_&quot;'s and &quot;-&quot;'s ?
  7. lowtide

    Alpha-numeric only

    I am trying to check a string to make sure it contains only alpha-numeric characters. I have tried the following, but it does not work: if (!eregi(&quot;[a-z0-9]&quot;,$request)){ ..... (error code)...... What am I doing wrong. Shouldn't this tell me if there are nonalpha-numeric characters...
  8. lowtide

    Querying date field in Access database?

    I need to query an Access db for all of<br>the rows that match a specific month and year only<br>in a smalldate field. What is the best way<br>to format the WHERE clause of the sql statement?<br>I would like to use the moth as a 2 digit number<br>and year as a 4 digit number.<br><br>I have tried...
  9. lowtide

    Formatting data in HTML from memo field

    Nick,<br> The problem wasn't in the replace function after all.<br> I was doing an If memofield &gt; &quot;&quot; to verify if that field<br> had any content, which is obviously wrong. After I fixed<br> that part the original solution that noodle gave above<br> worked fine.<br> <br> Thanks,<br>...
  10. lowtide

    Formatting data in HTML from memo field

    That worked fine with the script I am using on an access database. But when I try to use it with a different script on a text field of a SQL 7 database I get the following error:<br> <br> Microsoft VBScript runtime error '800a005e' <br> <br> Invalid use of Null: 'replace' <br> <br>...
  11. lowtide

    Querying date field in database?

    Sorry about that.<br> It's SQL Server 7.
  12. lowtide

    Querying date field in database?

    I have a date in the format mo/da/year (i.e. 3/12/2000).<br> I would like to query a database field with datatype <br> smalldatetime. Do I need to do some additional formatting<br> of the date to query for all records that occur on this<br> day? I know I can query using a format like Mar 12...
  13. lowtide

    Formatting data in HTML from memo field

    I am trying to retrieve data from a memo field in an access db to format into an html page. My problem is I need to replace the end of line characters with &lt;BR&gt; tags. When I view the source code of the resultant html page the hard returns are there, so I know they are coming out of the...
  14. lowtide

    Strange problem with integer "127"

    I have a strange problem.<br> In a table I have a field with a datatype tinyint(3).<br> In one of my rows the number that I input is 131 but<br> for some reason it will not allow me to change it to<br> anything but 127! I have tried different numbers and none<br> seem to work.<br> Has anyone...
  15. lowtide

    Parsing form data

    Thanks Damon,<br> But I figured it out.<br> It was just a simple syntax error.<br> <br> Thanks anyway,<br> Perry

Part and Inventory Search

Back
Top