
July 9th, 2003, 02:35 PM
|
|
Registered User
|
|
Join Date: May 2003
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
Field size problem...
NOTE: This is not a problem with MySQL, i'm using Access and a SQL string to query the database, but this seemed like the place to ask my question.
PROBLEM:
In my Access database I have a memo field. When I use:
strSQL = "SELECT * FROM jobs WHERE job_id=1;"
to query the jobs table the job_desc field is returned in it's entirety (more than 256 characters). Now, on a different page I have the following SQL statement:
strSQL = "SELECT jobs.job_id, jobs.job_q, jobs.job_title, jobs.job_desc, jobs.job_location, jobs.job_start, jobs.job_end, jobs.job_update, users.user_name, users.user_email, Sum(items.item_hours) AS SumOfitem_hours FROM (jobs INNER JOIN users ON jobs.job_manager = users.user_id) INNER JOIN items ON jobs.job_id = items.item_job GROUP BY jobs.job_id, jobs.job_q, jobs.job_title, jobs.job_desc, jobs.job_location, jobs.job_start, jobs.job_end, jobs.job_update, users.user_name, users.user_email"
In this case, I only get the first 256 characters of the jobs.job_desc field. How can I fix this?
|