Database results error

[Andy F]

I have constructed a site with an Access database component Largely using FP
wizards. The data base verifies OK both on my machine and on the server,
input forms work fine but when I create a page with a results wizard I get
the following message:

"Microsoft VBScript runtime error '800a000d'

Type mismatch: 'FP_FieldVal'

/2009 Programme.asp, line 72"


Any ideas?

 

[Stefan B Rusynko]

Type mismatch means you are calling or using a field with a field type in the database different than that in your DBRW code
- check your Access and form field types

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have constructed a site with an Access database component Largely using FP
| wizards. The data base verifies OK both on my machine and on the server,
| input forms work fine but when I create a page with a results wizard I get
| the following message:
|
| "Microsoft VBScript runtime error '800a000d'
|
| Type mismatch: 'FP_FieldVal'
|
| /2009 Programme.asp, line 72"
|
|
| Any ideas?
|
|
|
|

 

[Andy F]

I understand what a 'Type Mismatch, is, but, as in this case, FP produced all
the code (Database Results Wizard) I'm not sure what there is to check.

Andy

 

[Kathleen Anderson]

You could check to make sure you haven't used any reserved words or special
characters:

http://support.microsoft.com/default.aspx?scid=kb;en-us;286335

http://support.microsoft.com/?id=321266

http://support.microsoft.com/?id=826763

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
Expression Web Wiki: http://expression-web-wiki.com/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

I understand what a 'Type Mismatch, is, but, as in this case, FP produced
all
the code (Database Results Wizard) I'm not sure what there is to check.

Andy

Type mismatch means you are calling or using a field with a field type in
the database different than that in your DBRW code
- check your Access and form field types

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I have constructed a site with an Access database component Largely
using FP
| wizards. The data base verifies OK both on my machine and on the
server,
| input forms work fine but when I create a page with a results wizard I
get
| the following message:
|
| "Microsoft VBScript runtime error '800a000d'
|
| Type mismatch: 'FP_FieldVal'
|
| /2009 Programme.asp, line 72"
|
|
| Any ideas?
|
|
|
|