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

    count each day and each varible

    Hello, I am a newbie and would appreciate your help - I am VB excel with Visual Fox Pro Driver. This is some of the data that is returned: anreise abreise preis pcode 8/13/2003 8/17/2003 79 8/13/2003 8/14/2003 78.81 HRN 8/13/2003 8/14/2003 85.68 HRN...
  2. lloydanderson

    variable in ASP page to stored procedure sql 7

    Dooh! I was not returning anything in the Querystring I was reusing a asp page and did not even think about it - Thank you very much for your help...
  3. lloydanderson

    variable in ASP page to stored procedure sql 7

    I am still having problems - I tried changing the page: Dim strSQL Dim objConn Dim objComm Dim objRS Dim objField Dim strTextWrite Dim lngRSCount Dim vHotelname vHotelname=Request.QueryString("Hotel Name") 'vHotelname = "PHX" Dim adCmdStoredProc...
  4. lloydanderson

    variable in ASP page to stored procedure sql 7

    I would appreciate any help with the following code - I am trying to pass a variable from one ASP page to another and then use that variable in a stored procedure. Some of the code follows. Dim vHotelname vHotelname=Request.QueryString("Hotel Name") Dim adCmdStoredProc adCmdStoredProc...
  5. lloydanderson

    SQL7-DSN-Less connection help needed

    Thanks for testing this for me - It may be a rights issue - I will need to read more on how to put an excel program on an web server.
  6. lloydanderson

    SQL7-DSN-Less connection help needed

    Hi, The database name is DailyMktSegnewSql (like to type)...
  7. lloydanderson

    SQL7-DSN-Less connection help needed

    Hello, I am trying to set up VB script in excel, using ActiveX 2.0 and have had no joy! Any helpful suggestions? I copied this off of MS Option Explicit ' Declare object variables for the Connection and Recordset objects. Private cnMrkseg As ADODB.Connection Private rsMrkseg As...
  8. lloydanderson

    W2K TS client gets new license at each login

    Hello all; I have a win95 client that gets a new license issued each time it logs into our TS - The station did not have a problem for about three months but now it does. Luckily it is only used once a week. I have tried looking at the KB and email support@micrsoft (their response WIN95 no...
  9. lloydanderson

    Need help with Division ZERO problem

    Never mind figured it out: Case when [CG Occ Rooms] = 0 then 0 else [CG Room Rev]/[CG Occ Rooms] end AS [CG AVG Rate], As I said, very new to databases...
  10. lloydanderson

    Need help with Division ZERO problem

    Hello, really new at databases - trying to show the value of having a database at work- I have a divide by zero error - I have about twenty calculations of this type; [WG Occ Rooms], [WG Room Rev]/[WG Occ Rooms] AS [WG AVG Rate] In access the results are #ref# but SQl returns divide by zero...
  11. lloydanderson

    Access Query to SQL keeps bombing out

    Hello all; Very new to SQL and Access. We are attempting to move a Access query to SQL and the following works in Access but not in SQL - The query "against a view" [MTD CG Occ Rm Budget]+[MTD SG Occ Rm Budget]+[MTD WG Occ Rm Budget]+[MTD GG Occ Rm Budget]+[MTD EG Occ Rm Budget]+[MTD...
  12. lloydanderson

    Getting Server Date in Var for SQL Lookup

    Thank you both - The solution worked perfectly.
  13. lloydanderson

    Getting Server Date in Var for SQL Lookup

    Hello; I am very new to ASP and Databases - I am trying to get today's date for an ASP Page - The SQL statement is used in a query to an Access97 database. I would appreciate any help. Thank you
  14. lloydanderson

    Change Timeout on MS Proxy 2

    Hello all; My users are going to a site with what seems to be a slow database server...Is there a way to change, their connection is continuely dropped by the Proxy Server after two minutes. Is there a registry change available?
  15. lloydanderson

    Linksys Wireless Network card and Cisco VPN

    I had a similar problem with my Linksys - I use Cisco VPN 3.03a client (Ipsec with Nat)... I needed to upgrade the Linksys firmware to get the wireless to connect... Works great now
  16. lloydanderson

    VPN question

    Have you set up their host file for the boxes they are trying to map to?
  17. lloydanderson

    Upload Software before or After?

    Thank you for your help
  18. lloydanderson

    Upload Software before or After?

    Sorry, I said IOS but; I am trying to upload 342 firmware - not an IOS - file download as an .exe - becomes an .450 when I double click on it -
  19. lloydanderson

    Upload Software before or After?

    I have a question on uploading IOS - Do I upload the file as is from cisco as an .exe or do I upload the file after it uncompresses?
  20. lloydanderson

    NTLM over Internet

    One of our vendors has set up his web server to require Windows Challenge/Response (NT4 IIS4). Am I off base in telling them they shouldn't do this? I use MS Proxy 2 SP1 at two locations. One as a cache only, with PIX and 2621, the other site proxy is the only access to the Internet. I can use...

Part and Inventory Search

Back
Top