trying to pass two variables to a detail page??

[AS Dawg]

I am trying to generate an invoice for the customer while the techniian is
in the home. Got the most of it figured out except getting the incoice to
show to correct "workID"

I have figured how to pass two variables to a detail page (MemberID is the
customer name, and workid is the work/service order number)

/invoice.asp?memberID=104&WorkID=20

but on the invoice show the correct customer but workid #1 which is the
first record in the DB table associated with h "work orders"

Not sure how to write the SQL for it, and thoughts. This is what I thought
would work..thought wrong :(

SELECT *
FROM Members, WorkHours
WHERE Members.memberID AND Workhours.WorkID = MMColParam

MMColParam 1
Request.QueryString("Members.memberID ,Workhours.WorkID ")

Please help....
Thanks,
b

[Drew]

Can you give us more info, like the structure of your db? What columns are
in WorkHours? In Members?

Thanks,
Drew

"AS Dawg" <asdawgNOTHERE@tampabay.rr.com> wrote in message
news:d337k5$mvj$1@forums.macromedia.com...

>I am trying to generate an invoice for the customer while the techniian is
>in the home. Got the most of it figured out except getting the incoice to
>show to correct "workID"
>
> I have figured how to pass two variables to a detail page (MemberID is the
> customer name, and workid is the work/service order number)
>
> /invoice.asp?memberID=104&WorkID=20
>
> but on the invoice show the correct customer but workid #1 which is the
> first record in the DB table associated with h "work orders"
>
> Not sure how to write the SQL for it, and thoughts. This is what I thought
> would work..thought wrong :(
>
> SELECT *
> FROM Members, WorkHours
> WHERE Members.memberID AND Workhours.WorkID = MMColParam
>
> MMColParam 1 Request.QueryString("Members.memberID
> ,Workhours.WorkID ")
>

> Please help....
> Thanks,
> b
>
>
>