Too few Parameters Expected 1

	Home Register Search Help Login

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Sponsors
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Too few Parameters Expected 1

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Too few Parameters Expected 1

Page: [1]


yks625 Posts: 1 Joined: 3/21/2007 Status: offline	Too few Parameters Expected 1 - 3/21/2007 14:48:14 I am running advanced sql in DW8 using access for the first time. The sql is taken from Access, but when put in recordset gives the error above. The codes are SELECT [210307].[Hol Ref], [210307].Destination, [210307].Field3, [210307].Field4, [210307].[Dept Date], [210307].Length, [210307].Airport, [210307].[Dept Time], [210307].Airline, [210307].[Flight No], [210307].[Dest Code], [210307].Price, [210307].[Hol Code], [210307].[Resort Name], [210307].[Room Type], [210307].[No of Nights], [210307].Board, [210307].Rating FROM 210307 WHERE ((([210307].[Dest Code])="ANU")); Help


Spooky Posts: 26681 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Too few Parameters Expected 1 - 3/22/2007 3:49:05 Try it using single quotes? 'ANU' _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to yks625)