I will not find the solution for you over this 33K modem... Read Sql.pike.

/ Martin Nilsson (saturator)

Previous text:

2003-12-19 23:36: Subject: Re: SQL

---

ok, so what do i need to do to have sqlite be a supported "protocol"?

I have a sqlite.pike and sqlite_result.pike in the Sql.pmod directory, each inheriting the proper files, but still no workie...

any thoughts?

bill

On Fri, 19 Dec 2003, Martin Nilsson (saturator) @ Pike (-) developers forum wrote:

...

And Sql.Sql does that for you when you call its big_query and the lower level has no big_query method.

/ Martin Nilsson (saturator)

Previous text:

...

2003-12-19 21:41: Subject: Re: SQL

---

...

you could just fake big_query() by executing the query at once, storing it in an array inside the object returned, and then have the methods access the array.

This is exactly what Sql.sql_result does. You can do

Sql.sql_result(xxx->query("blah"))

to convert a normal query result to a big_query result.

/ Marcus Comstedt (ACROSS) (Hail Ilpalazzo!)

/ Brevbäraren