I don't get it...

Here is the line of code in jobs.asp:


Here is the line of code in narative.asp:


The problem:

Here is what is displayed in jobs.asp:
"The narative is now a continuing thing. Updating it now does not necisarly overwrite what was previously there; however, you can remove the text if you want.

I've changed it so that the punch lists no longer appear in thier own window. I'm not re "

Here is what is displayed in narative.asp:
"The narative is now a continuing thing. Updating it now does not necisarly overwrite what was previously there; however, you can remove the text if you want.

I've changed it so that the punch lists no longer appear in thier own window. I'm not really a fan of pop up windows. It seemed like a good idea, but if people are just going to view one list at a time, why force them to deal with a new window?

I'm just typing to take up space, to make this longer and longer to see how it works."

As you can see, the message gets cut short. I have no idea why. As far as the ASP goes, both files use the same line of text. Both files pull the data from the same Access database. I simply coppied and pasted the ASP ADO code from one file to the other so it is the same. What other factors could cause this?

I know this isn't enough information to solve the problem, but any ideas as to where I could look for the proble would be great.

Thanks,
Mike.

Access text columns have a max length of 255 characters, that may be your problem.

Well, I'm using a Memo field, so that's not the problem; however, I have managed to figure out that the problem is with my SQL statement that I use to create the record set. here is the statement:

strSQL = "SELECT jobs.job_id, jobs.job_q, jobs.job_title, jobs.job_desc, jobs.job_location, jobs.job_start, jobs.job_end, jobs.job_update, users.user_name, users.user_email, Sum(items.item_hours) AS SumOfitem_hours
FROM (jobs INNER JOIN users ON jobs.job_manager = users.user_id) INNER JOIN items ON jobs.job_id = items.item_job GROUP BY jobs.job_id, jobs.job_q, jobs.job_title, jobs.job_desc, jobs.job_location, jobs.job_start, jobs.job_end, jobs.job_update, users.user_name, users.user_email"

For some reason, this limits the jobs.job_desc field to 256 characters. how can i make it longer? the statement:

strSQL = "SELECT * FROM jobs WHERE job_id=1;"

works fine.

Try putting the memo column as the last selected column in your select list. Some versions of IIS/MDAC seem to choke when blob columns are not the last columns. Also, copy the memo field contents to a local variable then work with just the local variable in your code.

swaggin' here