Search found 29 matches

by amita
Fri Jul 07, 2006 3:33 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

I have little bit different query....

I will give u an example.

In Mysql, the "Authorid" field in serendipity_authors is AutoIncrement field.
But there is "AuthorID" field in serendipity_authorgroups, serendipity_category, serendipity_config , serendipity_entries, etc.

The value of ...
by amita
Fri Jul 07, 2006 2:24 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

We are back with the new query here!!! :)

What does the autoincrement field works in mysql? In more words,
01. For which fields of which tables it should be incremented ?
02. For which fields of which tables it should get the latest value ?

We wrote different sequences in Oracle for ...
by amita
Thu Jul 06, 2006 9:26 am
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

We made the array to display in the same format as what mysql displays..

And the exciting thing is we are getting the blog page.... with "John Doe Personel blog" as header. But the control on right hand side of the page are not displayed.

we are getting,

Error
serendipity error ...
by amita
Wed Jul 05, 2006 3:12 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

Thanks for your quick and eloborated explanation. Good news is that, we crossed that point and getting the proper return type(s) from serendipity_db_query(). The below is the value of $serendipity array of PHP which has the values of serendipity_config table.
Loading configuration for ...
by amita
Wed Jul 05, 2006 7:32 am
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

We observed different RETURN types in serendipity_db_query() like 'assoc' => OCI_ASSOC,'num' => OCI_NUM,'both' => OCI_BOTH,'true' => true,'false' => false. It shows that any of these types will be returned. But we never observed any code for checking the type of the value returned by ...
by amita
Tue Jul 04, 2006 8:08 am
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

I checked with the mysql output also for the same page....

Its showing the whole Arrays... the whole data from serendipity_config table is displayed as an output....

why it is not displaying it to me... ?

I think i m disturbing you a lot... but i cant help...as u r the only source of ...
by amita
Tue Jul 04, 2006 7:43 am
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

I chnaged the serendipity_db_query function. I just created a samll dummy program to create table, insert rows, select rows etc. its working fine. so i just added those functionality in current Serendipity_db_query()


global $serendipity;
static $type_map = array(
'assoc' => OCI ...
by amita
Mon Jul 03, 2006 9:48 am
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

I tried by replacing the function,

its displaying as follows,


Loading configuration for author ''

SELECT name, value
FROM serendipity_config
WHERE authorid = 0/ Result is:

Final Result is:
Array
(
[GET] =>
[POST] =>
[COOKIE] =>
[templatePath] => templates ...
by amita
Mon Jul 03, 2006 8:08 am
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

I checked with all the sequence of queries in mysql and oracle. The same set of queries are getting executed.

the values inserted are also same in databases except in mysql , id inserted is 1 and for oracle it is 0.

Even i feel the same problem that configuration values are not ...
by amita
Fri Jun 30, 2006 2:21 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

Tha problem of "AS" has been solved.

But still we are gettings things like "PREVIOUS PAGE" "NEXT PAGE" etc.

We checked with the mysql configuration also. The set of table and values inserted inside the table during installation are same.

But the Mysql configuration is going to next ...
by amita
Thu Jun 29, 2006 4:58 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Garvin,

After crossing the installtion page, I am supposed to be directed to a page with Header Text as "John Doe's personal blog" which has calendar, go button and Rss feeds. But in that I am able to see only these links which are disabled « PREVIOUS_PAGE (PAGE_BROWSE_ENTRIES) NEXT_PAGE »
ADMIN ...
by amita
Thu Jun 29, 2006 4:39 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

Again we are one step ahead ... thanks to you.... :D

But agn we are with a new problem.... :D

Actually... Now we are able to navigate through all the steps,
1) Its showing Database Extension as oci8
2) After Clicking on Simple Installation , its asking for the all database values ... i ...
by amita
Thu Jun 29, 2006 1:00 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi falk,
falk wrote:Question: How did you solve the problem with the autoincrement?
We used sequence and trigger for autoincrement.

Thanks,
Amita
by amita
Thu Jun 29, 2006 12:15 pm
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

I removed all "AS" in queries. but then too those 2 queries rae displayed. And we are not able to move further. Now it is displaying "AS" only for following lines in both the queries. It seems that these queries rae created by $cond[joins]. I commented all $cond[joins] and tried to run ...
by amita
Thu Jun 29, 2006 6:15 am
Forum: General discussions
Topic: Conversion of some mysql php functions to oci functions.
Replies: 59
Views: 404414

Hi Garvin,

I think we were so stuck to the problem... that we missed to create that table authorgroups.
:D thanks a lot....

Now we are here with a new problem.... :)

Actually the following queries are created dynamically there eventhough all tha tables are present. And they r giving warnings ...