|
 |
asp_web_howto thread: Help with Error
Message #1 by "Nigel" <nigel@m...> on Fri, 12 Jul 2002 15:25:45 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0016_01C229B8.646977B0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
MessageHi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
a.. Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
Message #2 by "Scott Heath" <scott@s...> on Fri, 12 Jul 2002 09:32:22 -0500
|
|
Nigel,
What data types are the fields in your database? I've had the issue in
the past and it's always been I was trying to update a field that is a
Text field by putting a number in there with out the single quote. Hope
that helps!
Scott
Website=A0=A0=A0=A0=A0 | http://www.scottspad.com
E-mail=A0=A0=A0=A0=A0=A0 | scott@w...
Alpha Pager=A0 | www.scottspad.com/phone.asp
--------------------------------------------
Life's unfair - but root passwords help!
ICMP: The protocol that goes PING!
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 9:26 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
=A0
Im trying to update a field in my Acces Databse and i keep getting the
following error..
=A0
=95 Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate =3D Server.CreateObject ("ADODB.Recordset")
=A0strSQLUP =3D "UPDATE tblJobMI SET " _
=A0& "strJobTile =3D '" & EditJobTitle & "', " _
=A0& "Deadline =3D #" & EditDeadline & "#, " _
=A0& "strContactName =3D '" & EditName & "', " _
=A0& "strContactNo =3D '" & EditPhone & "', " _
=A0& "strContactMob =3D '" & EditMobile & "', " _
=A0& "strEmail =3D '" & EditEmail & "', " _
=A0& "strFax =3D '" & EditFax & "' "=A0 _
=A0& " WHERE (JobNoMI =3D " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
=A0
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20 ---
Message #3 by kyle.b.willman@u... on Fri, 12 Jul 2002 09:35:20 -0500
|
|
Are you performing any arithmetic or string manipulation through functions?
What exactly is line 190 in your code?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Nigel"
<nigel@m... To: "ASP Web HowTo" <asp_web_howto@p...>
td.co.uk> cc:
07/12/2002 09:25 Subject: [asp_web_howto] Help with Error
AM
Please respond to
"ASP Web HowTo"
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
Message #4 by "Craig Flannigan" <ckf@k...> on Fri, 12 Jul 2002 15:40:17 +0100
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_001B_01C229BA.6C99A660
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
MessageCheck your Field Types.
If I try to enter text into a Numeric field, I'd get the same error you did.
This also means check where you've placed apostrophes too in your SQL code
you wrote.
Surround only text fields with ' and leave them out for numeric fields.
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: 12 July 2002 15:26
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
a.. Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #5 by kyle.b.willman@u... on Fri, 12 Jul 2002 09:45:29 -0500
|
|
The error in no way references the DB, so it would be my assumption that
the error is IN your code. Not in the SQL statement itself. I bet if you
look at line 190 you are trying to increment, subtract or perform some
other mathematic function on a variable that is not a number...
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Craig Flannigan"
<ckf@k... To: "ASP Web HowTo" <asp_web_howto@p...>
h.com> cc:
07/12/2002 09:40 Subject: [asp_web_howto] RE: Help with Error
AM
Please respond to
"ASP Web HowTo"
Check your Field Types.
If I try to enter text into a Numeric field, I'd get the same error you
did.
This also means check where you've placed apostrophes too in your SQL code
you wrote.
Surround only text fields with ' and leave them out for numeric fields.
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: 12 July 2002 15:26
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting
the following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this
is probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from
Glasshaus. Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp
or
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
Message #6 by "Nigel" <nigel@m...> on Fri, 12 Jul 2002 15:48:15 +0100
|
|
Line 190 is
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Im not doing no string manipulation or maths
its a basic form where they can edit the details .. ??
Any more help .. pls :)
-----Original Message-----
From: kyle.b.willman@u...
[mailto:kyle.b.willman@u...]
Sent: 12 July 2002 15:35
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Are you performing any arithmetic or string manipulation through functions?
What exactly is line 190 in your code?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Nigel"
<nigel@m... To: "ASP Web HowTo"
<asp_web_howto@p...>
td.co.uk> cc:
07/12/2002 09:25 Subject: [asp_web_howto]
Help with Error
AM
Please respond to
"ASP Web HowTo"
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #7 by "Nigel" <nigel@m...> on Fri, 12 Jul 2002 15:53:21 +0100
|
|
I am trying to update various text fields.
there is no numbers in any fields ?
I have a few date fields but i have marked them with the # ??
Im getting reaaly stuck
-Original Message-----
From: Scott Heath [mailto:scott@s...]
Sent: 12 July 2002 15:32
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Help with Error
Nigel,
What data types are the fields in your database? I've had the issue in
the past and it's always been I was trying to update a field that is a
Text field by putting a number in there with out the single quote. Hope
that helps!
Scott
Website | http://www.scottspad.com
E-mail | scott@w...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
Life's unfair - but root passwords help!
ICMP: The protocol that goes PING!
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 9:26 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
? Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #8 by "Nigel" <nigel@m...> on Fri, 12 Jul 2002 16:00:04 +0100
|
|
im pretty sure im not dong any math functions ..
line 190 is
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText
i have tried just running the sql statement in Access and i get cannot
update strName field as its not updateable ?
any furtehr ideas ?
-----Original Message-----
From: kyle.b.willman@u...
[mailto:kyle.b.willman@u...]
Sent: 12 July 2002 15:45
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Help with Error
The error in no way references the DB, so it would be my assumption that
the error is IN your code. Not in the SQL statement itself. I bet if you
look at line 190 you are trying to increment, subtract or perform some
other mathematic function on a variable that is not a number...
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Craig Flannigan"
<ckf@k... To: "ASP Web HowTo"
<asp_web_howto@p...>
h.com> cc:
07/12/2002 09:40 Subject: [asp_web_howto] RE:
Help with Error
AM
Please respond to
"ASP Web HowTo"
Check your Field Types.
If I try to enter text into a Numeric field, I'd get the same error you
did.
This also means check where you've placed apostrophes too in your SQL code
you wrote.
Surround only text fields with ' and leave them out for numeric fields.
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: 12 July 2002 15:26
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting
the following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this
is probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from
Glasshaus. Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp
or
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #9 by "Drew, Ron" <RDrew@B...> on Fri, 12 Jul 2002 11:01:47 -0400
|
|
This is a multi-part message in MIME format.
------_=_NextPart_001_01C229B5.0B4EC0F9
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I would run a test and comment some of the lines.
Start with UPDATE...SET and the last line WHERE and only put one field
in at a time (remember to take the comma out). This way you can isolate
the column where the mismatch is occuring. It is probably not JobTitle,
ContactName but who knows. Make sure the JobNoMI is numeric on your DB
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 10:26 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
* Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate =3D Server.CreateObject ("ADODB.Recordset")
strSQLUP =3D "UPDATE tblJobMI SET " _
& "strJobTile =3D '" & EditJobTitle & "', " _
& "Deadline =3D #" & EditDeadline & "#, " _
& "strContactName =3D '" & EditName & "', " _
& "strContactNo =3D '" & EditPhone & "', " _
& "strContactMob =3D '" & EditMobile & "', " _
& "strEmail =3D '" & EditEmail & "', " _
& "strFax =3D '" & EditFax & "' " _
& " WHERE (JobNoMI =3D " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20 ---
Message #10 by "Drew, Ron" <RDrew@B...> on Fri, 12 Jul 2002 11:07:38 -0400
|
|
This line just tells you it errors when executing the command. The real
problem is back on the strSQLUP or one of the parameters. I use for my
updates.
rsUpdate.Open strSQLUP, objConn, adOpenKeyset, adLockPessimistic,
adCmdText
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 10:48 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Line 190 is
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Im not doing no string manipulation or maths
its a basic form where they can edit the details .. ??
Any more help .. pls :)
-----Original Message-----
From: kyle.b.willman@u...
[mailto:kyle.b.willman@u...]
Sent: 12 July 2002 15:35
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Are you performing any arithmetic or string manipulation through
functions? What exactly is line 190 in your code?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Nigel"
<nigel@m... To: "ASP Web HowTo"
<asp_web_howto@p...>
td.co.uk> cc:
07/12/2002 09:25 Subject: [asp_web_howto]
Help with Error
AM
Please respond to
"ASP Web HowTo"
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate =3D Server.CreateObject ("ADODB.Recordset")
strSQLUP =3D "UPDATE tblJobMI SET " _
& "strJobTile =3D '" & EditJobTitle & "', " _
& "Deadline =3D #" & EditDeadline & "#, " _
& "strContactName =3D '" & EditName & "', " _
& "strContactNo =3D '" & EditPhone & "', " _
& "strContactMob =3D '" & EditMobile & "', " _
& "strEmail =3D '" & EditEmail & "', " _
& "strFax =3D '" & EditFax & "' " _
& " WHERE (JobNoMI =3D " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20 ---
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in
reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in
error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=3Dnosim/theprogramm
e
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=3Dnosim/theprogramm
e
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=3Dnosim/theprogramm
e
r-20
Message #11 by Annie Hunt <ajhunt@b...> on Fri, 12 Jul 2002 16:20:38 +0100
|
|
maybe..should there be quotes in the WHERE like this & " WHERE (JobNoMI
'" & Job & "') "
Annie
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: 12 July 2002 15:48
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Line 190 is
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Im not doing no string manipulation or maths
its a basic form where they can edit the details .. ??
Any more help .. pls :)
-----Original Message-----
From: kyle.b.willman@u...
[mailto:kyle.b.willman@u...]
Sent: 12 July 2002 15:35
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Are you performing any arithmetic or string manipulation through functions?
What exactly is line 190 in your code?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Nigel"
<nigel@m... To: "ASP Web HowTo"
<asp_web_howto@p...>
td.co.uk> cc:
07/12/2002 09:25 Subject: [asp_web_howto]
Help with Error
AM
Please respond to
"ASP Web HowTo"
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #12 by "Craig Flannigan" <ckf@k...> on Fri, 12 Jul 2002 16:25:45 +0100
|
|
Does the Variable "JOB" have a number or text string in it, or is it empty?
... WHERE (JobNoMI = " & Job & ") "
Do a Response.write Job before the DB code to see if it contains anything.
You could always convert it to an integer for example
WHERE (JobNoMI = " & cInt(Job) & ") "
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: 12 July 2002 15:53
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Help with Error
I am trying to update various text fields.
there is no numbers in any fields ?
I have a few date fields but i have marked them with the # ??
Im getting reaaly stuck
-Original Message-----
From: Scott Heath [mailto:scott@s...]
Sent: 12 July 2002 15:32
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Help with Error
Nigel,
What data types are the fields in your database? I've had the issue in
the past and it's always been I was trying to update a field that is a
Text field by putting a number in there with out the single quote. Hope
that helps!
Scott
Website | http://www.scottspad.com
E-mail | scott@w...
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
Life's unfair - but root passwords help!
ICMP: The protocol that goes PING!
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 9:26 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
? Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
Message #13 by "Scott Heath" <scott@s...> on Fri, 12 Jul 2002 10:26:27 -0500
|
|
What data type is your date field? Is it Date/Time?
Scott
Website | http://www.scottspad.com
E-mail | scott@w...
Phone: | xxx-xxx-xxxx
Alpha Pager | www.scottspad.com/phone.asp
--------------------------------------------
Life's unfair - but root passwords help!
ICMP: The protocol that goes PING!
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 10:00 AM
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Help with Error
im pretty sure im not dong any math functions ..
line 190 is
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText
i have tried just running the sql statement in Access and i get cannot
update strName field as its not updateable ?
any furtehr ideas ?
-----Original Message-----
From: kyle.b.willman@u...
[mailto:kyle.b.willman@u...]
Sent: 12 July 2002 15:45
To: ASP Web HowTo
Subject: [asp_web_howto] RE: Help with Error
The error in no way references the DB, so it would be my assumption that
the error is IN your code. Not in the SQL statement itself. I bet if
you
look at line 190 you are trying to increment, subtract or perform some
other mathematic function on a variable that is not a number...
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Craig Flannigan"
<ckf@k... To: "ASP Web HowTo"
<asp_web_howto@p...>
h.com> cc:
07/12/2002 09:40 Subject: [asp_web_howto]
RE:
Help with Error
AM
Please respond to
"ASP Web HowTo"
Check your Field Types.
If I try to enter text into a Numeric field, I'd get the same error you
did.
This also means check where you've placed apostrophes too in your SQL
code
you wrote.
Surround only text fields with ' and leave them out for numeric fields.
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: 12 July 2002 15:26
To: ASP Web HowTo
Subject: [asp_web_howto] Help with Error
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting
the following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds ..
this
is probably something really stupid and i just cant figure it out
..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from
Glasshaus. Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
http://p2p.wrox.com/manager.asp
or
_____________________________________________________________________
This message has been checked for all known viruses by Star
Internet
delivered through the MessageLabs Virus Scanning Service on behalf
of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
to
unsubscribe send a blank email to
_____________________________________________________________________
This message has been checked for all known viruses by Star Internet
delivered through the MessageLabs Virus Scanning Service on behalf of
Kingfield Heath Ltd. For further information visit
http://www.star.net.uk/stats.asp
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
to
unsubscribe send a blank email to
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in
reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in
error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #14 by "Aaron Fleming" <aaronf@w...> on Fri, 12 Jul 2002 11:26:05 -0400
|
|
Try adding:
response.write strSQLUP
response.end
Before line 190.
Check your SQL statement. Make sure all the vars are getting passed and
that they are of the proper type.
Aaron
Aaron Fleming
WebPartz Inc.
www.webpartz.com
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 10:48 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Line 190 is
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Im not doing no string manipulation or maths
its a basic form where they can edit the details .. ??
Any more help .. pls :)
-----Original Message-----
From: kyle.b.willman@u...
[mailto:kyle.b.willman@u...]
Sent: 12 July 2002 15:35
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Are you performing any arithmetic or string manipulation through
functions? What exactly is line 190 in your code?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Nigel"
<nigel@m... To: "ASP Web HowTo"
<asp_web_howto@p...>
td.co.uk> cc:
07/12/2002 09:25 Subject: [asp_web_howto]
Help with Error
AM
Please respond to
"ASP Web HowTo"
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in
reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in
error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
Message #15 by "Nigel" <nigel@m...> on Fri, 12 Jul 2002 16:32:15 +0100
|
|
thanks man that has given me an error i know how to fix ...
youve all saved me .. it now means i can go ou and get ratted this weekend
;)
Thanx Drew and everyone for your help
Have a good weekend
:)
-----Original Message-----
From: Drew, Ron [mailto:RDrew@B...]
Sent: 12 July 2002 16:08
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
This line just tells you it errors when executing the command. The real
problem is back on the strSQLUP or one of the parameters. I use for my
updates.
rsUpdate.Open strSQLUP, objConn, adOpenKeyset, adLockPessimistic,
adCmdText
-----Original Message-----
From: Nigel [mailto:nigel@m...]
Sent: Friday, July 12, 2002 10:48 AM
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Line 190 is
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Im not doing no string manipulation or maths
its a basic form where they can edit the details .. ??
Any more help .. pls :)
-----Original Message-----
From: kyle.b.willman@u...
[mailto:kyle.b.willman@u...]
Sent: 12 July 2002 15:35
To: ASP Web HowTo
Subject: [asp_web_howto] Re: Help with Error
Are you performing any arithmetic or string manipulation through
functions? What exactly is line 190 in your code?
Kyle B. Willman
PricewaterhouseCoopers LLP
Office: xxx.xxx.xxxx
Cell: xxx.xxx.xxxx
"Nigel"
<nigel@m... To: "ASP Web HowTo"
<asp_web_howto@p...>
td.co.uk> cc:
07/12/2002 09:25 Subject: [asp_web_howto]
Help with Error
AM
Please respond to
"ASP Web HowTo"
Hi all ..
Im trying to update a field in my Acces Databse and i keep getting the
following error..
Error Type:
Provider (0x80020005)
Type mismatch.
/mintweb/Minternal/job/editjob.asp, line 190
Ive searched about for a bit and cant find any work arounds .. this is
probably something really stupid and i just cant figure it out ..
Any help greatly aprreciated ..
here is the SQL statement
Set rsUpdate = Server.CreateObject ("ADODB.Recordset")
strSQLUP = "UPDATE tblJobMI SET " _
& "strJobTile = '" & EditJobTitle & "', " _
& "Deadline = #" & EditDeadline & "#, " _
& "strContactName = '" & EditName & "', " _
& "strContactNo = '" & EditPhone & "', " _
& "strContactMob = '" & EditMobile & "', " _
& "strEmail = '" & EditEmail & "', " _
& "strFax = '" & EditFax & "' " _
& " WHERE (JobNoMI = " & Job & ") "
rsUpdate.Open, strSQLUP, objConn, adAffectAll, adCmdText Or
adExecuteNoRecords
Hope you guys can help :)
--- Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20 Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20 Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20 ---
_________________________________________________________________
The information transmitted is intended only for the person or
entity to which it is addressed and may contain confidential
and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in
reliance
upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in
error,
please contact the sender and delete the material from any
computer.
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
---
Improve your web design skills with these new books from Glasshaus.
Usable Web Menus
http://www.amazon.com/exec/obidos/ASIN/1904151027/ref=nosim/theprogramme
r-20
Constructing Accessible Web Sites
http://www.amazon.com/exec/obidos/ASIN/1904151000/ref=nosim/theprogramme
r-20
Practical JavaScript for the Usable Web
http://www.amazon.com/exec/obidos/ASIN/1904151051/ref=nosim/theprogramme
r-20
|
|
|
View Cart
