Query Filter Workaround/Plan C also not working

[CountryTrash]

Hi Rob,

I have now also tried to put in Plan C

In order to not mess with my Other thread I added a new element (Field) called tender_no to my tender_invitee table.

I then added a calling function to the vendor_id javascript (change action) to see if I get get the tender number to the table in that way.

Can you please see what is the problem with my syntax? for the life of me I cannot seem to see/understand the problem.

It does not update the tender_no field.
I have installed extplorer so you will be able to get to the .js and user_ajax.

Thanks


### vendor_id javascript change action

thetendernumber();


######### 7.js function

function thetendernumber() {
var url = 'http://www.databook.co.za/lptenders/index.php?option=com_fabrik&format=raw&view=plugin&task=userAjax&method=thetendernumber';
var tender_id = form_7.formElements.get('tender_invitees___tender_id').getValue();
new Request({
url: url,
data: {
method: 'thetendernumber', 'tender_id':tender_id
},
onComplete:function(r){
form_7.formElements.get('tender_invitees___tender_no').update(r);

}).send();
};


##### user_ajax function

function thetendernumber() {
$db =JFactory::getDbo();
$tender_id = JRequest::getVar('tender_id', '');
$query = "SELECT tender_number from tenders_register WHERE id = tender_id";
$db->setQuery($query);
$tender_number =$db->loadResult();
echo $tender_number;
}

 

[CountryTrash]

I also tried to copy what Guzman tried to document as an example

I am desperately just trying now to write something into the field hence the
'newone-8'. Only then can I see if the user_ajax returns anything ...

so clearly I have not understood this properly as well. If ANYONE is out there can you please check if I should use the one above or the one below.

this is the new function in my .js file

function thetenderno(){
var url = 'http://www.databook.co.za/lptenders/index.php?option=com_fabrik&format=raw&task=plugin.userAjax';
tendernumber= $('tender_invitees___tender_id').get('value');
new Request({
url: url,
data: {
method: 'thetendernumber','tendernumber': tendernumber
},
onComplete:function(response){
document.getElement('input[name=tender_invitees___tender_no]').value = 'newone-8';
}).send();
}

 

[CountryTrash]

I now also copied and tried Felixkat's example:
Still not writing into my form from the .js


function xtendernumber()
{
var thetender_id = $('tender_invitees___tender_id').getValue();
var url = 'index.php?option=com_fabrik&format=raw&view=plugin&task=userAjax&method=thetendernumber';
new Request(
{
url: url,
data: {
method: 'thetendernumber',
tender_id: thetender_id,
},
onComplete: function (r)
{
$('tender_invitees___tender_no').innerHTML = ("test-8");
}
}).send();
};

 

[CountryTrash]

Insanity: doing the same thing over and over again and expecting different results.
Albert Einstein

The more I am trying what seems to be different things it has the same result :Nothing

I am going insane .....

 

[CountryTrash]

Ok
21.21 South African Time. No one's going to help me tonite anymore.

Let's hope father xmas visits during the night, the sock is on the mantlepiece ....

 

[cheesegrits]

We're on Skype now. Ho Ho Ho. Merry Thanksgiving.

-- hugh

 

[cheesegrits]

OK, we got this pretty much squared away on Skype.

-- hugh

 

[CountryTrash]

Thanks a LOT to Hugh, he is THE MAN


High Five ......