Your form (or any ASP referencing DB fields) must be before the DB connection is closed or you will get an error
- Access queries are not always directly translatable or usable in ASP
| Thanks again -
|
| The fields from the DBR which I am trying to reuse are text with the
| exception of one field which is a calculation done in a query and formatted
| $#.00 in the query. The code generates the same error on all fields for me.
|
| The form is definitely AFTER the DBR close
|
| The web I am working on is online - I am working on the site hosted on the
| server yet I get that C:/ in the beginning of the error. Is this something
| I need to discuss with the host?
|
| Can you help?
|
| "Stefan B Rusynko" wrote:
|
| > Type mismatch indicates the data type requested doesn't match a data declaration or name
| > Are you using the form (and database field) before the database connection close is being called in the page and what is your
field
| > name / type?
| >
| > PS
| > If the error has a path starting w/ C:\ you are working in a disc based web rather than a server based web (
http://localhost)
| > required for ASP and DB support
| >
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | Thank you - I need a bit more help though
| > |
| > | I get the following error:
| > |
| > | Microsoft VBScript runtime error '800a000d'
| > |
| > | Type mismatch: 'rs'
| > |
| > | C:\INETPUB\HOST-EXTERNAL\CHESTERBASEBALL\DOCUMENTS\../_fpclass/fpdblib.inc,
| > | line 48
| > |
| > | I have looked at line 48 and I can see that it's got to be related but I'm
| > | at a loss for what to do and what might be incorrect. Can you offer anymore
| > | assistance?
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > If you have already run the DBRW on a page (to filter records to a specific record) the field is available to reuse on the
page
| > in a
| > | > form field
| > | > Double click, the form field and enter the field value for your filed (say "YourName") )as
| > | > <%=FP_FieldVal(fp_rs,"YourName")%>
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > | > "Warning - Using the F1 Key will not break anything!" (-;
| > | > To find the best Newsgroup for FrontPage support see:
| > | >
http://www.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > |I have FP02 and Access 02
| > | > |
| > | > | Registration process - user submits a form that goes to the Access DB - the
| > | > | DBRW generates a confirmation page (pulled from a query). I'd like to take
| > | > | some of the DBRW field outputs and use them as the default value for input on
| > | > | a separate, second form which I'd like to include on the same page as the
| > | > | DBRW.
| > | > |
| > | > | 1.Can I use the DBRW field output as the default value for a field on a
| > | > | form? how?
| > | > | 2. Can I have a separate form on an .asp page whcih displays the DBR?
| > | > |
| > | > | Thanks!
| > | >
| > | >
| > | >
| >
| >
| >
