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

    network connection dropped

    Hello. I have lost linux internet connectivity. I am not able to ping anything from Fedora 3 when I type ifconfig, I don't get any errors (eth0 is found with no errors) but when I type dhclient I get: sit0: unknown hardware address type 776 as part of the message. physically everything is...
  2. timbooher

    Can not execute update query (ASP--> Jet SQL --> Access

    DNG, yep -- you got it right -- the keyword local fixed the problem when changed to [local]. what a pain. Thanks, Tim
  3. timbooher

    Can not execute update query (ASP--> Jet SQL --> Access

    O.K. new twist, yes all on one line: I think the error is the local word -- it is a keyword. will let you know soon . .. Tim
  4. timbooher

    Can not execute update query (ASP--> Jet SQL --> Access

    Should have that from above, as I said the connection works fine, myQuery = "update Member set FName = 'Curtis',MName = '',LName = 'Griffin',children = 0,email = '',hideAddress = False,LastUpdate = '6/26/2005',local = False,MakeEmailPrivate = False,Married = False,MobilePhone = NULL,Occupation...
  5. timbooher

    Can not execute update query (ASP--> Jet SQL --> Access

    Oh -- and the Status=-1 is fine -- that is a number field of type integer, not a Boolean field. Regards, Tim
  6. timbooher

    Can not execute update query (ASP--> Jet SQL --> Access

    Yes, I tried this in the access database, no problems whatsoever. As for the exact error -- when running locally on IIS and on my ISP's IIS, I get the same error: # Error Type: Microsoft JET Database Engine (0x80040E14) Syntax error in UPDATE statement. /admin/MemberUpdateFromAdmin.asp, line...
  7. timbooher

    Can not execute update query (ASP--> Jet SQL --> Access

    Well, a great hint and good move forward, but after fixing this, I still have the same problem. Here is my new update SQL command: update Member set FName = 'Curtis',MName = '',LName = 'Griffin',children = 0,email = '',hideAddress = False,LastUpdate = '6/26/2005',local = False,MakeEmailPrivate...
  8. timbooher

    Can not execute update query (ASP--> Jet SQL --> Access

    Hello -- I have vetted my MS Access database -- no fields are required, in all fields zero length strings are required. I can't tell of any relationship ('referential integrity') problems. But with the following query: update Member set FName = 'John',MName = '',LName = 'Doe',children = 0,email...

Part and Inventory Search

Back
Top