What do you mean by specifying field names in reverse order? I have an SQL
code like this:
sql = "select answer from tbl_answer where questionno = '" & qno & "'"
so I am ONLY selecting the memo field ("answer") but it still doesn't come
out in the webpage.
My web is hosted on brinkster. Any idea about this????
> This message is in MIME format. Since your mail reader does not
understand
> this format, some or all of this message may not be legible.
>
> ------_=_NextPart_001_01C0CC05.03A6A6D0
> Content-Type: text/plain;
> charset="iso-8859-1"
>
> Not only should you specify the field names- the memo fields should be
> specified in REVERSE order!
>
>
> Hal Levy
> StarMedia Network, Inc.
> Intranet Development Manager
>
> -----Original Message-----
> From: Larry Schankman [mailto:lschankm@m...]
> Sent: Sunday, April 22, 2001 11:42 AM
> To: ASP Databases
> Subject: [asp_databases] Re: Memo-field data, what am I doing wrong?
>
>
> > Hey all,
> >
> > I'm still strugeling with memo-fields..
>
> Martijn, I'm reluctant to reply since I'm an amateur and have no clue
what
> I'm doing myself...however, I had a similar problem a few months ago and
> read somewhere that with memo fields you have to explicitly declare them
> in the SQL statement (i.e. SELECT * won't work). I also read that it's
> best to declare the memo fields at the very end of the string. Try it
and
> see if it works -- it did work for me.
>
> Cheers,
>
> Larry Schankman
> ---
> SoftArtisans helps developers build robust, scalable Web applications!
> Excel Web reports, charts: http://www.softartisans.com/excelwriter.html
> File uploads: http://www.softartisans.com/saf.html
> Transactional file management: http://www.softartisans.com/saf1.html
> Scalability: http://www.softartisans.com/saxsession.html
> ASPstudio value pack: http://www.softartisans.com/aspstudiosuite.html
> $subst('Email.Unsub')
>
> ------_=_NextPart_001_01C0CC05.03A6A6D0
> Content-Type: text/html;
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable
>
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
> <HTML>
> <HEAD>
> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html;
> charset=3Diso-8859-1">
> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version
> 5.5.2653.12">
> <TITLE>RE: [asp_databases] Re: Memo-field data, what am I doing
> wrong?</TITLE>
> </HEAD>
> <BODY>
>
> <P><FONT SIZE=3D2>Not only should you specify the field names- the memo
> fields should be specified in REVERSE order!</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=3D2>Hal Levy</FONT>
> <BR><FONT SIZE=3D2>StarMedia Network, Inc.</FONT>
> <BR><FONT SIZE=3D2>Intranet Development Manager</FONT>
> </P>
>
> <P><FONT SIZE=3D2>-----Original Message-----</FONT>
> <BR><FONT SIZE=3D2>From: Larry Schankman [<A
> HREF=3D"mailto:lschankm@m...">mailto:lschankm@m...</A>]</FON
> T>
> <BR><FONT SIZE=3D2>Sent: Sunday, April 22, 2001 11:42 AM</FONT>
> <BR><FONT SIZE=3D2>To: ASP Databases</FONT>
> <BR><FONT SIZE=3D2>Subject: [asp_databases] Re: Memo-field data, what
> am I doing wrong?</FONT>
> </P>
> <BR>
>
> <P><FONT SIZE=3D2>> Hey all,</FONT>
> <BR><FONT SIZE=3D2>> </FONT>
> <BR><FONT SIZE=3D2>> I'm still strugeling with memo-fields.. </FONT>
> </P>
>
> <P><FONT SIZE=3D2>Martijn, I'm reluctant to reply since I'm an amateur
> and have no clue what </FONT>
> <BR><FONT SIZE=3D2>I'm doing myself...however, I had a similar problem
> a few months ago and </FONT>
> <BR><FONT SIZE=3D2>read somewhere that with memo fields you have to
> explicitly declare them </FONT>
> <BR><FONT SIZE=3D2>in the SQL statement (i.e. SELECT * won't work). I
> also read that it's </FONT>
> <BR><FONT SIZE=3D2>best to declare the memo fields at the very end of
> the string. Try it and </FONT>
> <BR><FONT SIZE=3D2>see if it works -- it did work for me.</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Cheers,</FONT>
> </P>
>
> <P><FONT SIZE=3D2>Larry Schankman</FONT>
> <BR><FONT SIZE=3D2>---</FONT>
> <BR><FONT SIZE=3D2>SoftArtisans helps developers build robust, scalable
> Web applications!</FONT>
> <BR><FONT SIZE=3D2>Excel Web reports, charts: <A
> HREF=3D"http://www.softartisans.com/excelwriter.html"
> TARGET=3D"_blank">http://www.softartisans.com/excelwriter.html</A></FONT
> >
> <BR><FONT SIZE=3D2>File uploads: <A
> HREF=3D"http://www.softartisans.com/saf.html"
> TARGET=3D"_blank">http://www.softartisans.com/saf.html</A></FONT>
> <BR><FONT SIZE=3D2>Transactional file management: <A
> HREF=3D"http://www.softartisans.com/saf1.html"
> TARGET=3D"_blank">http://www.softartisans.com/saf1.html</A></FONT>
> <BR><FONT SIZE=3D2>Scalability: <A
> HREF=3D"http://www.softartisans.com/saxsession.html"
> TARGET=3D"_blank">http://www.softartisans.com/saxsession.html</A></FONT>
>
> <BR><FONT SIZE=3D2>ASPstudio value pack: <A
> HREF=3D"http://www.softartisans.com/aspstudiosuite.html"
> TARGET=3D"_blank">http://www.softartisans.com/aspstudiosuite.html</A></F
> ONT>
> <BR><FONT SIZE=3D2>---</FONT>
> <BR><FONT SIZE=3D2>
> hal.levy@s...</FONT>
> <BR><FONT SIZE=3D2>
> $subst('Email.Unsub')</FONT>
> </P>
>
> </BODY>
> </HTML>
> ------_=_NextPart_001_01C0CC05.03A6A6D0--
View Cart
