Recent content by lloydanderson

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

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

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

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

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.

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

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

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

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

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

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

Thank you both - The solution worked perfectly.

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

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?

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