Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server ASP
| Search | Today's Posts | Mark Forums Read
SQL Server ASP Discussions about ASP programming with Microsoft's SQL Server. For more ASP forums, see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old November 30th, 2005, 10:59 AM
Authorized User
Join Date: Jul 2004
Location: Burlington, NJ, USA.
Posts: 16
Thanks: 0
Thanked 2 Times in 2 Posts
Send a message via ICQ to meichmann Send a message via AIM to meichmann Send a message via Yahoo to meichmann
Default Memo field not displaying

Hello everyone!
     My knowledge of SQL is somewhat limited. Most of my database experience is with Acess, so please bear with me as I try to explain this the best way I can:

     I have a database that stores events (social gatherings, meetings, etc...). Originally, this database was made in Access, but was converted over to SQL server. Since the migration, One onf the columns does not produce any data in my .ASP page. The column in question is a memo field. here is a list of the fields we are currently are using

Column Name Data type Length

CountyEventKey int 4
DeptName varchar 256
StartDate varchar 256
EndDate varchar 256
DisplayDate varchar 256
EventTime varchar 256
Subject varchar 256
Admission varchar 256
EventDesc ntext 16
DeptKey int 4

The EventDesc column is the one not displaying information. Presently, the SQL statement is as follows:

"SELECT * FROM tblCountyEvent WHERE CountyEventKey = " + Replace(rsCurrentMonth__MMColParam, "'", "''") + ""

I thought I remembered something about fields being individualy selected when a field type "memo" is present.

Does anyone have any insight?

Thank you for your time in advance!

  #2 (permalink)  
Old March 21st, 2006, 02:04 AM
Registered User
Join Date: Apr 2005
Location: Shelbyville, KY, USA.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts

out of BOL 2005...

If an ntext, text, and image data value is no longer than a Unicode, 4,000 characters; character, 8,000 characters; or binary string, 8,000 bytes, the value can be referenced in SELECT, UPDATE, and INSERT statements much the same way as the smaller data types. For example, an ntext column with a short value can be referenced in a SELECT statement select list the same way an nvarchar column is referenced. Some restrictions that must be observed, such as not being able to directly reference an ntext, text, or image column in a WHERE clause. These columns can be included in a WHERE clause as parameters of a function that returns another data type, such as ISNULL, SUBSTRING or PATINDEX, or in an IS NULL, IS NOT NULL, or LIKE expression.

hope this helps,

  #3 (permalink)  
Old July 31st, 2006, 10:49 AM
Registered User
Join Date: Jul 2006
Location: Juarez, Chihuahua, Mexico.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jcarmona

Insted of use de sql statement "SELECT * FROM table" use "SELECT column1, column2 FROM table"

When you retrieve the values use the same order.

  #4 (permalink)  
Old August 31st, 2006, 11:36 AM
Registered User
Join Date: Aug 2006
Location: , , .
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts

quote:Originally posted by jcarmona
 Insted of use de sql statement "SELECT * FROM table" use "SELECT column1, column2 FROM table"

When you retrieve the values use the same order.
I have tried that, but it doesn't work..

I'm having the exact same problem as meichmann. For some unknown reason to me, I can't pull out simple int's money and datetime values, they are just coming out as NULLs even though it's returning half the data

Anyone have any ideas?

Similar Threads
Thread Thread Starter Forum Replies Last Post
Memo Field Brendan Bartley Access 11 December 13th, 2007 04:28 PM
MEMO FIELD! With VB6 rolandatem Pro VB Databases 2 January 28th, 2005 10:49 PM
Pagefault from memo field dave_pollak Access VBA 0 November 24th, 2004 10:25 AM
Field format from Text to Memo sassenach Classic ASP Databases 0 July 24th, 2003 06:19 AM
displaying a memo in a textarea jhunta Classic ASP Basics 1 June 9th, 2003 11:04 PM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.