User Profile

Collapse

Profile Sidebar

Collapse
Scorpion657
Scorpion657
Last Activity: May 22 '08, 09:56 PM
Joined: Mar 20 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Scorpion657
    started a topic Timeout expired
    in .NET

    Timeout expired

    Hey I really need help.

    I have a Website coded using ASP.NET and VB and for some reason, i'm getting the following error when I try to upload or access a large file which is stored in the database. It was working fine when I was runing the site on the localhost. I added the following line to the web.config file to increase the timeout:

    Code:
    <httpRuntime 
maxRequestLength="1048576"
executionTime
    ...
    See more | Go to post
    • Scorpion657
      replied to ASP Split and SQL Select
      in ASP Classic
      You are correct. I am using ASP.NET. I think I found a trick that makes it work just fine.

      If Ubound(sSearchA rray) + 1 > 0 then
      ....

      End If.

      That works for now. If there is a better way, please let me know. Otherwise, Thanks a whole lot....
      See more | Go to post
      Last edited by Scorpion657; Mar 25 '08, 02:53 PM. Reason: Trick

        Leave a comment:

      • Scorpion657
        replied to ASP Split and SQL Select
        in ASP Classic
        There was some " ' " missing before the % that's why it was giving me an error.

        Now For some reason, it worked but with some minor mistakes. Here is what it does:

        When the search box has exactly 1 word:
        sSQL = " SELECT [ProjectName], [ProjectID] FROM [ProjectList] "

        instead of:

        sSQL = sSQL & " WHERE ([ProjectName] LIKE '%" & sSearchArray(0)...
        See more | Go to post

          Leave a comment:

        • Scorpion657
          replied to ASP Split and SQL Select
          in ASP Classic
          Thanks a lot Dr. B for your help. Now when I try to display the data into a gridview, my guess was that I would need to create a dataset and fill it with the results and later bind it to the gridview. I tried the following but it did not work:

          Dim sSearchString
          Dim myConn As New Data.SqlClient. SqlConnection
          myConn.Connecti onString = "Data Source=serverna me;Initial Catalog=databas ename;Integrate d Security=True"...
          See more | Go to post

            Leave a comment:

          • Scorpion657
            started a topic ASP Split and SQL Select
            in ASP Classic

            ASP Split and SQL Select

            Hey guys, I am really new at this and I am trying to do the following:

            I need to split keywords entered into search box eg. if someone enters 'Research Design' in, it needs to split the words and then build an Sql query that will give me the following output :

            SELECT [ProjectName], [ProjectID]
            FROM [ProjectList]
            WHERE ([ProjectName] LIKE '%' + 'Research' + '%') AND ([ProjectName] LIKE '%' + 'Design'...
            See more | Go to post
            No activity results to display
            Show More
            Working...