Issues with PHP and MS SQL

[carlg]

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. The end of the string is kinda chopped off. Where should I start looking to debug this?

Any help is appreciated

Thanks
Carl

 

[tlhawkins]

This problem could be caused by your database driver. How are you connecting to the MsSQL database?



Travis Hawkins

http://www.bestcodingpractices.com

 

[sleipnir214]

It's also possible that the problem is in the database class you're using.

What is your run environment?


Want the best answers? Ask the best questions! TANSTAAFL!

 

[carlg]

Think I fixed the problem

Thanks

I changed the definition of the database field from char(1000) to text.