Hello,

This is my declaration of a stored function in ASA:

function DBA.f_TitlePageResult(in a_start integer,in a_limit integer,in
a_target char(40),in a_sql long varchar)

My problem is on parameter *a_sql* which accepts an sql statement. Since
this is a string, it should be enclosed with a quote ('). If my sql
statement has a quote (') ASA will complain. (I have tried replacing it
with 2 quote but it doesn't work)

This is my actual statement:

select dba.f_TitlePageResult(1,10,'search.php','select number(*) as num,
b.book_id, title, author_name, Year(copyright_date) as copyright,
dba.BookCopies(b.book_id) as entries from books b key join book_word key
join word_index where soundex(root_word) = soundex('java')')

The error is near soundex('java').

Is there any escape character for this? I think I'm running out of
quote'?

Thanks for any help.

Sorry..
I've tried again the 2 single quote for the second time and it WORKED JUST
FINE...

You can embed a single ' quote in a 'quoted' literal string by
representing it as two single quotes; e.g., 'Fred''s Not Here' will be
interpreted as Fred's Not Here.

select dba.f_TitlePageResult(1,10,'search.php','select number(*) as
num, b.book_id, title, author_name, Year(copyright_date) as copyright,
dba.BookCopies(b.book_id) as entries from books b key join book_word
key join word_index where soundex(root_word) = soundex(''java'')')

You can also put line breaks in the string to make it more readable if
you want.

Breck


On 11 Dec 2003 16:13:13 -0800, Jayvee Vibar <jayvee (AT) digitelone (DOT) com>
wrote:

--
bcarter (AT) risingroad (DOT) com
Mobile and Distributed Enterprise Database Applications
www.risingroad.com