Recent content by CTekGirl

I can't figure this one out. No matter what I do the user files (FIN) are only 'READ ONLY.' I have the following directory attributes: APPS(share) <read,list> USER GROUP - FIN <modify, read,execute,write> USER GROUP - LOAD <modify, read,execute,write> USER GROUP - REPORTS <FULL...

I am not completely clear on what your point is ingresman, but I will respond. Your point is not an issue with this database because of the size. I certainly would not want the syntax nightmare of typing in unique image names to link with an ID field. This is a small database with less than 50...

Thanks for clarifying. I think the 'images' table should have two fields. One to store the ID and one to store the path to the images(QUESTION: should the path be enclosed in quotes?). I did not find a fieldname reference to where these images paths are stored. So I am unclear how the image...

I will attempt this again. I was looking for a method that wasn't so time consuming. It looks like I will not be able to use the report I created. I will try to build this from scratch. I will post if I have more questions.

I was given a project to build a database to work against some previously created PHP code. I would like to recycle some of the PHP code so I don't have to re-write, but the database has to be built from scratch. Can you recommend which forum would be the best to post questions to? I am familiar...

I like the suggestion of littlesmudge of storing the path in the table. I have not created this type of table before so I am uncertain about the tblINI term. I don't mind storing the entire path; because when I complete this I am turning it over to someone to upload, they don't know MySQL at...

I tried the crosstab and it did not give me exactly what I need. So perhaps I did not provide enough information. This report is based on 2 views and 1 table joined. In the report design there are 3 groups(rows) based on depts and sub-grps within the department and dept#. Reporting data only in...

CTekGirl (MIS) Oct 27, 2004 I wanted to provide a comment that I followed TLowder's tips and my server on MySQL is no longer getting connection errors. Thanks for your detail and clear steps. Well Done! I hope it works for the original poster as well.

I wanted to provide a comment that I followed TLowder's tips and my server on MySQL is no longer getting connection errors. Thanks for your detail and clear steps. Well Done! I hope it works for the original poster as well.

Anyone using this version of MySQL?

Sorry I didn't include the version; 8.5

I recently found that I need a table that stores images not text based data. Any suggestions? The tables are already built. Is the image actually stored in the database or there a reference a directory on the server where the file is. IE TABLE 1 PRODUCT_ID - TEXT PRODUCT - IMAGE

Hopefully there is an easy solution to this. I have an older version that seems to work with the same settings. I have install this copy on Windows XP. I created a server called: Name: DEVSQL Host Name: localhost User Name: root Password: blank I am using the MySQL Control Center. It...

I am creating a report based on view of joined tables for a fiscal year report July03- June04; each column only needs to have data for a single month. (DATA is hours worked that month. The DATES are period end dates. ie. June-03 --- through June04 DATA DATA What is the best...

I just created another 'User' contained only in the 'User' group. When I signed on with that user, I get a webpage with no text. For example if you goto msn.com, what I see (signed on as this user) is just colored bars that would be surrounding text, but no text. I do see pictures. The system...