Re: [GENERAL] call function with different select statement

2006-05-12 Thread John DeSoi
What is the return type of your function? To me it looks CSNTExtractUserClearTextPw2 has something like "RETURNS custom_type" whereas CSNTExtractUserClearTextPw has "RETURNS SETOF custom_type". If you need rows (even if just 1 row), use "SETOF". On May 10, 2006, at 11:49 AM, [EMAIL PROTECT

[GENERAL] call function with different select statement

2006-05-12 Thread [EMAIL PROTECTED]
I'm working the Cisco ASC for wireless authentication and I'm having problems getting the ODBC results in a format the ASC server understands. I created a function that returns basic information for a given user. The ACS server issues the following command : select CSNTExtractUserClearTextPw2('c