Posts by hericles

Well, using HTML for a web page is a bit of a no brainer, the database you use isn't very important either as long as you understand the differences between them.
ASP.net to build your server code is fine, no better or worse than anything else if you have no restrictions on hardware platforms.
So, in short, can you build your project from what you have selected, yes.

Unless I'm mistaken it only accepts ints as the parameter values. Why do you need to pass it a float?

There are several ways you can use Paypal on your site, it all depends on whether you want to use their shopping cart and session management or your own and whether you want your users to be redirected to paypal or stay within your site (except for the final payment). Head over to the developer section at Paypal, sign up (if you haven't already) and check out the developer tools

How are you defining the footer area in your CSS? And the div that holds the contents - is the height fixed at a set height or auto?

They are using the same template for the page design but loading different data into the page sections.
The easiset way to do this is with static HTML of course of simply type the menu directly into the page code.
If you want to dynamically populate the data then your code behind connects to your data source and prepares the data before inserting it into the page.
BUt, to answer your question, no, the same template will suffice

But you are doing server side processing, thats the problem you are having. So you won't be triggering a round trip just to clear the form because you can just add that to whatever else you are doing server side. No extra trip required.

If you haven't got a file called ie.css in your website you can take it out without any problems. It looks like you have a problem with the footer part of the page in IE

What year are you in and what is your skill level? They will be limiting factors in what type of project would be acceptable for you to do.
Are there topics you should include that your instructor has mentioned?

I'm not to famliar with RavenDB but SQL express or MySQL are easy to install. There are plenty of online tutorials for using either one and the basics of SQL (table creation, inserting and retrieving) aren't hard to learn. The MySql dev site can help you with most queries.

Client side actions happen first because they occur in the browser and don't require the post back. Why don't you simply remove the part of the script that clears the form?

You need to make sure neither the selected start or end date of tenancy is the bookings table to ensure the apartment is free for that period. Assuming you have two inputs for the start and end dates this should work:

SELECT apartment_id FROM apartments AS a JOIN bookings AS b WHERE (startDate < b.booking_start_date AND endDate < b.booking_end_date) OR (startDate > booking_start_date AND endDate > b.booking_end_date)

I haven't tested this and it could be improved (it is basic in its business logic). For example, the startDate can be < (booking_start_date - 1) to ensure that it is available for at least 1 night.

It isn't very clear what you are trying to do. Can you explain in more detail?

I would have to assume the latter. Is the code sample above the output of a program or the actual page contents in the browser (viewing the source)?

It is pretty easy using HTML5. Check out the source code at this link:
http://html5demos.com/geo

Remember that it requires the user allowing access (which is a good thing).

If you want to do it in code this example shows how to use a PHP library supplied by ipinfodb.com to back trace an IP address and get the lat and long coordinates
http://developergeeks.com/article/44/how-to-get-geolocation-from-ip-address-in-asp-net

Part of any database connection string is the location of the database. If you are using an online or remote database you simply specify the IP address and port number instead of the server name. E.g.

Data Source=190.123.36.12:4333;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

If this is for HTML why aren't you using <br />?

This part is incorrect

ttam.class != ttam1.class!=ttpm.classpm!=ttpm1.classpm

You can't string them together like that. You need to separate them out as separate claues and use AND or OR to build up the logical expression.

ttam.class!=ttam1.class AND ttam1.class != ttpm.classpm AND ttpm.classpm != ttpm1.classpm

When you say it goes off the page do you mean you have to scroll to see it all? That just means you have more content than will fit on one page...

Is the content inside the container div taller than the screen is high?
If so then it will be too much for the container to handle and will overflow. Try setting the container div height to auto and see what happens.

Have you checked how the date is formatted in the table? MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM: SS' format so values such as 03/14/2012 may not exist in the table.

As you want it in non-alphabetical order rajeev's post won't help you.
Apparently MySQL has a command that allows you to pick the order of the column's data but I haven't tried it myself.

select * from tablename order by rank='Lcpl' DESC, rank='Pte' DESC, rank='Cpl" DESC;

That is because you are firing the code in the SelectedIndexChanged event of the first combo box and included the selectedIndex of the second combo box before it has been changed.

Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
        Dim r As DataRowView = ComboBox1.SelectedItem  // has been set (fired this code section)
        Dim rr As DataRowView = ComboBox2.SelectedItem // hasn't been set yet, is still default value
        If Not IsNothing(r) Then
            ComboBox3.DataSource = GetTable("select CRID , CRname From ClassRoom Where YearID = " &     r("YearID")&" AND DepID ="&rr(DepID))
        End If
    End Sub

You need to address the error in the logic there. You can either make the second combo populate when the first item is selected (forcing the user to select them in order) and then fire the code in the second combo boxes selectedIndexChanged event or include a button which uses the set values of the two combo boxes.
Trying to assume that both combo boxes have been selected is a mistake.

You might want to start with something like this:
http://www.htmlgoodies.com/beyond/css/article.php/3642151/CSS-Layouts-Without-Tables.htm

But if you google HTML layouts you'll find what you need (avoid anything that teaches you table based layout!)

There will be something wrong with the connection string for the connection object. Where and how are you specifying the connection object?

Do you know HTML and CSS? If you are provided with an image of how the page should look you need to create a template that mimics that look by using HTML and CSS to place the required elements in the correct places.
The first step would be to identify the block elements that make up the page - header with banner, where the navigation is, number of columns, etc - and place them correctly and then start adding the colors, images, text, etc.

TRUNCATE persons; will clear out the table and reset the auto_increment primary key to zero.

If there can be multiple images per employee the best way to do it is create another table to hold the images. It will have 2 columns, the employee ID and the URI to the image. Thus it can have many images listed against one employee. Instead of storing the images in the database, store them in a folder and the database table holds the file path to the image.

So, what trouble are you having exactly? Are you aware you have an H1 tag in your <head> element?

A MySQL connection string normally looks like:

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

But if it isn't allowing access then the password maybe incorrect. If the database or user didn't exist I think the message would be different.

Where is getNumber being called from? I imagine it would be part of the main method so the rest of the code has a number to work with but I can't see where you are calling it from.

How long are the credit card numbers you are using? In your getPrefix method you are dividing the credit card number by 100000000000000 (16 digits) so credit card numbers with 15 or less digits never pass your check of is p > 4.
The number I tested was 15 digits and p = 0.37144.

We won't be able to help you without seeing the relevant code.

If there are no errors and the code runs then there is something wrong with the SQL statement. Most likely cause is that the @ID you pass in isn't found and so nothing can be updated.
From what I've seen your code is OK so double check all values as you step through it and pay close attention to the SQl statement.

You have sor in quotes for a start. Is that a typo or part of your code because it, at the very least, should be:

url = sor + "resources/stdInfo/authenticate/" + tx.Text + "/" + passwordBox1.Password+ "/1/570322308ce1121cba1b93f5acc9ebd4733ef2bca90ef942a2cfa224f0aa08dc/1";

If you want to include StartingWorkDay in the where clause the SQL would be

SELECT * FROM Employees WHERE EmployeeId = '" + txtID.Text + "' AND StartingWorkDay = '" + txtStartingWorkDay.Text + "';"

you may have been missing the AND and using a comma?

SELECT * FROM table ORDER BY rank, name asc will order it first by rank (Cpl, Lcpland Pte) and then order by name within each rank. What code were you using to get a random result?

OK, any errors getting displayed? You may need to debug your code for the update function and step through it until you find the line that is causing the problem.

You are going to need a database of some kind. Cookies are only stored on the user's computer and so wouldn't be viewable by anyone else. The a click event would be processed, the color changed and the and the database updated with the new color.

You have two if statements that check if the query string is empty or null but not one that checks if it isn't. Therefore, if the query string["ID"] is set to some value nothing will happen.
Your first check needs to be

 if (Request.QueryString["id"] != null) 

Then the code that uses the id in the SQL statement will run.

I know that running locally, especially in debug, slows things down but 10 minutes for that amount of data is crazy. Is your database being used by a lot of other stuff (seems unikely) or is your CPU running at close to 100% for some reason?

You can alter it to this:

<p>
<span style="float: left;">March 08, 2012 Poseted by <a href="#" alt="Someone">Someone</a></span>
<span style="float: right;"><a href="#" alt="More">Read More</a> | <a href="#" alt="comment">Comments</a></span>
</p>

The float left and right send each part to their appropriate edge.

Are those two sections inside their own divs? if yes either use float: left; on the left one or display: inline-block; for them both.

If they aren't in their own divs can you post up the HTML so we can view it?

Well, it is. But arrays won't persist beyond the browser being shut down. An array would work during one particular session however so if that is what is required create a string array, array list or dataTable to hold the domain part of each URL and store each URL in there as it is visited.
Counting through the array to find the most popular isn't too difficult (efficiency will be important though, there are a variety of ways you could implement this) and then output the results in order of highest to lowest in the drop down.

Hi,
To increment the id_Student column all you needed to do was define the column as the primary key with auto increment. Assuming the id_Student is an integer data type the declaration would have been:

create table some_table(
id_Student int not null primary key auto_increment,
....)

Now whenever new data is inserted you don't include a value for the id_Student, mySQL will increment it automatically. You can alter the increment rate if the default of 1 isn't what you need.
As for searching and displaying data from a database you'd be better off looking for a tutorial online to show you how to do that. There are many to choose from.

First off the visited locations will need to be stored somewhere, which could mean a small database table or a file. All visited pages will need to be saved into that file with all of the relevant information you would need.
A regular expression can easily split out the domain part of the URL. Then it is just a matter of sorting the database table or file based on the number of occurrences for each URL.

You will need to use javascript functions to do this. You will need to create a javascript function and refer to it in the on click event of each table data item e.g.

<td id="table_1_R06C07" style="width:14%; height:17%; vertical-align:top; padding:1px 4px 1px 4px; border:1px solid #000000; " onclick="changeColor(table_1_R06C07);">

You will need to pass through the ID of the table cell so you know which one to alter (using the document.getElementById method of javascript). Thats enough of a start and it should have provided enough hints to google what you need:)

Yes, as long as the column for the ID isn't defined as the sole primary key for the table. Tables like table 2 above are sometimes called linking tables as they form the relationship between two other tables. For example, you could have another table called uses and in that table name and describe the various things software could be used for (design, web, video editing, etc) and then table 2 forms the link between uses and software and would simply hold 2 columns - software_id and uses_id. Table 2 then allows all of the information in the tables to be joined in searches.

From the code you have posted here you haven't declared a DataTable at all. You have simply decided to use one in this line

For Each row As DataRow In DataTable

But this isn't an instance of a DataTable, its a type. Before you can use the For Each you need to declare the DataTable and fill it with data.

No, you shouldn't hold two pieces of data in the same column. Having design and web in the same column matched against dreamweaver (for example) is incorrect.If you wanted to do this you would need at least 2 tables.

table 1: software
software_id
software_product
software_desc

table 2: software_uses
software_id
usage

So, in table 2 for dreamweaver you would have two rows (based on your example above and giving dreamweaver an id of 101).
software_uses
101 web
101 design

Now you can search for any software that matches a particular need and retrieve the name and description from table 1 using an SQL join.
Does that help?

Does it need to be a 'traditional' database? the noSQL movement is growing and would still be a novel project to do.