building dynamic queries?

Results 1 to 2 of 2

Thread: building dynamic queries?

  1. #1
    Join Date
    Dec 1969

    Default building dynamic queries?

    hi.i have some fields on my asp page on the selection of which i want my queries to be formed.<BR><BR> is there any way to build a dynamic query? i tried the oracle tutorials but couldn&#039;t make head or tail out of it.;) <BR><BR> please help

  2. #2
    Join Date
    Dec 1969

    Default You can do all this in ASP, if your...

    ...database supports standard SQL. I haven&#039;t used Oracle myself, so I don&#039;t know whether it does.<BR><BR>Basically you build your SQL statement from the form values (Request.Form or Request.QueryString, depending on the form method), then open a connection to the database and then open a recordset. Then you can play with it whichever way you like. Then close everything.<BR><BR>Oliver.

Posting Permissions

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