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
    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
    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
    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

    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...