Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jkelly2956

    Question about updating live asp.net website

    You can change the page directive for the asp.net page to not use the codebehind feature. <%@ Page Language="vb" AutoEventWireup="false" src="tt.aspx.vb" Inherits="tt" %> This only helps on asp.net pages and any other classes will need to be compiled and the dll updated.
  2. jkelly2956

    Speed Up this Distance Query

    Yes, the %al% was just an example.
  3. jkelly2956

    Speed Up this Distance Query

    Basically I have a list of City's with the the english spelling (main city list). I also obtained a list of alternate city spellings(with cyrllic etc) that I want to allow searches by as well but match to the main city. The reason I am joining on a calculation is I want to join the two...
  4. jkelly2956

    Can you Speed up this query

    ...a hit.. I want to show the original name and lat and long. SELECT wd.pName,wd.DD_Lat,wd.DD_Long FROM W_Data wd LEFT JOIN ULocator ul ON ( 69.09 * DEGREES( ACOS( SIN( RADIANS( ul.Latitude ) ) * SIN( RADIANS( wd.DD_Lat ) ) + COS( RADIANS( ul.Latitude ) ) * COS( RADIANS( wd.DD_Lat ) ) * COS(...
  5. jkelly2956

    Speed Up this Distance Query

    ...is a hit.. I want to show the original name and lat and long. SELECT wd.pName,wd.DD_Lat,wd.DD_Long FROM W_Data wd LEFT JOIN ULocator ul ON ( 69.09 * DEGREES( ACOS( SIN( RADIANS( ul.Latitude ) ) * SIN( RADIANS( wd.DD_Lat ) ) + COS( RADIANS( ul.Latitude ) ) * COS( RADIANS( wd.DD_Lat ) ) * COS(...
  6. jkelly2956

    Repeater Control and Subtotals

    Basically I changed strategies and inside the code behind before I databind I added a column to the dataset called styleClass. Then I looped through the dataset and say if CustomerID Field = "" THEN styleClass field gets set to MainTable_Class else styleClass field gets set to...
  7. jkelly2956

    Visual Studio and Mapped Drives?

    lisfolks --The development server we are connecting to is running win2003 server. The desktops have Win XP prof and are using VS.NET ver 7.1.3088 / .NET FRAMEWORK version 1.1.4322 chiph -- We are using VSS but I don't think that is the problem. We are not even working on the same files/website...
  8. jkelly2956

    Visual Studio and Mapped Drives?

    I have it set to allow 20 Users. Should be more than enough.
  9. jkelly2956

    Web Access Failed Dialog Box mystery

    If using IIS6 try this.Go to IIS and under the properties for that site make sure the mime type .TMP is accepted. What happens is VS.NET tries to write a tmp file to the location to make sure that everything jives. Since IIS6.0 is locked down it will not allow an http request of type .tmp. So...
  10. jkelly2956

    Visual Studio and Mapped Drives?

    We have two developers using VS.NET to access a development server via a network share. When one of them gains access to a Solution and then the other tries to access anything on that share we get the error. "The Local device name is already in use.This connection has not been restored". This...
  11. jkelly2956

    UNION puzzle

    Why not tag a static field onto the end of each q1 and q2 and order by that. SELECT C.CLIENTGROUPID AS GROUPID, C.CLIENTGROUP AS 'GROUP','0' as gOrder FROM TBLCLIENTGROUP C UNION SELECT 0 AS GROUPID, '<< Select >>' AS 'GROUP', '1' as gOrder ORDER BY gOrder,'GROUP' asc
  12. jkelly2956

    Setting Project in Existing Web

    I got it going. The problem was with IIS 6.0. I had to set it to allow .tmp files to be served via HTTP. They are not allowed by default. Good Article about it http://www.iisfaq.com/default.aspx?View=A538&P=198
  13. jkelly2956

    Setting Project in Existing Web

    What should the application name be? Site1 or test.site1. Right now I am setting these projects up from my laptop using a file share to connect to the test server. Is that a problem?
  14. jkelly2956

    Setting Project in Existing Web

    I have a few existing web sites set up under IIS and they are using host headers. The IIS Setup looks like Default Web Site Test.Site1 --> inetpub/wwwroot/site1 Test.Site2 --> inetpub/wwwroot/site2 Test.Site3 --> inetpub/wwwroot/site3 ..etc These all contain asp3.0...
  15. jkelly2956

    Move files from a web server to another web server

    I do my development in a test environment and then just copy the files to the production server. If the set up is the same that is all that should be required. Make sure the asp_client folder resides where the validation code is looking..also make sure that if there are any variables that are...
  16. jkelly2956

    Can you use response object &amp; sessions in .vb files?

    LV I have looked everywhere for this.. You are my hero dude!
  17. jkelly2956

    Repeater Control and Subtotals

    Ok I got it to print the subtotal. Now how do I access the value to check whether it is a subtotal...and change the style of that row...something like. <ItemTemplate> <% if Container.DataItem("Customer_ID") = "" then %> <tr class="Main_Table" > <% else %> <tr class="SubTotal_Table" > <%...
  18. jkelly2956

    Backup Private Key (SSL)

    When I applied for a SSL Certificate from thawte it mentioned that after I created the CRS I should backup my private key. How do I do this? The private key is surely not the CRS(Certificate Signing Request)? How do you access this private key. I read that I must keep a copy of the private key...
  19. jkelly2956

    IIS and SSL - cached SSL Certificate stuck??

    This may be a long shot but look in the System32 folder and see if your certificate is being held there. It should have a .cer extension
  20. jkelly2956

    Repeater Control and Subtotals

    I have a dataset that I am displaying using a repeater control. I want to display a subtotal every ten records. How to do? Can you set the Footer row to show every ten records?

Part and Inventory Search

Back
Top