Recent content by vjmehra

Hi, I have what (I think) should be a relatively simple problem to solve, but I'm sure there must be a better way than my current solution! I am using the Webservice function to obtain stock price data from Yahoo Finance, that all works correctly, however I can not work out any way to refresh...

Not yet, always on VB ones as that's all I've done before, I will try that and see if I can shed any light :-) I'll post back here, if I find a solution!

Apologies for the delayed response... Unfortunately however, using your code, I get the following error: Fatal error: Call to a member function fetch_object() on a non-object in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\Blue_Ocean\z_TheFinalPage.php on line 57 With...

Actually I just noticed that if uncomment the following: $query_string->free(); $result1->free(); But leave the following commented out: //$result2=get_dataset($db1,"call sp_filter_issues_reduced_view(".$subsectorid.",".$bondticker.",".$currencyid.",".$countryid.")"); then $result...

If I put in: $query_string->free(); $result1->free(); I get: Fatal error: Call to a member function free() on a non-object in C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\Blue_Ocean\functions.php on line 67 (same error if I put it above return $res_array or on the...

Ok great, I will try that and report back (will have to be later on today unfortunately as I can't get access to the code until the evening).

Only of the first dataset, if I do a var_dump, the first one shows as expected, the second one (which is identical) shows nothing!

The hint is this: Fatal error: Call to a member function fetch_assoc() on a non-object in FILE PATH\functions.php on line 33 (line 33 being the line including fetch_assoc() in the function get_dataset, shown above). Yet it only ever occurs on the 2nd dataset (note I'm using the same query...

Help!!! I'm still stuck on this, surely someone has loaded 2 datasets on a page before????

Any ideas, anyone, I'm really stuck here, can't find anything on google that seems to suggest why this might be occurring :-(

I have a function: //---------------------------------------------------------------------- $server_name='xxx'; $user_name='xxx'; $password='xxx'; $database_name='xxx'; $db1= new mysqli($server_name, $user_name, $password, $database_name)...

I'm not actually using a form, just an Excel spreadsheet, if that makes a difference? The reason I have to add the controls at runtime is because when the initial query button (btnsearch) is clicked it queries the database and returns x rows (depending on the selected filters). Each button is...

Interestingly if I comment out the code to add the buttons, but run the rest, the file size doesn't grow, so this suggests my theory is correct. That said it doesn't explain why the file size doesn't shrink without the buttons and how to stop it continually growing, once they are there!

In Excel (the whole code and all controls are in a single Excel workbook).

I have some code that fires on a button press, which deletes any existing buttons, then adds a series of new buttons. I'm not 100% sure this is what is causing the file size to increase dramatically every time the initial button is clicked, but it seems likely. The odd thing is, I've checked...