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!

Register Log in
  • 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. jcprince

    Excel, SQL Server & Pivot tables

    I have an Excel 2000 spreadsheet containing a pivot table driven from SQL Server 2000. It is currently updated via an system DSN on my PC, but to enable others to use this, I need to change to a DSN-less connection. Changing from DSN to DSN-less Pivot table Can anyone supply an example of the...
  2. jcprince

    Is this even possible with ISA server?

    Works fine with AD. We have a Win2K domain, clients running 98, NT, 2K & XP going to the internet through a Checkpoint Firewall. Content filtering via SurfControl.
  3. jcprince

    Prohibiting porno sites through ISA Server

    We use SurfControl's WebFilter which 'plugs' into the Web Filter section in ISA. Not the cheapest, but very good. They maintain categorised lists of sites that are automatically updated to the ISA Server. You can grant different users different rights (we use AD groups to do this), and you can...
  4. jcprince

    IIS FTP Weakness

    Another option is to use secure FTP via SSH
  5. jcprince

    Currency Settings

    Another option if you're using ASP is to add the following to the top of each page. This way you do not need to make any server side configuration changes. <% session.lcid = 2057 %>
  6. jcprince

    How to Grant FTP Permission?

    Rather than go through this step by step here, it's worth checking out these sites: http://www.iisfaq.com/default.aspx?View=A125&P=14 http://support.microsoft.com/default.aspx?scid=KB;EN-US;201771 Hope these help. John
  7. jcprince

    Disabling Frontpage 2000 Components

    Hi As the website & server administrator, I want to prevent certain frontpage components (e.g. hit counters) from being used. I'm using FPSE 2000 on Win2K Server. Thanks
  8. jcprince

    Disabling Frontpage 2000 Components

    Is there any way to prevent user from using certain components within Frontpage 2000? For example the page counter.
  9. jcprince

    IIS5, SMTP, CDONTS failing to send

    Hi, I have a Win2k server (SP3) running IIS5. WWW & FTP are running fine, and both ASP & Cold Fusion are installed. Using Cold Fusion emails are formatted and sent without a problem, indicating the firewall and the mail relay is not the issue. Every time I try to send an email using IIS SMTP...
  10. jcprince

    How to execute SQL

    If you're using ASP, why not send the form results to a page, then execute the SQL statement based ont eh form contents. If you then read the results, within your ASP script you can then use the following. <% if sqlresult = 1 THEN 'RESULT REQUIRED FOR 1.ASP response.redirect...
  11. jcprince

    IE Address Bar

    Hi Is there any way to turn off the address bar (IE only) for an already open window. Thanks
  12. jcprince

    default.asp ?

    JJ26's first suggestion (change it in IIS) is the better option. It doesn't rely on client side code being enabled. Another alternative is to use the refresh meta tag. Add the example below to your <HEAD> section. <meta http-equiv=&quot;refresh&quot; content=&quot;0;URL=default.asp&quot;>
  13. jcprince

    JScript ASP problem - Displaying contents of RecordSet

    Another method is to use the ordinal position in the recordset. Based on your Select statement above, you could try <p><%=rs(0)%></p> <!-- ID --> <p><%=rs(1)%></p> <!-- Text --> or <p><%=rs(1)%></p> <!-- Text --> <p><%=rs(0)%></p> <!-- ID -->
  14. jcprince

    Validation Of numeric Fields

    You are better doing validation client side where possble to reduce round trips to the server. You can use Javascript or VBScript (IE only) to do this. Define a javascript function to validate the fields, call this function with the onSubmit() function in the form tag, and only submit the data...
  15. jcprince

    Server Variables

    You will only get a value in the logon_user server variable if the user has authenticated to the server. You need to check that Anonymous access has been disallowed. Use the IIS console to do this.
  16. jcprince

    Modified By ...

    I'm looking for a way to recover the username of the user that last modified a webpage. I already recover the last modified date using the FileSystemObject, but cannot find a method to recover the username. I am running IIS5 on Win2K server formatted with NTFS. Thanks

Part and Inventory Search

Back
Top