Search Results - VBForums

Search:

Type: Posts; User: vjmehra

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

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

    Re: mysqli dataset, 2nd query not working...

    Surely someone must have tried to load 2 datasets before, has no-one come across this before?
  3. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

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

    Re: mysqli dataset, 2nd query not working...

    Ok, so I've just tried the following:



    $result=get_dataset($db1,"call sp_filter_issues_reduced_view(".$subsectorid.",".$bondticker.",".$currencyid.",".$countryid.")");...
  5. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    Its a stored procedure, so it won't mean anything to you, but its correct, it has been working absolutely fine, up until I started changing the php.

    The SQL has not been changed at all, it works...
  6. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    oddly, if I use the get_dataset function (which is essentially the same code), I just get:

    Fatal error: Call to a member function fetch_assoc() on a non-object in FILE PATH\functions.php on line...
  7. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    Not sure why my bit double posted there!

    But yes it does return an error, which makes sense, given the error message I was getting before.

    But why?

    The SQL is correct, even if I hard code...
  8. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    Having played around a bit, I've still go absolutely nowhere, so I'd really appreciate any help...

    In my efforts to try and get things working, I've tried to re-look at the function that converts...
  9. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    Having played around a bit, I've still go absolutely nowhere, so I'd really appreciate any help...

    In my efforts to try and get things working, I've tried to re-look at the function that converts...
  10. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    Yep, fair point! This is the error:

    <b>Warning</b>: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in <b>C:\FILE PATH\functions.php</b> on line <b>110</b><br />
    ...
  11. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    ...actually...perhaps more embarrassing...it doesn't work, I made the change, but re-loaded by backup copy (with very old code), the updated code unfortunately still does not work :-(
  12. Re: File Size Increasing Dramatically every click!

    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...
  13. File Size Increasing Dramatically every click!

    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...
  14. Replies
    4
    Views
    807

    Re: Dynamic Command Buttons- Single Macro

    Great thank you, I will have a look through that!
  15. Replies
    4
    Views
    807

    Re: Dynamic Command Buttons- Single Macro

    Hmm, I tried searching on calendar, there are 4 pages of hits, but I can't see one that seems to refer to this (well not obviously anyway) :-(
  16. Re: Run-time error '-2147467249 (80004005)' Method 'Open' of object _Recordset' faile

    I changed the code around quite a bit in between events, so I suspect that did occur. Either way, I'll mark this as resolved now :-)
  17. Replies
    4
    Views
    807

    Dynamic Command Buttons- Single Macro

    I have some code that loops through a series of rows, the data comes from a MySQL database and when a query button is clicked the code fires and a command button is created on each row.

    The name...
  18. Replies
    16
    Views
    2,343

    Re: mysqli dataset, 2nd query not working...

    Um yes that fixed it...I feel quite embarrassed not to have noticed that myself!!!
  19. Re: Run-time error '-2147467249 (80004005)' Method 'Open' of object _Recordset' faile

    I tried that, that made no difference :-(

    However I re-wrote a separate function for opening the recordset:

    Public Function open_recordset(SQL_String As String, Database_Connection As...
  20. [RESOLVED] Run-time error '-2147467249 (80004005)' Method 'Open' of object _Recordset' failed

    I know there are hundreds of examples around, for some reason none work for me...

    I have a connection to a MYSQL database, which worked fine, but when trying to tidy up the code it stopped...
  21. Replies
    16
    Views
    2,343

    mysqli dataset, 2nd query not working...

    I've seen plenty of examples of how to do this and for some reason non seem to work for me.

    On test.php I have:

    $result=get_dataset($db1,"call...
  22. Replies
    5
    Views
    1,290

    Re: Very slow running code....

    Ok...all other problems aside...the key issue here (I think) is that now I'm only using the following line once:

    $db1 = new mysqli($server_name, $user_name, $password, $database_name);

    Only the...
  23. Replies
    5
    Views
    1,290

    Re: Very slow running code....

    I tried using the global, but that unfortunately doesn't seem to make any difference :-(
  24. Replies
    5
    Views
    1,290

    Re: Very slow running code....

    Ok, now I think I've confused myself! I tried to do what you said about only having one connection at the start, then closing it at the end, but I've done something wrong.

    Here is the code:
    ...
  25. Replies
    5
    Views
    1,290

    Very slow running code....

    I'm getting the following error:

    Fatal error: Maximum execution time of 30 seconds exceeded in \SERVER_PATH\functions.php on line 19

    (where SERVER_PATH is the actual path).

    I can't work out...
  26. Replies
    1
    Views
    1,231

    Re: Capturing array data from $_POST

    I don't know if this is the neatest way...but this seems to work:

    if (isset($_POST["btnupdate"]))
    {
    include_once('reduced_view_issues.php');

    $irow=0;
    foreach ($_POST['issueid'] as $result) {...
  27. Replies
    1
    Views
    1,231

    [RESOLVED] Capturing array data from $_POST

    I have a form with an update button (btnupdate), which, when clicked triggers the php script 'select_issue3'php'. This is the section of code that I'm struggling with:

    if...
  28. Replies
    7
    Views
    1,515

    Re: $_POST problem

    Yep that makes sense, makes things much neater!
  29. Replies
    7
    Views
    1,515

    Re: $_POST problem

    Got it!

    One of those really frustrating ones that you feel you should have spotted straight away, but a day or two away seems to have done the trick...

    When the bonddescriptiom array gets...
  30. Replies
    7
    Views
    1,515

    Re: $_POST problem

    Hmm, that doesn't appear to work.

    I'm not sure if it will help, but here is the initial page:

    <head>
    <title>Issues- Reduced View</title>
    </head>
    <body marginheight="0" topmargin="0"...
  31. Replies
    7
    Views
    1,515

    Re: $_POST problem

    Here is 'select_issue2.php', I've included the whole page, as its just one form, which I believe is posting correctly (bar the issues mentioned above):

    <html>
    <head>
    <title>View Issues</title>...
  32. Replies
    7
    Views
    1,515

    [RESOLVED] $_POST problem

    I have a series of webforms, that all look at the following .php script when a button is clicked (i.e. form action is set to post).

    The script is firing, so this works correctly, however the...
  33. Replies
    6
    Views
    1,126

    Re: Row Select, not quite working...

    Oooops!

    Yeah, sorry, should have spotted that.

    I've learnt something new today, I never realised you could have multiple forms on a single html page!

    That will help me out quite a lot, many...
  34. Replies
    6
    Views
    1,126

    Re: Row Select, not quite working...

    So you mean like this:

    echo "<form>";
    echo "<input type='submit' width='100%' id='bonddescription' name='bonddescription[]' value='" .$row['description']. "'><input type='hidden' id='issueid'...
  35. Re: MySQL Stored Procedure, taking ages to run, only 5 records in the DB!!!

    Yep, which confuses me!
  36. Replies
    6
    Views
    1,126

    Re: Row Select, not quite working...

    I can do this with checkboxes, but I can not find a single example of people doing this without checkboxes, which is odd as this scenario must come up all the time.
  37. Replies
    6
    Views
    1,126

    Row Select, not quite working...

    I am trying to submit a value, based on a button click, here is the php code for the button:

    echo "<input type='submit' width='100%' id='bonddescription' name='bonddescription[]' value='"...
  38. Re: MySQL Stored Procedure, taking ages to run, only 5 records in the DB!!!

    Ok cool, I'm not familiar with explain, so I'll educate myself on that, looks like it could be quite useful :-)

    That aside, would that explain why the performance in MySQL Query Analizer is fine,...
  39. Replies
    5
    Views
    1,443

    Re: Multiple Select List Box

    Ok, solved it!

    I created one new function, get_sub_dataset (which is for the inner loop), then I adapted my existing function for drop down/list boxes, here is the code:

    function...
  40. Replies
    5
    Views
    1,443

    Re: Multiple Select List Box

    Yeah, I think thats what I meant, was really struggling to get my head around it last night. If it helps, the real world example is as follows (its for a bond trading system):

    There is a list of...
Results 1 to 40 of 107
Page 1 of 3 1 2 3



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.