|
|
|
|
|
| | |
| |
Active Server Pages ASP ASP.NET .aspx .ascx Web HTML Developer Internet Microsoft Web Services Visual Studio .NET CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Can you actually retrieve MEMO fields from MS Access 97 DB via ASP? |
|
From: |
Fielding Johnson |
|
Date: |
8/9/1999 10:22:47 PM |
|
IP: |
204.151.245.2 |
Am I going crazy or is it really true that you cannot retrieve MEMO type fields from
MS Access 97 databases via ADO/OLE-DB using Active Server Pages.
I am executing a simple ADO Recordset statement:
(ADescription is the MEMO field name whose portion is to be used as part of a
a drop-down box for a form.)
Code:
Set oRS = Server.CreateObject("ADODB.recordset")
oRS.OPEN "Select Ticket_Num, Customer_ID, Received, ADescription, Status from HDTickets where Status = OPEN", "DSN=HDTickets"
If Not (oRS.BOF And oRS.EOF) then
oRS.MoveFirst
Do While Not oRS.EOF
tDisp = oRS("Ticket_Num") & " "
tDisp = tDisp & lcase(oRS("Customer_ID"))
for idx = 1 to (10 - len(oRS("Customer_ID")))
tDisp = tDisp & " "
next
tDisp = tDisp & oRS("Received") & " "
tDes = CStr(oRS("ADescription"))
If Not IsNull(tDes) then
If len(tDes) < 50 then
for idx = 1 to (50 - len(tDes))
tDes = tDes & " "
next
Else
tDes = Mid(tDes, 1, 50)
End If
Else
tDes = Space(50)
End If
Response.Write "<option value=""" & tTickNum & """>" & tDisp & "</option>" & Chr(13) & Chr(10)
oRS.MoveNext
Loop
End If
oRs.Close
I have tried everything including renaming the field within the database in case the field name
contained a reserved word (field name was originally Call_Description).
HELP!
P.S. I cant return to large text fields because some of my memos are already 2 thousand characters long.
Fielding Johnson
johnsf@fincen.treas.gov |
Follow Up - Re: Can you actually retrieve MEMO fields from MS Access 97 DB via ASP? - Andy 8/10/1999 8:50:51 AM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
