Passing Param to SQL string

Ask a Question related to ASP Database, Design and Development.

  1. #1

    Default Re: Passing Param to SQL string

    Thanks Bob, for you help and suggestions and please accept my apologies.

    Kind Regards

    Rikesh

    "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    news:ejU17I05DHA.2760@TK2MSFTNGP09.phx.gbl...
    > rikesh wrote:
    > > Hi
    > >
    > > I'm sure this is very trivial, but I simple don't know how to it?
    >
    > I'm sorry that no one has answere this, but it's a very basic question.
    Have
    > you tried Google to search for the answer? That would have proven to be
    much
    > more productive for you than simply waiting for somebody to reply. Going
    to
    > one of the asp tutorial sites, such as [url]www.asp101.com[/url] or
    > [url]www.4guysfromrolla.com[/url], or [url]www.learnasp.com[/url] wiill be equally fruitful.
    >
    > >
    > > I've got a SQL query but I wish to pass a 'WHERE' clause to it, to
    > > filter the recordset.
    > > I've got a textbox on the form, and I hoping tot take the string from
    > > the user and pass it to the SQL string.
    > >
    >
    > This will require the use of a Form and an asp page to process the form
    > submission. There will be examples of this in the links I provided above.
    >
    > In the future, when asking for database-related assistance, make sure you
    > tell us the type and version of database you are using. Future questions
    on
    > this topic should go to microsoft.public.inetserver.asp.db. I have set the
    > follow-ups for this post to that newsgroup.
    >
    > HTH,
    > Bob Barrows
    >
    > P -- ASP/ASP.NET
    > Please reply to the newsgroup. The email account listed in my From
    > header is my spam trap, so I don't check it very often. You will get a
    > quicker response by posting to the newsgroup.
    >
    >

    rikesh Guest

  2. Similar Questions and Discussions

    1. Passing param in Httpservice
      I know i can use the request object in Httpservice to send name-vale pairs to the server.But my problem is not that. I need to remember an ID before...
    2. & in a string to pass through url param
      I am trying to add a list/menu in DW2004, and for each option I need to pass url paramerters the problem I am having is concantinating &amp; in a string...
    3. Passing XML in a string parameter
      We have a parameter to a webmethod that is defined as a string. We expect to pass XML in this string. What we've found out is that the .Net web...
    4. passing string to another frame
      If I am executing a php script, in a given frame...is there a means whereby I can pass a string into another frame, which has php script in it, and...
    5. passing ASP.net Variable string
      This reminds me a question. What advantage or disadvantage by using Context.Items? How is this being handled? "Steve C. Orr, MCSD"...
  3. #2

    Default Re: Passing Param to SQL string

    No apologies are necessary.
    Bob Barrows
    rikesh wrote:
    > Thanks Bob, for you help and suggestions and please accept my
    > apologies.
    >
    > Kind Regards
    >
    > Rikesh
    >
    > "Bob Barrows" <reb01501@NOyahoo.SPAMcom> wrote in message
    > news:ejU17I05DHA.2760@TK2MSFTNGP09.phx.gbl...
    >> rikesh wrote:
    >>> Hi
    >>>
    >>> I'm sure this is very trivial, but I simple don't know how to it?
    >>
    >> I'm sorry that no one has answere this, but it's a very basic
    >> question. Have you tried Google to search for the answer? That would
    >> have proven to be much more productive for you than simply waiting
    >> for somebody to reply. Going to one of the asp tutorial sites, such
    >> as [url]www.asp101.com[/url] or [url]www.4guysfromrolla.com[/url], or [url]www.learnasp.com[/url]
    >> wiill be equally fruitful.
    >>
    >>>
    >>> I've got a SQL query but I wish to pass a 'WHERE' clause to it, to
    >>> filter the recordset.
    >>> I've got a textbox on the form, and I hoping tot take the string
    >>> from the user and pass it to the SQL string.
    >>>
    >>
    >> This will require the use of a Form and an asp page to process the
    >> form submission. There will be examples of this in the links I
    >> provided above.
    >>
    >> In the future, when asking for database-related assistance, make
    >> sure you tell us the type and version of database you are using.
    >> Future questions on this topic should go to
    >> microsoft.public.inetserver.asp.db. I have set the follow-ups for
    >> this post to that newsgroup.
    >>
    >> HTH,
    >> Bob Barrows

    Bob Barrows Guest

Posting Permissions

  • You may not post new threads
  • You may 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