Last Post

[Colin Close]

Hi Dru,

Seems I missed the point on livesql I have just found the example sorry
for the misunderstanding.  Is there any way of sending raw SQL to the
server without having to go through the parser? Does it get sent anyway
if the parser fails?
The libpq wrappers seem to indicate this but my understanding of C is
alas fairly lowly. I have a friend who very proficient in C who will
help by adding any extra functionality required. This would of course be
contributed back.
In order to determine what I need I have to understand the way the
software is structured so I can give him some idea of what I require.
For this I need the developer docs which are not in the download. I
tried to get them from the svn repositry but all I get is the directory
structure all the files are giving access denied presumably because of
lack of permissions. Do you think you could fix the repositry so I can
download them.

Thanks

Colin Close


_______________________________________________
Bond-users mailing list
Bond-users@...
http://hcoop.net/cgi-bin/mailman/listinfo/bond-users

[Dru-2]

Hello. sorry in delay in replying. I had written a large email to
previous email but my comptuer died half way though and only just kind
come back online.

If the parser fails it still goes to the SQL server. it doesnt stop the
sql running just warns about it.
Have you got any example sql + xml that i can test from my end if it
doesnt work?

If you can email me a username and password I can give you access.


Colin Close wrote:

> Hi Dru,
>
> Seems I missed the point on livesql I have just found the example sorry
> for the misunderstanding.  Is there any way of sending raw SQL to the
> server without having to go through the parser? Does it get sent anyway
> if the parser fails?
> The libpq wrappers seem to indicate this but my understanding of C is
> alas fairly lowly. I have a friend who very proficient in C who will
> help by adding any extra functionality required. This would of course be
> contributed back.
> In order to determine what I need I have to understand the way the
> software is structured so I can give him some idea of what I require.
> For this I need the developer docs which are not in the download. I
> tried to get them from the svn repositry but all I get is the directory
> structure all the files are giving access denied presumably because of
> lack of permissions. Do you think you could fix the repositry so I can
> download them.
>
> Thanks
>
> Colin Close
>
>
> _______________________________________________
> Bond-users mailing list
> Bond-users@...
> http://hcoop.net/cgi-bin/mailman/listinfo/bond-users

--
Andrew Hill
treshna Enterprises Ltd
Tel: [phone]
Cel: 021 660 819
Web: www.treshna.com
IT Consultancy - Websites - Database development - Computer tech support

_______________________________________________
Bond-users mailing list
Bond-users@...
http://hcoop.net/cgi-bin/mailman/listinfo/bond-users

[Colin Close]

Hi Dru,

I wondered what had happened.  I guess a good user name and pword
would be "herries" and "6millroad7" respectivley.

I have many questions to ask about Bond I hope you have plenty of patience!!
There are two that are burning in my mind.

The first is if Bonddb carries on and executes SQL code irrespective of
whether it understands it What happens?
Clearly the message is ultimately delivered via a wrapped pgexec so
results are returned but what happens to them.

The second is that if results can be somehow returned what does Bond
need to know to be able to insert them in a field.

If my initial read of the code (very superficial) it seems there has to
be a database object both in the server db and Bonddb so Bond doesn't
seem to be a full client - server arrangement but has an intermediate
stage as in Bonddb which appears to load data before Bond itself can
really do anything.  I can see no reason why Bonddb shouldn't be told
that an object will come into existence and what data type it will be
returned (although all data will be returned as text or binary).  
Including the type would be advantageous since that would leave open the
potential for conversion. I suppose one could take advantage of Bonddbs
existing mechanisms and create a dummy table in the server-db with no
data and perhaps assign the SQL to that table. I'm kind of groping for
understanding here.

I'll give the developer docs a read and try and improve the clarity of
my questions.
BTW some of the code comment caused considerable amusement 'specially
the bit with the shopping list!!!

Best

Colin Close


Dru wrote:

>  
> Hello. sorry in delay in replying. I had written a large email to
> previous email but my comptuer died half way though and only just kind
> come back online.
>
> If the parser fails it still goes to the SQL server. it doesnt stop the
> sql running just warns about it.
> Have you got any example sql + xml that i can test from my end if it
> doesnt work?
>
> If you can email me a username and password I can give you access.
>
>
> Colin Close wrote:
>  
>> Hi Dru,
>>
>> Seems I missed the point on livesql I have just found the example sorry
>> for the misunderstanding.  Is there any way of sending raw SQL to the
>> server without having to go through the parser? Does it get sent anyway
>> if the parser fails?
>> The libpq wrappers seem to indicate this but my understanding of C is
>> alas fairly lowly. I have a friend who very proficient in C who will
>> help by adding any extra functionality required. This would of course be
>> contributed back.
>> In order to determine what I need I have to understand the way the
>> software is structured so I can give him some idea of what I require.
>> For this I need the developer docs which are not in the download. I
>> tried to get them from the svn repositry but all I get is the directory
>> structure all the files are giving access denied presumably because of
>> lack of permissions. Do you think you could fix the repositry so I can
>> download them.
>>
>> Thanks
>>
>> Colin Close
>>
>>
>> _______________________________________________
>> Bond-users mailing list
>> Bond-users@...
>> http://hcoop.net/cgi-bin/mailman/listinfo/bond-users
>>    
>
>
>  

_______________________________________________
Bond-users mailing list
Bond-users@...
http://hcoop.net/cgi-bin/mailman/listinfo/bond-users

[Dru-2]

Colin Close wrote:
> Hi Dru,
>
  > I have many questions to ask about Bond I hope you have plenty of
patience!!
> There are two that are burning in my mind.
>
> The first is if Bonddb carries on and executes SQL code irrespective of
> whether it understands it What happens?
> Clearly the message is ultimately delivered via a wrapped pgexec so
> results are returned but what happens to them.

Yes it will always execute what is passed to it, whether it understands
it or not.

> The second is that if results can be somehow returned what does Bond
> need to know to be able to insert them in a field.

Inserting records you mean? For inserting new records bond needs to
understand the sql statement to know what tables are in the from statement.

> If my initial read of the code (very superficial) it seems there has to
> be a database object both in the server db and Bonddb so Bond doesn't
> seem to be a full client - server arrangement but has an intermediate
> stage as in Bonddb which appears to load data before Bond itself can
> really do anything.  I can see no reason why Bonddb shouldn't be told
> that an object will come into existence and what data type it will be
> returned (although all data will be returned as text or binary).  
> Including the type would be advantageous since that would leave open the
> potential for conversion. I suppose one could take advantage of Bonddbs
> existing mechanisms and create a dummy table in the server-db with no
> data and perhaps assign the SQL to that table. I'm kind of groping for
> understanding here.

bonddb is a wrapper around the postgresql client libraries that make
dealing with things like inserting/deleting/updating records a lot
easier. it doesnt do a whole lot of stuff. bonddbfield.c/h is the
individual descriptions on the fields returned from the select query and
what there datatypes are.

> I'll give the developer docs a read and try and improve the clarity of
> my questions.
> BTW some of the code comment caused considerable amusement 'specially
> the bit with the shopping list!!!

lol. yes. it even got a mention on slashdot article for bad commenting
styles.

>
> Best
>
> Colin Close
>
>
> Dru wrote:
>>  
>> Hello. sorry in delay in replying. I had written a large email to
>> previous email but my comptuer died half way though and only just kind
>> come back online.
>>
>> If the parser fails it still goes to the SQL server. it doesnt stop the
>> sql running just warns about it.
>> Have you got any example sql + xml that i can test from my end if it
>> doesnt work?
>>
>> If you can email me a username and password I can give you access.
>>
>>
>> Colin Close wrote:
>>  
>>> Hi Dru,
>>>
>>> Seems I missed the point on livesql I have just found the example sorry
>>> for the misunderstanding.  Is there any way of sending raw SQL to the
>>> server without having to go through the parser? Does it get sent anyway
>>> if the parser fails?
>>> The libpq wrappers seem to indicate this but my understanding of C is
>>> alas fairly lowly. I have a friend who very proficient in C who will
>>> help by adding any extra functionality required. This would of course be
>>> contributed back.
>>> In order to determine what I need I have to understand the way the
>>> software is structured so I can give him some idea of what I require.
>>> For this I need the developer docs which are not in the download. I
>>> tried to get them from the svn repositry but all I get is the directory
>>> structure all the files are giving access denied presumably because of
>>> lack of permissions. Do you think you could fix the repositry so I can
>>> download them.
>>>
>>> Thanks
>>>
>>> Colin Close
>>>
>>>
>>> _______________________________________________
>>> Bond-users mailing list
>>> Bond-users@...
>>> http://hcoop.net/cgi-bin/mailman/listinfo/bond-users
>>>    
>>
>>  
>
>
> _______________________________________________
> Bond-users mailing list
> Bond-users@...
> http://hcoop.net/cgi-bin/mailman/listinfo/bond-users

--
Andrew Hill
treshna Enterprises Ltd
Tel: [phone]
Cel: 021 660 819
Web: www.treshna.com
IT Consultancy - Websites - Database development - Computer tech support

_______________________________________________
Bond-users mailing list
Bond-users@...
http://hcoop.net/cgi-bin/mailman/listinfo/bond-users