Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Type Mismatch?
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Type Mismatch?
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
Mikeap View Drop Down
Newbie
Newbie


Joined: 12 March 2003
Location: United States
Status: Offline
Points: 37 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mikeap Quote  Post ReplyReply Direct Link To This Post Topic: Type Mismatch?
    Posted: 26 August 2003 at 4:36pm

I get a TYPE MISMATCH on the following line?

strRound1 = (Cstr(arrRound1)) ???
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 26 August 2003 at 8:37pm
is arrRound1 an array???
Blog | MPG Tracker
Back to Top
2gawd View Drop Down
Newbie
Newbie
Avatar

Joined: 27 August 2003
Location: United States
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 2gawd Quote  Post ReplyReply Direct Link To This Post Posted: 27 August 2003 at 5:42pm

I've come across the exact same error, still trying to figure it out.  I get it on the following line though:

Machine Name: <input type="text" name="machine_name" maxlength="20" value="<% = rsInventory("Machine_Name") %>"> 



Edited by 2gawd
Back to Top
vshriniwasan View Drop Down
Groupie
Groupie
Avatar

Joined: 17 December 2001
Location: United States
Status: Offline
Points: 63 		Post Options Post Options   Thanks (0) Thanks(0)   Quote vshriniwasan Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 11:39am

Well you have two different problems her. Mikeap is converting a var to a string and 2gawd is writing a field from a database.

Mikeap - Without knowing what is arrRound1, it is hard to find out.

2gawd - As far as you, what is the SELECT statement you are using. It could be the select statement that is doing this. If you are trying to say field = ???, try field LIKE ???. If you are using Access, you cannot use equal for Autonumber and Numerical filed types.
Back to Top
2gawd View Drop Down
Newbie
Newbie
Avatar

Joined: 27 August 2003
Location: United States
Status: Offline
Points: 4 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 2gawd Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 12:11pm

The actual error is as follows:

  • Error Type:
    Microsoft VBScript runtime (0x800A000D)
    Type mismatch: 'rsInventory'
    /update_form.asp, line 37

    I'm using Access but the Machine_Name field I'm trying to update is a text field.  rsInventory is my recordset object which I defined by this line:

  • Set rsInventory = Server.CreateObject("ADODB.Recordset")

    •  

     
    Back to Top
    MorningZ View Drop Down
    Senior Member
    Senior Member
    Avatar

    Joined: 06 May 2002
    Location: United States
    Status: Offline
    Points: 1793     		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 12:24pm

    chances are that recordset may be empyt, or has been closed by then, or something......

    the error aint lying
    Contribute to the working anarchy we fondly call the Internet
    Back to Top
    2gawd View Drop Down
    Newbie
    Newbie
    Avatar

    Joined: 27 August 2003
    Location: United States
    Status: Offline
    Points: 4     		Post Options Post Options   Thanks (0) Thanks(0)   Quote 2gawd Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 12:30pm

    I built it off of the "Updating Data in an Access Database" tutorial.  The only difference is the names of my fields and the fact that there are more to update.  If you all are interested I'll post the entire code.
    Back to Top
    MorningZ View Drop Down
    Senior Member
    Senior Member
    Avatar

    Joined: 06 May 2002
    Location: United States
    Status: Offline
    Points: 1793     		Post Options Post Options   Thanks (0) Thanks(0)   Quote MorningZ Quote  Post ReplyReply Direct Link To This Post Posted: 28 August 2003 at 12:35pm

    cant speak for anyone but myself.. but do so and i'll try to help

    also real quick though.. are there other fields around that statement that do work???

    have you tried to:
    Response.Write rsInventory("Machine_Name")
    Response.End
    right after the Recordset gets filled to absolutely positively make sure it has valid info
    Contribute to the working anarchy we fondly call the Internet
    Back to Top
     Post Reply Post Reply Page  12>

    Forum Jump Forum Permissions View Drop Down

    Forum Software by Web Wiz Forums® version 12.08
    Copyright ©2001-2026 Web Wiz Ltd.

    Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
    About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

    Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
    Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

    Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

    Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.