|
| |
|
|
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(': ![]("http://www.frontpagewebmaster.com/ubb/biggrin.gif") 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: 9270
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....
| |
|
 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
|
|
|
Printable Version 
