Need some error trapping...

cpk · January 26th, 2005, 07:18 AM

I am looking for some error trapping code to help me... Problem is that the RequestName is not always in the database so throws up an error. Is there a way to display a nice error?

MyCode:
select * from CPD where Name = "&RequestName&" Order By DateAdded DESC

sorry for being so thick and thanks
ck

ChrisScott · January 26th, 2005, 07:32 AM

What sort of error are you getting? It looks like you just need to check whether your query returns a record or not.

Cheers,

Chris

cpk · January 26th, 2005, 07:51 AM

Yes thats what i need... Here is the error anyway:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Joe Bloggs'.

standard error message
thanks
ck

ChrisScott · January 26th, 2005, 08:02 AM

Is your name field a VARCHAR? If so, change the query to:

Code:

"select * from CPD where Name = '" & RequestName & "' Order By DateAdded DESC;"

I would also replace any single quotes within RequestName with a pair of single quotes.

HTH,

Chris

cpk · January 26th, 2005, 08:10 AM

Bingo that did it!

Cheers Chris