|
Subject:
|
Memo field not displaying
|
|
Posted By:
|
meichmann
|
Post Date:
|
11/30/2005 9:59:53 AM
|
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!
Matt
|
|
Reply By:
|
sqlhead
|
Reply Date:
|
3/21/2006 1:04:41 AM
|
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,
derek
|
|
Reply By:
|
jcarmona
|
Reply Date:
|
7/31/2006 10:49:34 AM
|
Insted of use de sql statement "SELECT * FROM table" use "SELECT column1, column2 FROM table"
When you retrieve the values use the same order.
|
|
Reply By:
|
BYazici
|
Reply Date:
|
8/31/2006 11:36:13 AM
|
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?
|
