Powerhouse Web
Deskin, Bob
Bob.Deskin@Cognos.COM
Tue, 1 Jul 2003 08:54:22 -0400
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_01C33FCF.E48A60C0
Content-Type: text/plain;
charset="iso-8859-1"
There is a limit of 255 fields on a screen in QUICK (as documented in the
QDESIGN reference manual) and since PowerHouse Web uses the same engine,
you'll have the same limit on a page.
Not sure why you're only getting 100 fields filled in on the page. It may
have something to do with generated ID numbers, but I'd be guessing.
Internally, since PowerHouse Web uses the same engine as QUICK, it also uses
ID numbers for processing. If the field limit is 255, I'd have thought that
the ID processing limit was the same.
On this one, I suggest contacting Customer Support so you can submit a test
case.
If you're putting together text, you may be able to concatenate
items/columns into temporary items and get around the absolute field limit.
Another possibility will be with the new version (available now on
NT/2000/XP and UNIX) is to modify the HTML template to directly reference
the item value of a character item rather than a field. Notice that the
field value references are <!--PH:FIELD:field-name-->. In 2.4x, you can use
<!--PH:ITEM:item-name--> for character items to directly get at the item
value.
Bob Deskin
Product Manager, Application Development Tools
Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 CANADA
bob.deskin@cognos.com (613) 738-1338 ext 7268
-----Original Message-----
From: VAN DE MEERSSCHE Marc
[mailto:marc.vandemeerssche@nationalesuisse.be]
Sent: July 1, 2003 8:35 AM
To: 'powerh-l@lists.swau.edu'
Subject: Powerhouse Web
Question.
We wrote a quick program (qks) that retrieves a lot of data that we want to
use for constructing a pdf-file.
We have +- 500 fields.
By displaying the corresponding html-template, only the first hundred fields
are filled in.
Is there a limit in the number of fields, or must we change it with a
qkgo-file (and how ?) ?
or
Is there a limit in some memory-buffer (like PH:RECORD_ID) ?
Thanks,
Marc
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C33FCF.E48A60C0
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.2654.89">
<TITLE>RE: Powerhouse Web</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>There is a limit of 255 fields on a screen in QUICK =
(as documented in the QDESIGN reference manual) and since PowerHouse =
Web uses the same engine, you'll have the same limit on a =
page.</FONT></P>
<P><FONT SIZE=3D2>Not sure why you're only getting 100 fields filled in =
on the page. It may have something to do with generated ID numbers, but =
I'd be guessing. Internally, since PowerHouse Web uses the same engine =
as QUICK, it also uses ID numbers for processing. If the field limit is =
255, I'd have thought that the ID processing limit was the =
same.</FONT></P>
<P><FONT SIZE=3D2>On this one, I suggest contacting Customer Support so =
you can submit a test case.</FONT>
</P>
<P><FONT SIZE=3D2>If you're putting together text, you may be able to =
concatenate items/columns into temporary items and get around the =
absolute field limit.</FONT></P>
<P><FONT SIZE=3D2>Another possibility will be with the new version =
(available now on NT/2000/XP and UNIX) is to modify the HTML template =
to directly reference the item value of a character item rather than a =
field. Notice that the field value references are =
<!--PH:FIELD:field-name-->. In 2.4x, you can use =
<!--PH:ITEM:item-name--> for character items to directly get at =
the item value.</FONT></P>
<P><FONT SIZE=3D2>Bob =
Deskin =
</FONT>
<BR><FONT SIZE=3D2>Product Manager, Application Development =
Tools</FONT>
<BR><FONT SIZE=3D2>Cognos Inc. 3755 Riverside Drive, Ottawa ON K1G 4K9 =
CANADA</FONT>
<BR><FONT SIZE=3D2>bob.deskin@cognos.com (613) 738-1338 ext 7268</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: VAN DE MEERSSCHE Marc</FONT>
<BR><FONT SIZE=3D2>[<A =
HREF=3D"mailto:marc.vandemeerssche@nationalesuisse.be">mailto:marc.vande=
meerssche@nationalesuisse.be</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: July 1, 2003 8:35 AM</FONT>
<BR><FONT SIZE=3D2>To: 'powerh-l@lists.swau.edu'</FONT>
<BR><FONT SIZE=3D2>Subject: Powerhouse Web</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Question.</FONT>
</P>
<P><FONT SIZE=3D2>We wrote a quick program (qks) that retrieves a lot =
of data that we want to</FONT>
<BR><FONT SIZE=3D2>use for constructing a pdf-file.</FONT>
<BR><FONT SIZE=3D2>We have +- 500 fields. </FONT>
</P>
<P><FONT SIZE=3D2>By displaying the corresponding html-template, only =
the first hundred fields</FONT>
<BR><FONT SIZE=3D2>are filled in.</FONT>
</P>
<P><FONT SIZE=3D2>Is there a limit in the number of fields, or must we =
change it with a</FONT>
<BR><FONT SIZE=3D2>qkgo-file (and how ?) ?</FONT>
<BR><FONT SIZE=3D2>or</FONT>
<BR><FONT SIZE=3D2>Is there a limit in some memory-buffer (like =
PH:RECORD_ID) ?</FONT>
</P>
<P><FONT SIZE=3D2>Thanks,</FONT>
<BR><FONT SIZE=3D2>Marc</FONT>
</P>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
<P><FONT SIZE=3D2>This message may contain privileged and/or =
confidential information. If you have received this e-mail in =
error or are not the intended recipient, you may not use, copy, =
disseminate or distribute it; do not open any attachments, delete it =
immediately from your system and notify the sender promptly by e-mail =
that you have done so. Thank you.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C33FCF.E48A60C0--