RE: keyword search (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

BeTheBall -> RE: keyword search (4/6/2005 22:02:58)

Great. If my syntax were a little better you'd have had it up and going about 5 posts ago. Sorry. [&o]



meridian -> 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 -> 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 '%%%'.



Spooky -> RE: keyword search (4/6/2005 22:52:17)

Hmm - must be a DRW thing, you can do it in regular asp [&o]



BeTheBall -> 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.



Page: <<   < prev  1 [2]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.046875