Sql with 2 variables

Results 1 to 2 of 2

Thread: Sql with 2 variables

  1. #1
    Join Date
    Dec 1969

    Default Sql with 2 variables

    Using DW MX2004 server-side VB Script, I am trying to retrieve a factor from an Access 2000 table, tbl_AdjustBy. The table has 48 rows (column named width) and 96 columns which are named 1,2,3,4,5, etc to 96.<BR><BR>From a form on an input page, a user types in two values, width and length. In the server page code the two values are set to SQL variables MMRowParam and MMColParam.<BR><BR>The SQL is SELECT MMColParam<BR> FROM tbl_AdjustBy<BR> WHERE tbl_AdjustBy.length = &#039;MMRowParam&#039;<BR>Variables:<BR>MMRowPa ram 1 Request.Form("Width") <BR>MMColParam 1 Request.Form("Length") <BR><BR>The result returned is not the table factor, the result is the name of the field in MMColParam!<BR><BR>Any suggestions?<BR><BR>TIA,<BR><BR>Robert<BR>

  2. #2
    Join Date
    Dec 1969

    Default Wrong forum and crosspost...

    Answered in DB forum.<BR><BR>

Posting Permissions

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