Re: Database Results Hell
From: Kathleen Anderson [MVP - FrontPage] (spiderwebwoman_at_mvps.org)
Date: 01/26/05
- Next message: Sameer Dubey: "30day trial version of Frontpage 2002 crashes.."
- Previous message: CliffK: "Re: Form results being read by spiders"
- In reply to: Jonathan: "Database Results Hell"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 26 Jan 2005 12:29:02 -0500
FrontPage doesn't "know" that you've changed the data type of the field.
IMHO, the cleanest way to fix this is to delete the fpdb folder with the
database in it, delete the global.asa, and delete the _fpclass folder. Then
start over by importing database with the new data types and let FP recreate
the files and folders mentioned above.
-- ~ Kathleen Anderson Microsoft FrontPage MVP Spider Web Woman Designs http://www.spiderwebwoman.com/resources/ Jonathan <Jonathan@discussions.microsoft.com> wrote: > Hi Y'all > > I have a really irritating problem (besides my spelling!) > > I have a database results .asp page that lists the entire contents of > a SQL table (Table 1). I used to have a hyperlink from the "ref" > column in table 1 produce results in the next page with the > parametres being linked to a column called "ref" in table 2. As both > these "ref" fields were text and not easy to use as a UID I chnaged > the columns to UID and the properties from char to int (4) and > changed the UID (formerly ref) in table 2 to match the parent record > in table 1. Thats fine I am happy I have done all that correctly at > SQL is right, however................................ > > I have tried to create 2 new pages in my intranet now that the data > has been cleansed in the SQL db. Page 1 to list all the records in > table 1 (it does) page 2 to list records frmo table 2 where the UID = > UID i.e. getting the value from the hyperlink that will eventully be > created in page 1 problem being, when I try to get the 2nd page > Database Results to use the criteria WHERE UID = UID I keep getting > a message about the critera must be an integer. I have never has > this problem before I have many pages lined in such a way, always > ensuring the data in both pages and tables are compatible. What am I > missing? > > Since I rebooted my PC none of the sub folders where these pages are > stored appear in my FP view but are accessible via IE and Explorer. > > Frustrated is not the word.................................. > > Any help or pointers would be greatly appreciated > > > Tia > > > Jonathan
- Next message: Sameer Dubey: "30day trial version of Frontpage 2002 crashes.."
- Previous message: CliffK: "Re: Form results being read by spiders"
- In reply to: Jonathan: "Database Results Hell"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
