Jump to content

Archived

This topic is now archived and is closed to further replies.

carlg

PHP and MS SQL Problem

Recommended Posts

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



Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.