What's wrong w/ this SQL statement

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
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.

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

What's wrong w/ this SQL statement

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 >> What's wrong w/ this SQL statement

Page: [1]

Guest

What's wrong w/ this SQL statement - 6/22/2001 23:10:00

This gets 'Too Few Paremeters' Exp 2. Error.:

SELECT * FROM Monkey WHERE ((Dept=left(': 1::',4)) AND ((Act/Plan=': 2::')))

However, this one works correctly:

SELECT * FROM Monkey WHERE (Dept=left(': 1::',4))

What is the right combination of parentheses when adding the AND qualifier? I've tried almost everything.


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: What's wrong w/ this SQL statement - 6/22/2001 13:01:00 I duuno with all those emoticons. However it looks to me you may have a prob with your column definition "Act/Plan" - I didn't think that / (slash) character was allowed when connecting ASP and FP db's but I'm not positive.... (in reply to Guest)


Guest	RE: What's wrong w/ this SQL statement - 6/22/2001 15:01:00 Answer: Renamed 'Act/Plan'to 'Type'and got rid of some unnecessary parenthesis's SELECT * FROM StaffActuals WHERE Type=': 2::' AND Dept=left(': 1::',4) (in reply to Guest)

Spooky

Posts: 26723
Joined: 11/11/1998
From: Middle Earth
Status: offline

RE: What's wrong w/ this SQL statement - 6/22/2001 21:14:00

Be careful using "type" as well. Its a reserved word in Access

http://support.microsoft.com/support/kb/articles/Q109/3/12.asp

------------------
§þððk¥
"I am Spooky of Borg. Prepare to be assimilated, babycakes!"
Subscribe to OutFront News
Database / DRW Q & A
The Spooky Login!
VP-ASP Shopping cart

(in reply to Guest)

Page: [1]

All Forums >> Web Development >> ASP, PHP, and Database >> What's wrong w/ this SQL statement

Page: [1]

Jump to: 1

New Messages	No New Messages
Hot Topic w/ New Messages	Hot Topic w/o New Messages
Locked w/ New Messages	Locked w/o New Messages

Post New Thread

Reply to Message

Post New Poll

Submit Vote

Delete My Own Post

Delete My Own Thread

Rate Posts