Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Stored procedure
Started 2 months, 2 weeks ago by deva
Hi, Can we use stored procedure for sql_query in sphinx.conf instead of MySQL query? Deva
Site: Sphinx - Free open-source SQL full-text search engine  Sphinx - Free open-source SQL full-text search engine - site profile
Forum: Common forum  Common forum - forum profile
Total authors: 3 authors
Total thread posts: 5 posts
Thread activity: no new posts during last week
Domain info for: sphinxsearch.com

Other posts in this thread:

Arantor replied 2 months, 2 weeks ago
> Hi, > > Can we use stored procedure for sql_query in sphinx.conf instead of MySQL query? If you can query the results as if it were a regular query, yes. sql_query just sends the query as-is to MySQL and expects a resultset. If that will be returned without use of any variables (since sql_query_pre doesn't work for this AFAIK) it'll work. If in doubt, try it.
Size: 570 bytes
Customize:  Customize "<b>Reply 1</b>: Stored procedure :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

deva replied 2 months, 2 weeks ago
> If in doubt, try it. I tried it using "sql_query= call sphinxindex". But indexer is raising following error. C:\sphinx\bin>indexer --all Sphinx 0.9.8.1-release (r1533) Copyright (c) 2001-2008, Andrew Aksyonoff using config file './sphinx.conf'... indexing index 'pm1'... ERROR: index 'pm1': sql_query: PROCEDURE sphinxindex can't return a result set in the given context (DSN=...
Size: 775 bytes
Customize:  Customize "<b>Reply 2</b>: Stored procedure :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

Arantor replied 2 months, 2 weeks ago
> But the stored procedure is returning data in MySQL query analyzer. Is it returning a regular result set? Try using the same connection details in a PHP script, and see if you can get any results that way.
Size: 305 bytes
Customize:  Customize "<b>Reply 3</b>: Stored procedure :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

mtougeron replied 3 weeks, 4 days ago
> ERROR: index 'pm1': sql_query: PROCEDURE sphinxindex can't return a result set in the > given context (DSN=mysql://root:***@localhost:3306/xxx). > > But the stored procedure is returning data in MySQL query analyzer. > > Any idea? > The solution mentioned in http://www.sphinxsearch.com/bugs/view.php?id=61 might solve this for you. It worked for me when I ...
Size: 834 bytes
Customize:  Customize "<b>Reply 4</b>: Stored procedure :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

 

Top contributing authors

Name
Posts
deva
2
user's latest post:
Stored procedure
Published (2009-09-22 11:53:00)
> If in doubt, try it. I tried it using &quot;sql_query= call sphinxindex&quot;. But indexer is raising following error. C:\sphinx\bin&gt;indexer --all Sphinx 0.9.8.1-release (r1533) Copyright (c) 2001-2008, Andrew Aksyonoff using config file './sphinx.conf'... indexing index 'pm1'... ERROR: index 'pm1': sql_query: PROCEDURE sphinxindex can't return a result set in the given context...
Arantor
2
user's latest post:
Stored procedure
Published (2009-09-22 13:49:00)
> But the stored procedure is returning data in MySQL query analyzer. Is it returning a regular result set? Try using the same connection details in a PHP script, and see if you can get any results that way.
mtougeron
1
user's latest post:
Stored procedure
Published (2009-11-11 19:00:00)
> ERROR: index 'pm1': sql_query: PROCEDURE sphinxindex can't return a result set in the > given context (DSN=mysql://root:***@localhost:3306/xxx). > > But the stored procedure is returning data in MySQL query analyzer. > > Any idea? > The solution mentioned in http://www.sphinxsearch.com/bugs/view.php?id=61 might solve this for you. It worked for me when I got this error.

Related threads on "Sphinx - Free open-source SQL full-text search engine":

Stored procedure in sphinx  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Stored procedure in sphinx
Stored procedure in sphinx

Related threads on other sites:

Replacing this horrible horrible horrible TSQL stored...  Twitter / existentialism - site profile Brian Ng - forum profile Replacing this horrible horrible horrible TSQL stored procedure with a SQL CLR stored procedure. 6:32 AM Nov 3rd from web
Replacing this horrible horrible horrible TSQL stored procedure with a SQL CLR stored procedure. 6:32 AM Nov 3rd from web
What are the memory caps for threads running as a CLR...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.server - site profile microsoft.public.sqlserver.server - forum profile What are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql server 2005 then it creates 10 in m
What are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql server 2005 then it creates 10 in m
Getting the return from a stored procedure from within a...  www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.sqlserver.server - site profile microsoft.public.sqlserver.server - forum profile Getting the return from a stored procedure from within a stored procedure in microsoft.public.sqlserver.server
Getting the return from a stored procedure from within a stored procedure in microsoft.public.sqlserver.server
Oracle Tutorials: learn about PL/SQL Stored Procedure...  Twitter / oracleTips - site profile oracleTips - forum profile Oracle Tutorials: learn about PL/SQL Stored Procedure http://bit.ly/25KDTd/SQL Stored Procedure about 23 hours ago from API
Oracle Tutorials: learn about PL/SQL Stored Procedure http://bit.ly/25KDTd/SQL Stored Procedure about 23 hours ago from API
Stored procedure within stored procedure  Database Journal Forums - site profile Ask an Expert - forum profile Stored procedure within stored procedure
Stored procedure within stored procedure
Error in Stored procedure while using cursor  Expert Communities - bytes - site profile db2 - forum profile Error in Stored procedure while using cursor
Error in Stored procedure while using cursor
Stored Procedure values needed for a new stored procedure  SitePoint : New Articles, Fresh Thinking for Web Developers and Designers - site profile Databases - forum profile Stored Procedure values needed for a new stored procedure
Stored Procedure values needed for a new stored procedure
Problem in calling a Stored Procedure  Hibernate Forums - site profile Hibernate Users - forum profile Problem in calling a Stored Procedure
Problem in calling a Stored Procedure
How do I call a SQL stored procedure from within another...  SitePoint : New Articles, Fresh Thinking for Web Developers and Designers - site profile Databases - forum profile How do I call a SQL stored procedure from within another stored procedure with php?
How do I call a SQL stored procedure from within another stored procedure with php?
Stored Procedure from Stored Procedure  DevX Forums - site profile Database - forum profile Stored Procedure from Stored Procedure
Stored Procedure from Stored Procedure
Thread profile page for "Stored procedure" on http://sphinxsearch.com. This report page is a snippet summary view from a single thread "Stored procedure", located on the Message Board at http://sphinxsearch.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity