Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: LukeDouglas
- Order by date
-
Multi-table SQL not working in Frontpage (HELP!!!!!)
OK, so they said not to use "HELP!!!" as that is not descriptive. Well, I'm drowning so what else should I say. Anyway, this is continuing the problem with a previous post with a couple of changes. This is a little detailed so please be patient. I cannot get a multi-table query to...- LukeDouglas
- Thread
- Replies: 0
- Forum: Microsoft: FrontPage
-
Multi-table SQL -2147217904 (0x80040E10) Error
OK, so I copied my sql query as follows: SELECT FB_Games.GameNumber, FB_Games.GameDate, Opponent.SchooName FROM Opponent LEFT JOIN FB_Games ON Opponent.SchoolID=FB_Games.OpponentSchoolID ORDER BY ::Sortcolumn:: ASC I set the default for Sortcolumn to GameNumber. This yields the following FP...- LukeDouglas
- Thread
- Replies: 0
- Forum: Microsoft: FrontPage
-
Database Criteria Not Working
Corey, Sorry to be a bummer but Microsoft has this firmly coded so you can't set criteria with custom SQL statements. All criteria has to be in your SQL statement. The only thing you might be able to set is Defaults depending on what you have in your SQL statement. I can tell you this, I...- LukeDouglas
- Post #2
- Forum: Microsoft: FrontPage
