|
| |
|
|
meridian
Posts: 78
Joined: 11/26/2003
Status: offline
 |
RE: keyword search - 4/6/2005 22:11:39
Nothing to be sorry about.
Without people like you and Spooky I would be pulling out my hair wondering what to do.
So if anything you have saved me from sudden baldness ... LOL
Thanks, it is really appreciated
|
|
|
|
BeTheBall
Posts: 6354
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: keyword search - 4/6/2005 22:18:40
Although not intentional, there is a lot of learning that can be gleaned from this thread. For example, if you get this:
Expected ')'
It is exactly what it says. There is a missing parenthesis somewhere and the error will usually tell you the line.
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
That one is a missing End If. Something I am famous for.
SELECT * FROM Results WHERE ([position] LIKE '%%%')Database Results Error: mismatched parameter delimiters
That one has to do with the SQL receiving %%%. It doesn't expect to get % in threes. I think it would have handled '%' or '%%', but not '%%%'.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
BeTheBall
Posts: 6354
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: keyword search - 4/6/2005 23:57:42
Hmmm. Seems you are correct. I created two pages, one pure ASP and one DRW. Each uses this SQL:
SELECT * FROM Employees WHERE [Name] LIKE '%%%'
The one in pure ASP returned all records. The one with the DRW returned:
Database Results Error: mismatched parameter delimiters
Guess I'll file that away in the memory banks somewhere.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 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 
k¥ 