Hi. Thank you for the replies. I think I have resolved my initial problem... well I've got to the next error message anyway. I did not realise that I had installed PHP 5.6 with a thread-safe dll, which meant that I needed to enable to relevant thread-safe sql server driver for my version of PHP (5.6).
I was side-tracked by reading somewhere that I needed to use the non-thread-safe driver if I was connecting to a Microsoft SQL Server, so I hadn't even attempted to enable the thread-safe drivers in php.
Remember. If you've got PHP5ts.dll in your PHP directory, you should use the two drivers (php_pdo_sqlsrv_56_ts.dll, php_sqlsrv_56_ts.dll).
The pdo_sqlsrv option is now showing as enabled when I use phpinfo().

I am trying to connect to a Microsoft SQL server database using PHP 5.6 and am getting the error "could not find driver".
I am initially attempting to use PDO but I could use the procedural version if necessary.
I have downloaded the SQL server PHP driver and placed it in the ext folder in my PHP installation.
I have also specified the extension in php.ini.
My web server is IIS 7.
My platform is Windows 7 Professional (the same box for both the database and the web servers).
PHP is executed correctly by IIS.
I think I must be missing something but can't find out what.
I would appreciate any pointers to what I might have missed or even a tutorial on how to combine the various technologies I have chosen.
I'm sure that someone must have succeeded in doing this.

Your 'question' is unanswerable. You need to explain what you are attempting to do and maybe add at least a small amount of code, if you already have some.
opencart is not a PHP function so what is it?

Hey. You sound desparate. You must be if you posted in this forum rather than contacting klp directly. I guess you don't have any contact details for whoever it is. I hope that you've resolved your issues.

This is quite a wide ranging question. I guess you will need to determine the 'mechanics' of how the user will select inventory items and how many of each. So you'll need a table for storing the users' orders. Will you provide the user with a drop-down list of inventory items or create a grid for them to select items and enter quantities required? Do you want to save each item as the user selects them, or have the user select a 'save' button to commit the order to your database? Once you have determined how you want the user to do the ordering process, you can determine what fields (columns) you will need in the database. You will most likely need to have a cancel item or cancel whole order feature.

To find out how to calculate time differences, try the following link:-

I'm not sure about the time questions but the path exists question may be answered by this:-

On Error Goto err_handler

Open "c:\test.txt" For Input As #1

Select Case Err.Number
       Case 53: Msgbox "File Not Found"
       Case 55: Msgbox "File Already Open"
       Case 71: Msgbox "Disk Not Ready"
End Select

Resume Next

I think you need to make your question more explicit. For example, what is DC? Are you refering to a particular development environment?

Having the content in a database is a good idea. You could have a separate application to allow the editor to submit new items. That application may, or may not be a web application. That way you can keep the application simple. MySQL and PHP are good for this purpose.

are you able to connect to MySQL from a Windows command window using the same user id for the MySQL user?
It is recommended that you set a secure password for the root user when setting up MySQL.

Since you mention 'safe mode' I assume that you are running a Windows operating system. To resolve the upside down screen try using Ctrl/Alt/up arrow.
Are you able to get the boot menu to display by pressing F8 during startup (and before the Windows logo appears)?
It could be a faulty device driver that may be causing the problem. Have you added any new devices?
If you have a Windows installation DVD available, you could try doing a Repair by booting from it.

C++ might possibly get you a job but I suggest that you specialise a bit more and find a specific application of C++ that you can develop some kind of expertise in. for example finance, gaming or communications.

I have been able to answer my own question. The ListIndex property of the list box control can be set to the integer value of the list item. For example:-

lstBox.ListIndex = 3
Jx_Man commented: Good :) +14

Hello. I have a listbox that I would like to display and I would like to set a default selected item, which I will not be able to determine until run-time. Is it possible to set a default item in the program code?
I have looked at the Index property but that appears to be a read-only property.

Thanks guys.
I am getting the impression that the DataGrid component wasn't really designed to be used in this way.

Hi all.
Using VB6:
I have an application in which I am programmatically populating a datagrid.
When I first drop the datagrid on my form, it has 2 columns by default.
I can add further columns to them but I wanted to know if there was a tidy way of starting from column 1 to begin with, or do I just have to delete the first two columns and start again?

This is (pretty much) my column definition loop

For Each Col In RsDivisions.Fields

    Set c = DataGridDiv.Columns.Add(DataGridDiv.Columns.Count)
    With c
      .Visible = True
      .Width = 1000
      .Caption = Col.Name
      .Alignment = dbgRight
    End With


I hear you, and I agree.
Here's an HTML form:


<h1>PHP Email Form</h1>
<form action="EmailFormData.php" method="post" name="mailform">
<table align=center cellpadding=5 cellspacing=0>
       <td><input type="text" name="data1" size="12"></td>
       <td><input type="text" name="data2" size="12"></td>
       <td><input type="text" name="data3" size="12">
       <input type="submit" name="Send" value="Send">

and here's the PHP script, EmailFormData.php:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">


<body BGCOLOR=#0099FF>

<!-- This script is designed to be a simple email test -->

# Create an empty message variable.
# The mail that we want to use to receive the submitted information.
$MailFrom = "FromAddressForDisplay@YourDomain";
# The E-Mail subject
$subject="This is a message from PHPEmailForm.html";
# iterate the $_POST array
foreach ($_POST as $key=>$value)
    $message.=$key.": " . $value . "\n";
# Send message by e-mail.
if($sm=mail($to, $subject, $message, "From: $MailFrom"))
   print("<B><CENTER><FONT COLOR=BLUE>Your email has been successfully sent</FONT></CENTER></B>\n");
   print("<B><CENTER><FONT COLOR=RED>OOPS. Something's gone wrong. Try debugging your script.</FONT></CENTER></B>\n");



I've just added a bit of colour to the feedback.
I hope you like it.

LastMitch commented: Thanks for the nice update! +11

My first suggestion would be to add a debugging statement to just display the resulting sql query for the update before you try to execute it. It's surprising how easy it can be to spot the basic errors that way.

I think you've just learnt an important lesson. Always remember to paste what you want to save from the paste buffer, especially if it's a large amount of program code.
I find that opening a simple text editor and pasting text temporarily to it can be useful.
I must admit I had difficulty in following your question in the forum. Is English your first language?

If I was designing something like this, I would do it the other way around. By which I mean that, rather than inserting a row with empty columns, I would only insert rows that have data in each column, especially columns that are keys. When each new row is inserted you can query the database table to re-display the current rows then prompt for a new row's details (either at the bottom or at the top of the returned results).
I wasn't quite sure, from your interface image, how the number of blank rows was determined. Perhaps it was a static page rather than a dynamic one.

I can recommend http://today.java.net/pub/a/today/2005/02/09/j2me1.html as a good starting place.

I suggest that you change

salary += ((salary / 100) * 10);
salary += (salary * 0.10);

I suspect that although the variable, salary, was specifically assigned as a double, the type was dynamically changed as a result of the expression, because the expresssion resulted in a whole number.

JamesCherrill commented: That's not how Java evaluates mixed float/int expressions -3

I have a VB.NET application that has a site.master with a navigation menu in landscape format.
In my default.aspx I have a multiview component. When I select the second view in my multiview the navigation menu momentarily changes to portrait format and then back to landscape format.
Ideally, I would like my navigation menu to remain in landscape orientation, or even supress the refresh of the site.master page. I don't know what is causing the component to perform the orientation change at run time so if any one knows what could be causing this, I would appreciate a reply.

Hi Glenn. I'm not Canadian but I have visited Canada and think it's a lovely country. I hope you enjoy Daniweb.

Firstly, I think that password may have been mistyped where you accept the user's input to the variable, $password.
I would suggest using a date type field in your table and construct a variable to contain the date, in the format yyyy-mm-dd. I think that's how I have done it.

Well I'm still using Windows XP on my home desktop and most of the pcs where I work are still on Windows XP. I must admit that I prefer XP to Windows 7, and I don't like the look of Windows 8 even though I have only read about it. I think that Jennifer's approach is reasonable. You've always got to take precautions but let's not be paranoid.

I think urtrivedi's solution is good.
I would suggest changing the user inputs by adding a drop-down list of delete options containing 1. by stu_id, 2. by blood group, 3. by Student name, 4. both Student name and blood group. Then build the sql statement according to the user's selection, as you will know whether to prompt for one, two or three criteria. (these may not be the exact options that you require, but I hope you get the idea.) You can use a switch statement to choose which code to execute.

You may wish to decrement the number of attempts at some stage.
If you want to decrement it when you have received a valid input then you will need to make the if condition body a multi-statement one. (Your current condition does not enclose the statement in braces so therefore only one statement can be executed if the condition is true.)

if (posInt>0)

Of course, you might want to decrement numAttempts at a different stage.

The age calculator is not quite right because it does not calculate the months correctly.
If the current month is less than the birth month then the years are shown as one too many. The months are calculated as 12 minus the birth months, which is incorrect in most instances.
The calculation should be
If (current month minus birth month) > 0 then
years = current year minus birth year
months = current month minus birth month
years = (current year minus birth year) - 1
months = 12 - (birth month minus current month)

If you are not phased by installing MySQL (and optionally PHP) on your own computer, you might like to consider creating a mirror image of the database so that you can manage your own user's in MySQL and set the permissions as required. You can then (hopefully) create scripts from your web-based database to re-create it on your own computer. It's a long slog to prove a point.
Secondly, I'm not quite sure about the restrictions your provider has set on the INSERT INTO permission. Is it only the SELECT INTO clause that is prohibited or is it just that you can't perform any scripted INSERT statements? If it's the latter, then how does data get into the table in the first place? Do you have to use a web form to do that?
Would you (for example) be able to create a script, from your original select statement, that would have one line for each INSERT statement that you need? By this I mean creating a script with a series of
INSERT INTO sci_genera (genus_name) VALUES ('genus_name1');
INSERT INTO sci_genera (genus_name) VALUES ('genus_name2');
INSERT INTO sci_genera (genus_name) VALUES ('genus_name3');
type statements.
Would you be allowed to do that?