SQL statement

Results 1 to 3 of 3

Thread: SQL statement

  1. #1
    Steve G Guest

    Default SQL statement

    In Java it is possible to run a SQL statement such as the following:<BR>select * from my_table where a = ?<BR>and then set ? equal to a value.<BR><BR>Is this possible in ASP?

  2. #2
    Eddie Campbell Guest

    Default RE: SQL statement

    Yes, like this<BR>&#060;% StrValToFind="Mushrooms"<BR> StrSql = "select * from my_table where a = &#039" & StrValToFind & "&#039"<BR>%&#062;<BR>Note that becuase I have assumed that your field a is a text field, I have surrounded it in single quotes(&#039).<BR>

  3. #3
    Steve G Guest

    Default RE: SQL statement

    Actually I was looking for how to use the SQl statement:<BR><BR>select * from my_table where a = ?<BR><BR>and leave the ? in there. I have found a solution now.<BR><BR>Thanks for your help,<BR><BR>Steve

Posting Permissions

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