U++ forum: Welcome to the forum

Status & Roadmap

Authors & License

Funding Ultimate++

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Returning a null from select

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Switch to threaded view of this topic

Create a new topic

Submit Reply

Returning a null from select [message #11532]

Sun, 16 September 2007 22:04

dmcgeoch is currently offline

dmcgeoch
Messages: 52
Registered: November 2006
Location: New Jersey

Member

Hopefully this is an easy question even though I've been pulling my hair out. Smile

Smile

I am executing a select statement ( SQL & Select data FROM table ) that may not find a match for the criteria. How do I test for no match. If I try to test the SQL[0] parameter, the program bombs. Is there a way to evaluate for no return value.

Thank you for any assistance,

Dave

Report message to a moderator

Send a private message to this user

Re: Returning a null from select [message #11534 is a reply to message #11532]

Sun, 16 September 2007 22:21

zsolt is currently offline

zsolt
Messages: 697
Registered: December 2005
Location: Budapest, Hungary

Contributor

If your first Fetch() returns with false, you have an empty result set.

Report message to a moderator

Send a private message to this user

Re: Returning a null from select [message #11540 is a reply to message #11534]

Mon, 17 September 2007 02:05

dmcgeoch is currently offline

dmcgeoch
Messages: 52
Registered: November 2006
Location: New Jersey

Member

That was it. Thanks

Report message to a moderator

Send a private message to this user

Switch to threaded view of this topic

Create a new topic

Submit Reply

Previous Topic:	PostgreSQL issues
Next Topic:	Handling multiple rows data in sqlite3

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

PDF

]

Current Time: Mon Apr 29 00:17:13 CEST 2024

Total time taken to generate the page: 0.07911 seconds