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

  • Users: Airpan
  • Content: Threads
  • Order by date
  1. Airpan

    Type mismatch

    I have a dbtest asp page that looks like so: <% @Language="VBScript" %> <html> <body> <% Dim oConn, Rec, sConn, sFilePath Set oConn = Server.CreateObject("ADODB.Connection") sFilePath = Server.MapPath("db/logins.mdb") sConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &...
  2. Airpan

    Exception occurred error

    When I run this code locally it queries the database for information and displays it, but for whatever reason, displays an error (below the information it displays) which reads, Exception occurred. sideloader.asp, line 75 Line 75 is: Response.Write("<img src=" & Rec1("PIC") & " border=0>")...
  3. Airpan

    Syntax Error (missing operator)

    I need a new set of eyes on this I think. I ran the following query in Access: UPDATE cust_inventory SET [STK]='3450',[YR]='2000',[MK]='Chevrolet',[MD]='6500',[TYPE]='Recyle', [MILES]='600000',[HRS]='4',[GVW]='90000',[FRGVW]='10000',[RGVW]='80000'...
  4. Airpan

    INSERT INTO SYNTAX ERROR

    I looked at my old post regarding this as I had a syntax issue once before, but alas, they are not the same. I get the following error: Microsoft JET Database Engine (0x80040E14) Syntax error in INSERT INTO statement. line 28 Line 28 is the SQL: oConn.Execute("INSERT INTO cust_logins...
  5. Airpan

    Login Box Allowing Users that it shouldn't

    I come here in shame and degradation. lol I made a login box that was successful at logging users in. For whatever reason, it seems that only the username is being held as criteria for people to login, not the username and password. I should mention that I changed the connection information...
  6. Airpan

    Log Out Page

    I am trying to create a logout page. I found many examples on the web for using ASP.NET but would like to use just ASP. I have a session variable being passed throughout, like so: <%Session("sessUserName")=Request.Form("username")%> I know that I need to "close" or abandon the session...
  7. Airpan

    Option Explicit Problem

    I am using this faq329-1869 to help me create photo upload capability for some pages I am building in ASP. However, I am receiving the following error: Expected statement upLoadEnd.asp, line 7 Option Explicit Line 7 is: <%Option Explicit%> I did not change any of the code from what was posted...
  8. Airpan

    Data type mismatch in criteria expression

    I built a rather large form to update the database, with a second page to handle inserting the form data. I was getting the above error and decided in order to trouble shoot, that I would take the form down to one item to insert and the page with the SQL down to the same. It states that the...
  9. Airpan

    Capture Value from Drop Down Menu

    I have a form that utilizes drop downs. I would like to be able to pull those values from the form and have it update the database. Is this the correct syntax to do so? frmyear=Request.Form("year"(1,2)) ~E
  10. Airpan

    Two SQL queries?

    Is it possible to run two SQL queries on the same ASP page? ~E
  11. Airpan

    Object Required Error, Do While Not Statement

    I am getting this error: Object required: '', line 18 Line 18 is: Do While Not rec.EOF If additional code is needed I can supply it. ~E
  12. Airpan

    Session Variable and Login page

    I created a login page using the Log In User option from the Application menu. I tested it on IIS and it works great. However, my main goal is to have the user log in and have information from two tables displayed, but only the information pertaining to that user. I have been beating my head...
  13. Airpan

    Best Approach for profiles?

    I have successfully completed the administrative side of a project which will allow admins to assign logins to customers. I am now tackling the customer login side of things, and need some input on the best way to approach this. I am not sure how to organize the layout once the customer logs...
  14. Airpan

    Photograph Upload

    I am researching being able to upload photographs. I found this FAQ: faq329-1869 I don't know if anyone has had experience with photograph upload but the FAQ points out a simple way to do so using just ASP and VB. I had done some looking around on the web and found that there are 3rd party...
  15. Airpan

    UPDATE statement

    I have built an ASP page that utilizes a form to allow for editing information. I ran this SQL in access, that I wrote myself with my textbook (not the wizard) and it works great. UPDATE cust_logins SET CustName = 'Double Vision Media Group', CUSTUSER = 'dvmg', CUSTPASS = 'dvmg', Email =...
  16. Airpan

    INSERT INTO statement

    I am getting a syntax error on this SQL statement (I wasn't sure whether to post here or the SQL forum) which I have being executed in an ASP page. Can someone take a look and let me know if they see anything standing out? I am running it on IIS (XP OS) and it gives me a syntax error. I have...
  17. Airpan

    Using buttons to Add,Edit, Delete

    I have built a login page via ASP. Once logged in you are taken to the admin page which displays all of the users in the database. At the bottom of the user table(which lists all the users & their login info), there are three buttons, add, edit, delete. I am running into a bit of trouble with...
  18. Airpan

    Networking Question

    I wanted to know if it is possible to network a Mac and a PC? I am guessing from doing a pretty good search online that it is not. My boyfriend has a Mac and I have the PC and we do a lot of design and web work... We wanted to try to network the machines, but I just don't think it is...
  19. Airpan

    External Hard Drive

    OK, I am trying to install an external ADS Pyro Firewire Drive Kit... I have installed the drivers, and have tried (in vain) to get the computer to recognize the external drive, and it will not. The questions I have are as follows: 1. I did not format the hard drive when I put it in the...
  20. Airpan

    Sound Problems

    I recently updated my machine and downloaded the latest updates from microsoft. Since then, I have been unable to get ANY sound from my computer. I have seen some threads regarding the error I was getting which relates to the C-Media AC97 Sound driver. I use Winamp and it was working great...

Part and Inventory Search

Back
Top