J
Jonathan
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
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