Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 25th, 2005, 04:45 AM
Authorized User
 
Join Date: Apr 2005
Location: , , .
Posts: 73
Thanks: 0
Thanked 0 Times in 0 Posts
Default Query Builder Help

I am in need of help, I have a Access Database where I am trying to extract data from, I'm using VB.NET.
I have 3 columns labelled Chassis, Board and HDD Type, I have written data to the database.
I am using a VB.NET form where I have 3 dropdown lists for the 3 colums.
The error I receive when trying to query the database is as follows

ERROR
There was a problem executing your query
Please check your query and database and try again. Details;
Syntax Error(missing operator) in query expression '(([Server].[Board]=@Board)AND([Server].[Chassis]=@Chassis)AND([Server].[HDD Type]=@HDD Type))'
END

Any help would be greatly appreciated.

 
Old April 25th, 2005, 05:11 AM
Friend of Wrox
 
Join Date: Apr 2005
Location: Cochin, , India.
Posts: 186
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dwizz,

You cannot create paramters with spaces

-> [HDD Type]= @HDD Type

remove space in "@HDD Type"

I think this should solve the issue









Similar Threads
Thread Thread Starter Forum Replies Last Post
course builder youyou_hym Dreamweaver (all versions) 1 May 28th, 2008 03:09 AM
sql query builder windw size problem the_dude ASP.NET 2.0 Basics 0 January 25th, 2007 01:37 PM
Looking for a SQL Query Builder for ASP.Net/Oracle rashid_masud SQL Language 0 March 9th, 2006 06:37 AM
C++ Builder 6 - Datamodule rowin C++ Programming 0 January 19th, 2006 10:46 AM
how to launch Query Builder tz478 BOOK: Professional SQL Server Reporting Services ISBN: 0-7645-6878-7 0 March 29th, 2005 10:54 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.