Jump to content


Photo

PHP and MS SQL Problem


  • Please log in to reply
No replies to this topic

#1 carlg

carlg
  • Members
  • PipPipPip
  • Advanced Member
  • 104 posts
  • LocationPA

Posted 18 April 2006 - 10:52 PM

I am using Microsoft SQL and PHP.

I have the following code



$sql = "SELECT j.Title AS title, j.JobType AS type, j.Location AS location, j.Requirements AS requirements,
j.SpecialRequirements AS special, j.Background AS background, CONVERT(TEXT,j.Description) AS description,
c.CategoryName AS category, c.JobCategoryID AS category_id
FROM tbJob j
INNER JOIN tbJobCategory c ON j.JobCategoryID = c.JobCategoryID
WHERE JobID = " . $job_id;
$result = $job_db->getRow($sql, DB_FETCHMODE_ASSOC);
print $result['requirements'];



The requirements field is a char(1000) in the database. When I select the row with query analyzer, it looks fine. So the data is stored in the DB properly.

When I print out requirements after the fetch, it gets truncated. Only the first 200 or 300 bytes display. Where should I start looking to debug this?

Any help is appreciated

Thanks
Carl








0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users