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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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... -
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...- lowtide
- Thread
- Replies: 0
- Forum: Adobe: Freehand
-
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- lowtide
- Thread
- Replies: 0
- Forum: Microsoft: Office
-
-
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="#ffffff" leftmargin="0" rightmargin="0"...- lowtide
- Thread
- Replies: 3
- Forum: HTML, XHTML & CSS
-
Alpha-numeric only
Thanks kapok, The ^ was what I needed. One more question. How would I also include "_"'s and "-"'s ? -
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("[a-z0-9]",$request)){ ..... (error code)...... What am I doing wrong. Shouldn't this tell me if there are nonalpha-numeric characters... -
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...- lowtide
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
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 > "" 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>...- lowtide
- Post #5
- Forum: Microsoft: ASP (Active Server Pages)
-
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>...- lowtide
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
Querying date field in database?
Sorry about that.<br> It's SQL Server 7.- lowtide
- Post #3
- Forum: Microsoft: ASP (Active Server Pages)
-
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...- lowtide
- Thread
- Replies: 2
- Forum: Microsoft: ASP (Active Server Pages)
-
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 <BR> 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...- lowtide
- Thread
- Replies: 4
- Forum: Microsoft: ASP (Active Server Pages)
-
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... -
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 -
SQL extreme newbie question
Thanks for everyones comments.<br> I think I am getting a good handle on<br> the database concept now from all your<br> help and all the reading I've been doing.<br> <br> Thanks,<br> Perry -
Parsing form data
I am having trouble parsing the form data of a text field.<br> What I have is a form that is populated with default values<br> that the user can edit.<br> But when one of the fields is edited and the form is sent on<br> to the next page only one of my field variables is parsed leaving me<br>... -
Directory listing question
I am using the following code to extract the images from a directory and place them in a table. It works fine except that the "." and ".." lines from the directory are also read as seperate files. I only want it to show .gif and .jpgs.: <br> $ptr=opendir($path.$sport); <br> while ($file =... -
SQL extreme newbie question
Thanks Mike,<br> I think that will work.<br> That would also give me some room to work if I want to later add an email table or other feature.<br> One other question.<br> For the headline text field what would be the best datatype definition to use. Some of the stories get pretty big (well over... -
SQL extreme newbie question
Exactly!<br> Now my question is how to do the multiple joins between all 13 sport tables. I am using MySQL which does not support views, which if I'm not mistaken would be the way to go. Perhaps at this point it would be a better question for the MySQL forum. I'll post there also.<br> Thanks
