DBA requires basic SQL assistance please

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 11 Mar 2003 09:48:28 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703689592@lnewton.leeds.lfs.co.uk>

Hi Turkbear,

I'm returning the count via the function return and the actual soundex codes via the OUT parameter which is second in the parameter list for the function.

I didn't make it clear - my mistake - that the example was incomplete - the DECLARE section was as per the previous example, so the MyCount and MySoundex variable had been declared as before.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: TurkBear [mailto:john.greco_at_dot.state.mn.us] Posted At: Monday, March 10, 2003 6:37 PM Posted To: server
Conversation: DBA requires basic SQL assistance please (LONG POST) Subject: Re: DBA requires basic SQL assistance please (LONG POST)

I quick look seems to indicate that you are not returning anything other than the integer for MyCount---
Where does the SP get the character string to search with the IN operator ?

Also, you are trying to use :MySoundex but no such bind variable exists until a call to BuildSoundex ( once the OUT value is set)

...

Norman Dunbar <Norman.Dunbar_at_lfs.co.uk> wrote: Received on Tue Mar 11 2003 - 03:48:28 CST