hericles

You can either store the image itself in the database (probably simpler code wise) or save the image to a directory and save the uri to the image in the database (this involves more code because you have to actually save the image but more efficient on your database).

Your include a parameter called mr_approved_date but in your SQL you refer to auth_date. This probably has something to do with it

You will want to look at the httpwebrequest class and its methods. You can feed it a URL and get back the source (page) to do with as you will. The MSDN articles that come up of you google httpwebrequest will help you.

Are you referring to the background image? You can place each as the background image in a separate div with the same width and set overflow: hidden. Then use some CSS to nudge the two divs tight against each other without padding and it should look seamless.

Do you need all of the columns out of the database or could you just select only the ones you need? Most of the time SELECT * isn't really needed. If not, you can bind various columns of your gridview to the columns of the data source in code. This …

Maybe I'm not fully understanding the question but a list of all of the cities ordered by country could be done like this: [code] SELECT Country, City, Populations FROM Countries INNER JOIN Cities ON Countries.Short_code = Cities.Country_Short_Code ORDER BY Country, City [/code] Assuming short_code and countries_short_code are the same thing …

Well, it is a paid service hence the license key. You could always purchase the software...

Well you could make subclasses wood, gold, stone and food of the super class Resource. essentially they would be basic classes and use the implementation of the Resources class for most things, unless something specific arises. But then you would have easily identifiable classes in code that follow similar rules.

When you select your data from the database use a WHERE clause to specify only rows that have a matching value in a particular column. SELECT * FROM table1 WHERE brand = 'Nokia';

You can't use a WHERE clause with an INSERT statement. You are inserting a new row so matching on a WHERE clause makes no sense. As a blog can have many comments searching in the comments table by blog_id isn't a good idea anyway (except for SELECT of course but …

Just curious, but is that all the checkbox does? Normally a checkbox is used to record the fact that some option has been chosen, not initiate another action. If you wanted to move the user to another window a button or link would do the same thing and actually inform …

By using float you are removing the sub div from being "inside" your wrapper. You can consider it to be "floating" on top. Because it has lifted out in this way the wrapper can't wrap itself around the div. Try replacing the float command with display:inline-block for the 2 divs …

You shouldn't need to match the your home user name and password to the office one as it is the particular database you are trying to access and that has no record of the sql server login details. But if you have changed them to match that shouldn't cause a …

It is called inheritance. Your class is being declared as a subclass of the inherited class. It follows a 'is a' relationship e.g. a car could inherit from the vehicle class with [code] public class Car : Vehicle [/code] The main advantage of this is that the Car class gains …

Total number of rows in the database or in one particular table? The rows in a table can be returned with SELECT COUNT(*) FROM table_name. Once you have loaded a file in a stream you can use the .readLine() function to move through the file. Then just split the string …

If you want to go the IE 6/7 stylesheet way add this code to your page headers: [code] <!--[if lte IE 7]> // add your link that points to the IE6 style sheet <![endif]--> [/code] This means if less than or equal to IE 7 then do this. These comments …

I've never had my actual grades examined by an employer (it may be different in the states), the fact that I can show them a degree has been enough. You can always make yourself stand out from the crowd by doing your own projects and showing them to potential employers …

Are you getting a syntax error? I think it is because you aren't using the WHERE clause correctly. You need to have: [code] WHERE Laminate = '" & ComboBox2.Text & "'" & "AND WHERE <another column> = " & "'" ComboBox3.Text & "'" [/code] By missing that second column you …

If you hit the button again does is the value TEST0005 entered (i.e. it always increment by 2)? If it keeps repeating like that the code you use to increment the text box is probably getting called when the button is clicked. Do you have it in the page_load function …

Where abouts in your code does the crash occur? If you can narrow down what code is running when it happens that will help.

I think it could be the position:static that is over riding your z-index element. W3C schools states that the position must be relative, absolute or fixed for z-index to work. I'm not sure how accurate that is as I've had issues with z-index not working but you might want to …

Is the email you are sending from a valid address for that domain? If not then gmail is probably not sending using that address as it doesn't comply with the security credentials you supplied.

There is litJson but I haven't personally tried it. I think it is from .Net frame work 3.5 so its not too old. And there is the JavaScriptSerializer class introduced in 3.5 which is apparently OK (again, I haven't used it myself).

Access has a limit of 16 JOINs and that error appears when you have exceeded that limit. You'll need to find a way to reduce the number before it will work.

You refer to a.button in your CSS when the id is called button. You would access that is the CSS with #button.

Is the number being allocated by the database? If yes then you can use transactions to lock the rows in the table being used until each user is finished with it. Transaction allow only one user at a time to access the information to prevent dirty reads and the like, …

Do you want them to send an actual email (i.e. the message appears in their email account) or send a message to the user the next time they access your app (message sent and held by your software)?

Either use <span></span> to hold your date (removing the <div>) or change the divs to use display: inline-block. Either one will make the two display side by side. Divs are block elements by default which means they don't lie side by side unless you style them to do so.

There are several ways you can do this. Lightbox or one of its derivatives will work for you. Or if you want something a little quicker (and hackish) you can create your lockout div and position it off screen using CSS. Alter its CSS style to place it on screen …

Basically, the position of the sub menus is placed off screen (-999em which is far to the left) and when the top level <li> are hovered over the child <ul> has its margin reset to auto which makes it appear under the menu item. Taking the mouse off the <li> …

Go to the control panel and select users accounts and pick the account you want to change (if there is more than one) and you'll see the option to remove the password. To disable programs from startup click run in the Start menu and type in msconfig and hit enter.Select …

You haven't highlighted which line is causing the error but it will be one of your assignment lines - where you are setting something with the = symbol. It normally happens because the object you are trying to assign is null soI'm guessing it is either: [code] OracleDataAdapter xx = …

That error means your website could not connect to the database. Either your config connection string is giving the correct details or the database hasn't been created at that location yet. Which of the connection strings are you using and is the database stored on goDaddy or is it remote?

You will need another table in your database that stores the user ID and the time/date they logged in. You can then use that as a filter to extract users that accessed the system at certain times. A select statement joining your login times with the users table when do …

Unfiltered text input placed directly into an SQL statement in production code... It hurts my eyes.

Hey, Is your javascript trying to run before the js file has downloaded? You can compress your js and css files by removing all spaces and line feeds. This doesn't really save too much space if you are also downloading images of course. If you need the page to load …

In your HTML you define a new CSS class by using the class="name" element. For example: [code] <div class="div1" ></div> [/code] Then your CSS is like this: [code] .div1 { // your style rules. } [/code] Thats the basic answer. Is that what you need?

The issue with changing the style and being redirected to the home page is that the links do exactly that - redirect the user to the homepage of the selected style. You would need to add some javascript functionality so the current page is taken into consideration and then a …

Are you talking about checking in the database (you have access to it) or scraping an HTML page to see what is on it? If scraping, you need to use the WebRequest class to retrieve the contents of a webpage and then parse through it looking for what you need. …

Add this to your CSS file: [code] table { margin-bottom: 10px // or whatever spacing works for you } [/code]

The SQL standard connection string looks like this: Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; What you have there looks more like a MySQL database connection string.

If it is a long running procedure you can increase the timeout of your connection object.

For others that come along, I'm pretty sure the error was that bg was being declared as UIImageView in the property but as UIImage in the interface declaration.

I'm not too familiar with joomla but if you view the page source and copy it you should (theoretically) end up with the structure of the page as standard HTML. Then you just need to link the CSS. I don't actually know if this will work but it would only …

size isn't a CSS property or is font either. You would ned to use font-family and font-size in your CSS file for these to work. Why the mix of inline and external styles? Everything can easily be put in your CSS file.

Pagination can be applied to a repeater control. That'll give you the advantage of repeater control styling which would probably be a plus too. There is a bit more code to type but I think it would be worth it for what you want. I have coded up pagination for …

Is the rowDataBound event getting called at all? It looks right to me. Or is it some code inside the event that isn't working as it should?

Are you including variables in your string? Syntax errors are easy to get if you don't watch your spaces and accidentally concatenate some text together. Of course, you haven't posted up your SQL query so we can't give you very accurate advice.

You will want to check out how to use the stream reader class to open a file (stream) and read the data. The MSDN article can be found here: [url]http://msdn.microsoft.com/en-us/library/system.io.streamreader.aspx[/url]

What you can do is execute another LIKE statement against the database based on the characters entered in the text box and populate the list with the result. Then you only have the relevant LIKE items remaining. Items that don't meet the criteria are removed.