Nested DRW's

S

Stephen Green

Is it possible to place one DRW inside another?

When I try I get this error:

Microsoft VBScript compilation error '800a03ea'
Syntax error
H:\HSHOME\SGREEN0\ANMT.ORG\MEMBERS\../_fpclass/fpdblib.inc, line 3
Sub FP_SetLocaleForPage

Thanks.

Stephen
 
J

Jon Spivey

Hi Stephen,

You shouldn't need to. Can you tell us exactly what you're looking to do
(table structure, data you want returned etc) I'll bet it can be
accomplished more efficeiently with joins in your SQL.
 
S

Stephen Green

Well, the page (or this part of it) looks like this:

With this SQL query (SELECT * FROM Coming_Attractions), I fill a table with
rows of notices depending on the users status (which I ascertained earlier
on and save as variables).

After one of the conditional rows, I'd like to add a schedule of events for
those people with this query - SELECT Format(date, "ddd, mmm d") as fmtdate,
TimeSlot, Type, Group, Material FROM Workshop_Schedule WHERE date BETWEEN
DATE() AND (DATE() + 30) ORDER BY
Workshop_Schedule.date,Workshop_Schedule.timeslot

This second query works separately, but not nested inside the other. There
is no linked field between the two tables.

Is that enough info?

Thanks.

Stephen
 
Top