|
 |
asp_databases thread: Multiple memo fields
Message #1 by jmuldoon@q... on Sun, 14 Oct 2001 14:59:17
|
|
I am working with catalog-type listings. For any particular publication I
would like to include or exclude certain information depending on the
interests of the user. The various text blocks could be up to 300 words
each.
I?ve been looking through the Wrox ASP forums on ?memo fields? and see
various problems that can crop up when fields get too large. I really have
to get this up fast and would like to avoid, just for now, getting
into .GetChunks and .appendchunks. SO, I am wondering what kinds of
problems the following two scenarios might cause:
1. A query with One memo field (No more than 300 words) and 3-4 text
fields. Would this work? Does a memo field always have to go at the end of
the select statement?
2. A query with 1-3 memo fields (Up to 300 words each) and 3-4 text fields.
Will greatly appreciate some guidance.
Joe M.
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 15 Oct 2001 19:04:25 +1000
|
|
http://support.microsoft.com/support/kb/articles/Q200/1/24.ASP
and
http://support.microsoft.com/support/kb/articles/Q175/2/39.ASP
and
http://support.microsoft.com/support/kb/articles/Q194/9/75.ASP
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <jmuldoon@q...>
Subject: [asp_databases] Multiple memo fields
: I am working with catalog-type listings. For any particular publication I
: would like to include or exclude certain information depending on the
: interests of the user. The various text blocks could be up to 300 words
: each.
:
: I?ve been looking through the Wrox ASP forums on ?memo fields? and see
: various problems that can crop up when fields get too large. I really have
: to get this up fast and would like to avoid, just for now, getting
: into .GetChunks and .appendchunks. SO, I am wondering what kinds of
: problems the following two scenarios might cause:
:
: 1. A query with One memo field (No more than 300 words) and 3-4 text
: fields. Would this work? Does a memo field always have to go at the end of
: the select statement?
:
: 2. A query with 1-3 memo fields (Up to 300 words each) and 3-4 text
fields.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by jmuldoon@q... on Tue, 16 Oct 2001 14:09:06
|
|
Ken:
Thanks. I checked out the pages. I forgot to mention that I'm using an
Access database. Do you know if the situation is the same?
Joe M.
> http://support.microsoft.com/support/kb/articles/Q200/1/24.ASP
> and
> http://support.microsoft.com/support/kb/articles/Q175/2/39.ASP
> and
> http://support.microsoft.com/support/kb/articles/Q194/9/75.ASP
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: <jmuldoon@q...>
> Subject: [asp_databases] Multiple memo fields
>
>
> : I am working with catalog-type listings. For any particular
publication I
> : would like to include or exclude certain information depending on the
> : interests of the user. The various text blocks could be up to 300 words
> : each.
> :
> : I?ve been looking through the Wrox ASP forums on ?memo fields? and see
> : various problems that can crop up when fields get too large. I really
have
> : to get this up fast and would like to avoid, just for now, getting
> : into .GetChunks and .appendchunks. SO, I am wondering what kinds of
> : problems the following two scenarios might cause:
> :
> : 1. A query with One memo field (No more than 300 words) and 3-4 text
> : fields. Would this work? Does a memo field always have to go at the
end of
> : the select statement?
> :
> : 2. A query with 1-3 memo fields (Up to 300 words each) and 3-4 text
> fields.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
Message #4 by jmuldoon@q... on Wed, 17 Oct 2001 12:23:56
|
|
Ken, anyone else:
I still need clarification on my original concerns. I read the articles
below and I'm not sure they address my specific situatin. (I'm learning
that I'd better specify everything that might apply when I present a
scenario.)
I want to use two or more memo fields with:
1. An Access database
2. Retrieving data with GetRows.
Right now, this SQL statement is working reliably:
sql= "SELECT SuPhotos.PhotName, SuSub_Pho.PhotID, SuPhotos.PhotCont,
SuPhotos.PhotComm " &_
"FROM SuPhotos INNER JOIN (SuSubjects INNER JOIN SuSub_Pho
ON SuSubjects.SuID = SuSub_Pho.SuID) " &_
"ON SuPhotos.PhotID = SuSub_Pho.PhotID " &_
"GROUP BY SuPhotos.PhotName, SuSub_Pho.PhotID,
SuPhotos.PhotCont, SuPhotos.PhotComm ORDER BY SuSub_Pho.PhotID;"
PhotCont is a text field, PhotComm is a memo field. As one of the articles
suggests, these two fields are retrieved (via an array derived from
GetRows) last and in the same order they appear in the SQL statement.
SO...... In this scenario, will I have trouble adding one or two memo
fileds after PhotComm and retrieving in that order. Memo fields won't go
above 300 words.
Thanks,
Joe
Message #5 by "Ken Schaefer" <ken@a...> on Thu, 18 Oct 2001 18:36:44 +1000
|
|
I don't know if you'll have problems...sorry!
I suggest you populate the data, then grab a copy of MS WAST and load test
the application and see what happens...(and then report back to the list!)
My hunch is that with 300 odd words you're looking at 1500-2000 bytes, which
probably isn't a problem.
Cheers
Ken
Message #6 by jmuldoon@q... on Fri, 19 Oct 2001 19:45:22
|
|
Ken:
Thanks for getting back to me. I will proceed as you suggest. I helps to
know that isn't just having the additional memo fields but that the size
is critical. They won't be all that big.
Joe M.
> I don't know if you'll have problems...sorry!
>
> I suggest you populate the data, then grab a copy of MS WAST and load
test
> the application and see what happens...(and then report back to the
list!)
>
> My hunch is that with 300 odd words you're looking at 1500-2000 bytes,
which
> probably isn't a problem.
>
> Cheers
> Ken
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> From: <jmuldoon@q...>
> Subject: [asp_databases] Re: Multiple memo fields
>
>
> : Ken, anyone else:
> :
> : I still need clarification on my original concerns. I read the articles
> : below and I'm not sure they address my specific situatin. (I'm learning
> : that I'd better specify everything that might apply when I present a
> : scenario.)
> :
> : I want to use two or more memo fields with:
> : 1. An Access database
> : 2. Retrieving data with GetRows.
> :
> : Right now, this SQL statement is working reliably:
> :
> : sql= "SELECT SuPhotos.PhotName, SuSub_Pho.PhotID, SuPhotos.PhotCont,
> : SuPhotos.PhotComm " &_
> : "FROM SuPhotos INNER JOIN (SuSubjects INNER JOIN SuSub_Pho
> : ON SuSubjects.SuID = SuSub_Pho.SuID) " &_
> : "ON SuPhotos.PhotID = SuSub_Pho.PhotID " &_
> : "GROUP BY SuPhotos.PhotName, SuSub_Pho.PhotID,
> : SuPhotos.PhotCont, SuPhotos.PhotComm ORDER BY SuSub_Pho.PhotID;"
> :
> : PhotCont is a text field, PhotComm is a memo field. As one of the
articles
> : suggests, these two fields are retrieved (via an array derived from
> : GetRows) last and in the same order they appear in the SQL statement.
> :
> : SO...... In this scenario, will I have trouble adding one or two memo
> : fileds after PhotComm and retrieving in that order. Memo fields won't
go
> : above 300 words.
> :
> :
> : Thanks,
> :
> : Joe
> :
>
|
|
|
View Cart
