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 Mike Lewis 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
  • Order by date
  1. Airpan

    Type mismatch

    Just thought I would say that I finally got this figured out in terms of their "help" files. The page I was trying to test is for using file type arrays for photographs (png.psd, etc etc)- at least that is what the documentation said, so I really don't need that page right now... may need it in...
  2. Airpan

    Exception occurred error

    Chris, If you think the code is written incorrectly, how should it be written? ~E
  3. Airpan

    Type mismatch

    Thanks everyone for your help. Here is the long and short of it... as Tarwn pointed out, the page must be for an altogether different purpose than what I am looking for... I looked some more stuff up online and have yet to discover what I would need that page for. At any rate, I would like to...
  4. 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=" &...
  5. Airpan

    Exception occurred error

    Chopstik, I tried this hoping it would generate something else to go on... I commented out line 75 ( the line calling the PIC recordset) and it generated this error: ADODB.Field error '80020009' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a...
  6. Airpan

    Exception occurred error

    I also tried your code and it still generates and error. ~E
  7. Airpan

    Exception occurred error

    Chopstik, I went into the DB to be sure that there wasn't something duplicative causing a problem and didn't see anything. However, I did note that the page is trying to display two sideloaders and there is only one sideloader in the database. ~E
  8. Airpan

    Exception occurred error

    In the PIC field of the database I have the following path: trucks/image.jpg. As far as binary image - I do not have any images in the database. It contains only the url. ~E
  9. 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>")...
  10. Airpan

    session variable

    Trekk, As chopstick said I am not sure how you need the session variable to function, but I was shown how to create a session variable from a recordset and how to store it as a variable and call it in a query... there again, don't know if that suits your needs but you can certainly view the...
  11. Airpan

    Uploading files on a specific folder

    b00gieman - awesome. thanks for the heads up. I will definately check it out. :o) ~E
  12. Airpan

    Syntax Error (missing operator)

    OK I got it... forgot to include the Request.QueryString information on a page and it wasn't catching the variable. Thanks for the troubleshooting help. Aiy yih yih.:o/ ~E
  13. Airpan

    Syntax Error (missing operator)

    Thanks guitarzan. Here is what it wrote out: UPDATE cust_inventory SET [STK]='1298',[YR]=1960,[MK]='Freightliner',[MD]='AK47',[TYPE]='Refuse', [MILES]='under60K',[HRS]=5,[GVW]=90000,[FRGVW]='10000',[RGVW]='88016', [ENGM]='Tecumseh',[ENGMOD]='3L',[HP]=100,[TR]='Automatic',[TRM]=...
  14. Airpan

    Syntax Error (missing operator)

    DNG, I tried putting in the Response.Write(sql) and it didn't write the sql statement. Am I writing it wrong? dim oConn, Rec, sConn, sFilePath Set oConn = Server.CreateObject("ADODB.Connection") sFilePath = Server.MapPath("db/logins.mdb") sConn =...
  15. 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'...
  16. Airpan

    Login Box Allowing Users that it shouldn't

    Sheco, it worked great, thanks for the help. I had not used session variables before and had created one with the help of adobe's online help files, but alas, didn't find a way to do it using a record set. At any rate, thanks again. ~E
  17. Airpan

    Login Box Allowing Users that it shouldn't

    Thanks Sheco - the reason that you didn't see any code for the session variable is because the code for the session variable was on the second page, because my session variable was created to function after the user logs in, and it would take the value from the username of the form. However...
  18. Airpan

    Photograph Upload

    Thanks John... will give it a go. ~E
  19. Airpan

    Uploading files on a specific folder

    no problem - glad I could finally help someone here. :o) ~E
  20. Airpan

    INSERT INTO SYNTAX ERROR

    Thanks.:o) It worked. ~E

Part and Inventory Search

Back
Top