Inserting into memo field with ODBC

Anon

I've got an Access database where I'm trying to insert a block of text over 255 characters. When I try to execute the following code:

$query = "INSERT INTO $savesection (HEADLINE, SUMMARY, STORY, LINK, STORYDATE, ARCHIVE) VALUES ('$headline', '$summary', '$story', '$templink', '$temp', '0') ";

$stmt = odbc_prepare($link, $query);
if(odbc_execute($stmt)){
print "<h3>Thank you for submitting news</h1>";
}else{
print "<h3>There was an error submitting news item. Please contact web administrator for more help</h3>";
}

the data isn't inserted into the table at all. I've triple checked all field/table names as well as the driver. In fact, it works just fine if I put < 255 characters in the STORY field. Over 255 and it just doesn't do it.

Anyone have any ideas? Thanks in advance.

edwardsbc

Have you tried using odbc_exec instead of odbc_prepare/odbc_execute? The php manual user comments for odbc_prepare implies there are some problems with certain databases.

Try this and see what happens:

if(odbc_exec($link,$query)) { ....

Anon

I checked the manual entry for odbc_prepare and most of the problems seem to be centered around DB2, not Access. But I figured, "What the heck! I'll try anything once!" and followed your suggestion (execpt with odbc_do instead of odbc_exec as per the user comments on prepare).... still no luck.

Any other ideas?

edwardsbc

Perhaps there is a problem with the text you are attempting to insert. For example, if it contains single quotes you need to escape those quotes. Did you pass $story through addslashes()?

The magic_quotes setting in the PHP.INI also has an effect on single quotes being inserted into databases. Probably want to read the manual on that too.

Do you get an error message at all? If so, please post it.