I have a problem; I have a database that is accessible to 2500 employees that uses an ASPRunner interface. A small group in our company enters records into the database, but records are not allowed to be viewed by the rest of the company until a review team reviews each record and changes the status of a publish status field to "Publish".
ASPRunner reserves the SQL "Where" statement for a specific purpose, so I can't seem to use it without messing up ASPRunner's functionality. However, I can't use the "Where" statement to create a database-side query either, because I have a memo field that will be truncated to 255 characters because the database (Access) does not allow a query to contain a full memo field.
I have no idea how to resolve the puzzle. Currently, I have programmed a page that looks like ASPRunner so that it resembles all of the other ASPRunner pages I have posted, but I'd rather just use ASPRunner so that I don't have to custom code these pages. Any suggestions would be most appreciated. Thanks! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=729&image=1&table=forumtopics' class='bbcemoticon' alt='<<' />
