473,657 Members | 2,458 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Type mismatch: 'arrOutput3'

10 New Member
i have this script that's be giving me errors what ever i do. if you could please help
Type mismatch: 'arrOutput3' Line: 38
<select name="model" onchange="getpa ge(<% Response.Write ""&arrOutput3(1 ,i)&"" %>,this.value)" >


The entire script:

<% set objDBConnection 3 = Server.CreateOb ject("ADODB.Con nection")
objDBConnection 3.ConnectionTim eout = 15
objDBConnection 3.CommandTimeou t = 30%>
<%
objDBConnection 3.Open "dataconnection ;"
set objDBCommand3 = Server.CreateOb ject("ADODB.Com mand")
objDBCommand3.A ctiveConnection = objDBConnection 3
objDBCommand3.C ommandText = "SELECT model ,CAT_ID,make FROM listing WHERE CAT_ID = ? ORDER BY model ASC"
objDBCommand3.C ommandType = 1


strmarques3 = "1"
If (Request.QueryS tring("catid") <> "") Then
strmarques3 = Request.QuerySt ring("catid")
%>

<%
set objDBParam3 = objDBCommand3.C reateParameter( "@column",5 , 1, -1)
objDBCommand3.P arameters.Appen d objDBParam3
objDBCommand3.P arameters("@col umn") = strmarques3
set objDBParam3 = Nothing
set objDBRecords3 = objDBCommand3.E xecute
If Not objDBRecords3.E OF Then
arrOutput3 = objDBRecords3.G etRows()
objDBRecords3.C lose
objDBConnection 3.Close
Set objDBConnection 3 = Nothing
Set objDBRecords3 = Nothing %>
<%
Dim occasions
occasions = UBound(arrOutpu t3, 2)
'Response.Write ""&arrOutput3(2 ,i)&""
%>
<input name="marque" type="hidden" id="make" value="<% Response.Write ""&arrOutput3(2 ,i)&"" %>" />


<% End If %>
<select name="model" onchange="getpa ge(<% Response.Write ""&arrOutput3(1 ,i)&"" %>,this.value)" >
<option value="">Tous</option>
<% For i = 0 To UBound(arrOutpu t3, 2)%>

<option value="<%=arrOu tput3(0,i)%>">< %=arrOutput3(0, i)%></option>
<% Next
%>
</select>

<% End If %>
Jan 5 '09 #1
2 1597
jdom
10 New Member
Any suggestion please. Thank you
Jan 7 '09 #2
Nicodemas
164 Recognized Expert New Member
I need to see your code with proper lines to help you better. Please edit your code in the first post by placing it between [ CODE] and [ /CODE] tags.

My best guess at this point is type mismatch probably means that the script doesn't recognize arrOutput3 as an array on that line.

Try to clean up the response.write. Put this instead of the longer line you have:

Expand|Select|Wrap|Line Numbers
  1. <select name="model" onchange="getpage(<%= arrOutput3(1,i) %>, this.value)">
  2.  
Jan 8 '09 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

5
4432
by: Arun Wadhawan | last post by:
Hello MY SQL Server is causing me this problem : Microsoft VBScript runtime error '800a000d' Type mismatch: 'ident' >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> I am getting from the table datingnew the value of the ident field.
1
2488
by: LJgrnl | last post by:
I've got a type mismatch error that's driving me nutty. Variable blnNoData has the initial value False. If a recordset comes back empty (both .EOF and ..BOF are true) then blnNoData is set to True. I then have an if statement to determine what to write to the screen depending on blnNoData. As long as the if statement is true (doesn't have to go to the else clause), the code runs fine. Otherwise, a type mismatch error is returned. In...
1
2282
by: Mark | last post by:
Hi - I tried this in VS.Net, and also in the Web Matrix code below: - but I am getting a type mismatch error. The sql statement runs perfectly from within the Access Query Designer. Can anyone verify the syntax, and that my .net code is ok - the type mismatch is happening at: DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection) Thanks in advance,
7
15811
by: middletree | last post by:
I've been messing with this for hours, and have been to various sites, including Aaron's site, and am truly stumped. The short version: in SQL Server, the 4 fields in question are datetime. I have a page that allows users to type in the info (actually a calendar pop-up allows me to make sure they do it in the correct format), into a textbox. When this page gets called up again, I want to prefill the box with the existing data, in case...
4
11961
by: Mike | last post by:
I am getting a type mismatch error when I do a bulk insert. ---Begin Error Msg--- Server: Msg 4864, Level 16, State 1, Line 1 Bulk insert data conversion error (type mismatch) for row 1, column 14 (STDCOST). ---End Error Msg--- The STDCOST is set to decimal (28,14) and is a formatted in Access as a number, single with 14 decimal. I don't know why I would be getting a Type
3
2911
by: amitbadgi | last post by:
I am getting teh following error while converting an asp application to asp.net, Exception Details: System.Runtime.InteropServices.COMException: Type mismatch. Source Error: Line 347: 'response.Write(sql2)
1
2805
by: Brett | last post by:
I have a form that calls a method within a DLL. By clicking a button on the form, the DLL is instantiated and the SaveOutlookMessage() method invoked. The DLL code copies messages from Outlook to an HTML file. When I execute the EXE, which is only the form, and click the button, I get a "Type Mismatch" error on this line in the form: mailobj.SaveOutlookMessage() Any suggestions on why I'm getting the type mismatch error? --Form code
6
5984
by: Howard Kaikow | last post by:
I'm doing a VB 6 project in which I am trying to protect against type mismatch errors. Is the process any different in VB .NET? Here's what I'm doing in VB 6. I have an ActiveX DLL. The class has stuff initialized by calling a sub SetClass that wants some Word specific objects passed-in. If the user mistakingly uses the wrong object, say, uses an Excel object
19
21551
by: Lysander | last post by:
I have written a query that takes three integers representing day,month and year, forms a date from them and compares this date to the date the record was entered and returns any records where the date is more than 10 months out. The query runs fine, but I when I put the criteria of >10 I get 'Data Type mismatch' error. The code below is the original query. I have since put all the datediff bit in code, with all variables declared as date,...
0
8420
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8842
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8617
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7353
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6176
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4330
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2743
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
1970
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1733
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.