Getting data out of MSSQL

[Anon]

Hi All,

I've stored a web page in MSSQL as a in a normal text field. But when I try to retrieve it and pass it to the browser I only get the first 4000 chars.

I'm guessing this is because the string isn't long enough to store the data in the database field, maybe.

I have one idea how to get around this or perform such a task correctly. Any help would be great.

Nathn.

[[deleted]]

You can change the data type in the table.
type: describe your_table_name
and see what the data type is and how large the field is. Try changing the field to a text type field. Use this command:
alter table your_table_name
change field_name field_name text;

[Anon]

I've looked at this and it is set as text but I'm still not getting what I thought I would.

This is the code I'm using:

$result= @mssql_query("SELECT body FROM news_msg WHERE msgid=$articleid");

$resdata = mssql_fetch_row($result);

echo $resdata[0];

Any other ideas?

Nathan.

[[deleted]]

Well, if you change the table after the data has already been lost it's not going to recover it. Forget about the rest for now.
put this in:

$sql="SELECT body FROM news_msg WHERE msgid=$articleid";
echo "$sql<br>";
$query = mysql_query($sql);
while ($result=mysql_fetch_array($query)){
echo $resdata["body"];
}

I always seperate the sql command in my coding for this reason: If it doesn't work, cut and past the sql command that was printed on the web page directly into the MYSQL command line. If it still doesn't work, you know that it's a MYSQL problem and there's no reason leave the ugly MYSQL command line until you get the results from there. Otherwise, the problem is somewhere in your scripting.

[Anon]

Thanks for your help so far i'm most greatful, but I've still got probs.

I'm able to store the data in the database ok and its all definitly in there because I can see. But when I try and take it out of the database and display it in the browser only shows the first part of the data in the "body" field.

I'm scratching my head!?!

Nathan.