Professional Web Applications Themes

trying to pass two variables to a detail page?? - Dreamweaver AppDev

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 ...

  1. #1

    Default trying to pass two variables to a detail page??

    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



    AS Dawg Guest

  2. #2

    Default Re: trying to pass two variables to a detail page??

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

    Thanks,
    Drew

    "AS Dawg" <asdawgNOTHEREtampabay.rr.com> wrote in message
    news:d337k5$mvj$1forums.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
    >
    >
    >

    Drew Guest

Similar Threads

  1. CF pass variables to Flash
    By lvbao in forum Coldfusion Flash Integration
    Replies: 4
    Last Post: May 8th, 10:26 PM
  2. Can I open a page as a popup using GOTO DETAIL PAGE
    By Don Pacino in forum Dreamweaver AppDev
    Replies: 0
    Last Post: April 9th, 09:42 PM
  3. How to pass variables from aspx page to user control
    By Sathyadeva Aithal via .NET 247 in forum ASP.NET Building Controls
    Replies: 1
    Last Post: June 5th, 08:23 PM
  4. Replies: 0
    Last Post: January 30th, 09:10 PM
  5. Replies: 0
    Last Post: June 30th, 08:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139