Type mismatch error

Hi all,

I am using access database and IIS on my own computer to run the small
website. And I have one insert record page and one display page. Both were
working fine on Friday. But today it always showed the error information as
below:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "Morning"]'
/hometown.asp, line 42

I checked all the date type in Access and server behavior on insert record.
The data types are fine. So anybody can help me to understand the problem?
Thanks!

<table width="75%" height="163" border="1" cellpadding="0" cellspacing="0">
<tr>
<td><p> <%= Abs((myhometown.Fields.Item("Name").Value)) %>'s Home
Town<br> * This is line 42 *
Hi all,</p>
<p>My name is <%= Abs((myhometown.Fields.Item("Name").Value)) %>. I am
years <%= Abs((myhometown.Fields.Item("Age").Value)) %>old. I am a<%=
Abs((myhometown.Fields.Item("Gendar").Value)) %> from<%=
Abs((myhometown.Fields.Item("City").Value)) %> , <%=
Abs((myhometown.Fields.Item("Country").Value)) %>. </p>
<p>Here is a image of my hometown:<%=
Abs((myhometown.Fields.Item("Image").Value)) %></p>
<p>&nbsp;</p></td>
</tr>
</table>

Hi

What is the data type meant to be on the field. <%=
Abs((myhometown.Fields.Item("Name").Value)) %>'s

Try <%= Abs(myhometown.Fields.Item("Name").Value) %>'s
instead, If your trying to display numbers or dates the double quotes will
screw it up.

What data have you inserted?

Dan
www.onlineukdating.co.uk

"drolma" <webforumsuser (AT) macromedia (DOT) com> wrote

Hi all,

I am using access database and IIS on my own computer to run the small
website. And I have one insert record page and one display page. Both were
working fine on Friday. But today it always showed the error information
as
below:
Error Type:
Microsoft VBScript runtime (0x800A000D)
Type mismatch: '[string: "Morning"]'
/hometown.asp, line 42

I checked all the date type in Access and server behavior on insert
record.
The data types are fine. So anybody can help me to understand the problem?
Thanks!

table width="75%" height="163" border="1" cellpadding="0"
cellspacing="0"
tr
td><p> <%= Abs((myhometown.Fields.Item("Name").Value)) %>'s Home
Town<br> * This is line 42 *
Hi all,</p
p>My name is <%= Abs((myhometown.Fields.Item("Name").Value)) %>.
I am
years <%= Abs((myhometown.Fields.Item("Age").Value)) %>old. I am a<%=
Abs((myhometown.Fields.Item("Gendar").Value)) %> from<%=
Abs((myhometown.Fields.Item("City").Value)) %> , <%=
Abs((myhometown.Fields.Item("Country").Value)) %>. </p
p>Here is a image of my hometown:<%=
Abs((myhometown.Fields.Item("Image").Value)) %></p
p>&nbsp;</p></td
/tr
/table