[Bond-users] Last Post

[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 at hcoop.net
>> http://hcoop.net/cgi-bin/mailman/listinfo/bond-users
>>     
>
>
>