Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Geoff Doyon (GeoffDoyon_at_discussions.microsoft.com)
Date: 03/01/05 

Date: Tue, 1 Mar 2005 14:33:02 -0800

Hello!

I have successfully configured a submission and query page in FP to a SQL
server using aspx pages. However, I would like the query page to be able to
accept a parameter from the user. For instance, I would like the user to
query the database using a "Ticket ID'. I have tried dropping a text box
with a [Submit] button, but I get yelled at by FrontPage saying the text box
will not work with aspx pages. Knowing that I want to keep the asp.NET
pages, how do I allow the user to query given a criteria? I look foward to
your assistance!

Geoff

Relevant Pages

  • Re: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... Full text does not perform with a nested loop because the search is done for each iteration, if your server doesn't have much memory you will have a huge IO issue. ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ... dB (this time from the actual ASP page that passes the query to the ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... if your server doesn't have much memory ... and the "executing query" ball just kept ... When I get properties for the FT catalog, ... The company I am currently working for is a heavy consumer of SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable query never completes nor times out?
    ... SQL Server MVP ... This is a dev server so I hadn't even been ... When I get properties for the FT catalog, ... I just ran a similar query on ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Single-Threading / Performance issues
    ... SQL Server MVP ... > Early this year my database was migrated from a single CPU, ... (when a long select query is running, ... server guy also sez it's not his problem. ...
    (microsoft.public.sqlserver.server)