Posts by hericles

Yep, has that solved the problem? If you call that after retrieving and loading your values?

MS SQL has two data types, geometry and geography, which are designed for holding that type of data. Define your columns using them. And read the docs, there's a lot more to it than just that.

Is the server set to Windows only authentication? If yes, logins with SQL server credentials will always fail. You'll need to set it to use mixed mode from the security tab. That particular issue I learnt the hard way.

call the addition code after your code that retrieves the record values. At that point the textboxes will have their amounts displayed in them so you can safely call the addition function. That would mean taking it out of the _TextChanged function and having the _TextChanged function calling it as well.

Um, do you mean you want up/down buttons and textbox, and clicking on the up/down buttons makes the time increase/decrease? I don't quite understand but I'll proceed on the assumption that I'm right.

You just need to add code to the two buttons so that a click reads the current time from the textbox, adds or subtracts a minute (or second, or hour, whatever you decide) from the time and then puts it back in the textbox.
The DateTime functions make the actual maths trival.

Have you got any code to show us what you've done already?

There is clearly some HTML code that you're stripping the HTML tags off that is gettings left behind. The last part of the random looking string is
"textdecorationnone" which equals "text-decoration:none" I'm presuming which is, of course, CSS.
So have a look at the actual source of your HTML and see what else you need to consider.

What you need is going to vary a lot depending on the host and how they implement their control panel. They may not even have a control panel and everything could be done via SSH or similar.
The best place to start would the free host itself. Do they have docs, examples, help support that can assist you?

What exact library did you use that could only do the date? that isn't a limitation of AJAX itself. And you don't want to even be using AJAX for that as there is no need to post back to the page.
All you want to do is add a '-' to the text in the textbox, which is a manipulation of the DOM. Jquery will do that easily for you. Again, Google is your friend so simple things like that.
If you have any issues post up what you've done and we'll help you. But we won't do everything for you.

The technology behind that functionality is AJAX. You will be able to find plenty of tutorials online if you search for AJAX and autocomplete

The clue is in the error message. Unknown column 'chem1115' indicates that your sql statement is wrong. You have data where a column name should be.

And here is why:
...SET total_mark=$total_mark ...

PHP is interpreting total_mark as $total_mark because it thinks you have simply made a typo. If you checked your error logs you'd see the line where the PHP engine is recording that it made that assumption. And therefore you sql statement reads as "chem1115 = chem1115". Simply change your variable name from $total_mark to something that isn't so closely related to a column name.

You have only added 10 elements to the array dblMarks but you are stepping up to 11 in your loop. No position 11 exists in the array.

If you're using iOS (developing for iPhone or iPad) you should use SQLite as the database, other MySql is fine.
When I started with iOS I found the native way of using SQL statements with sqlite tricky to get to get to grips with, despite using PHP and C# to interact with MySQL frequently.
My suggestion is not to bother with direct SQL statements (unless you really want to) and instead learn Core Data. It is also a fairly steep learning curve if you're starting from scratch but is the correct way to do things now.

rel="nofollow" is a tag that can be added to links to prevent web crawlers (spiders) from following a link and indexing that page. There is no dofollow tag, to get a spider to follow a link simply don't include nofollow.
Nofollow prevents pagerank being passed to the link from your page, plus a few other things all relating to search engines algorithms.

Have you attempted any of this or do you just expect someone else to do it for you? I don't mean to be harsh but if you're not prepared to have a go yourself you're going to improve much.
From what I've seen on this site people are all too willing to help you tweak and improve your code/design but you won't find too many people who will just do it for you.

I have a fairly big library and I still like reading paper books but I have found recently that the ease of availability of e-books, and how many you can carry at once, is just too convenient. I like paper books for fiction, e-books for reference and learning.

I'm confused, your code doesn't match your description. You aren't searching by ID, you're using select all without a where filter so its returning everything. And then your placing the first result of the first two returned rows into txtID and txtFullName. SO when you click the button you should see 1 and 2 displayed. Am I missing something?
You also appear to be opening your connection on form load and only closing it when the button is clicked. You want your connections to be open for as short a as time as possible, instead of leaving it open waiting for you to use it.

And what is the error message? I don't see it in your post...

Look into replication. It allows you to set up a primary and secondary server, the secondary receiving changes from the primary. With two servers set up this way you would need to manually switch the secondary to the primary role. To have it happen automatically you need a third server (called the witness) which polls the other 2 to ensure the primary is functioning.

You're referring to the main menu at the top of page, under your banner image I presume? it doesn't show correctly in Chrome either.
The problem isn't with the spry menu itself, it is simply too long for area allocated to it and so it is wrapping. I'd combine two menu items, news and events for example so the menu isn't as wide.
Or widen your content area...

You can create a view in storyboard or interface builder that has the common subset of elements and then, once your view is loaded via the load nib method, add whatever other controls you need dynamically in code. If the views aren't too complex this should be OK.
If they are complex, or will be complex to do via code, defining a view for each complete form is completely acceptable.

You will need to store the ten label values, may as well be in an array, sort it and either only access the first 8 or remove the last 2. Can you post up what code you've done then someone can edit it with advice on how to achieve what you need.

What exactly is going wrong? Can you not pass the order id to the stored procedure or is the stored procedure failing? Your screen shots indicate that selecting an order ID returns the order details...

Do you need our help with anything? You haven't asked a question or indicated you're having a problem...

you should have the scrollview size set as less than the content size i.e. the currently viewable area and the content size set to the full area the scrollview should hold. It sounds like you have that right.
UserInteractionEnabled is on for the scrollview right?
One other issue is that if your subview fills the available area of the scrollview, subview is detecting the swipe action not the scrollview. You can test that by shrinking the width of the subview to give yourself a margin that should respond to the scrollview.

All you have done here in create a new instance of Form1 and then closed that. There is no connection between the Form1 you have open and the new Form1 you created.
You need to pass the reference to Form1 to Form2 when Form2 is created (or at some later point). You can use a property in Form2 to do this.
For example, if both are opened from button clicks in a parent form when the button to create Form2 is clicked the code passes in Form1 to Form2's constructor.
Once you have that reference in Form2 you can call methods on Form1.

Sounds like somebody's homework assignment...

You can use as many as you like to get the job done.

Have you tried using position:fixed in your CSS? That will keep the menu in position relative to the browser window i.e. it won't scroll with the page

Welll, with knowing the book its hard to give advice. But, in general, are you applying for a particular job? If so, then you maybe able to get a general idea of the tasks involved e.g. is it a job using MVC or a particular database? Otherwise, its a hit and miss scenario, you could pick any one of a range of valuable topics only to find you should have studied something else.
But, pick something you know little about and improve it

Hi,
If I understand your question the combo box will have the id in it (or maybe the user's name only) so you will get the selected item of the combo box and then use that value in the sql query. You can't use parameters for column names (unless I'm out of date, hope i'm not) so you need to build a query string that included the column as text.

Say for example your combo box has the selected value '001' and that is the name of the column in your table you would then do something like this:
string sql = "SELECT " + id + " FROM table WHERE... etc";

If you have something else as the combo values that relates to a user ID in a table then you'll have to do a another query before this one to extract the correct user id.
Note that as you aren't using parameters you will need to be careful about SQL injection. In other words, your column name variable that you add to the query must never be something enterd by the user as text.

Is that what you're after?

What result are you getting from it as it is now?
I would use isEqualToString to compare two strings:

if( [trim isEqualtToString: [chtable subStringWithRange: NSMakeRange (scan, 1)]]) {

This is a bit late and you haven't posted any code but are you committing the animation after the movement has finished (via the commitAnimations method)? If not, the ship is moving with the animation command but it's actual location isn't changing so it is being redrawn in the intial location when your view is redrawn.

Are you asking for help with CSS styling and how to make the form look like that? If yes, place your form in a div (or more than one if that works better) and either use standard CSS properties or load up a background image. Is that the kind of thing you're trying to do?

[NSString stringWithContentsOfFile: encoding: error] will read your csv file.
Once you have your file into a NSString you can use componentsSeparatedByString: to split it as you need. For example, to split it into an array based on line feeds:

NSArray *lines = [csvString componentsSeparatedByString:@"\r\n"];

Hope that helps.

Are you sure your first if statement is not the problem? Is the text displaying "Failed to add clinic"? If it isn't then your sqlite3_prepare_v2 statement is the problem and you'll need to find out what status code is being returned

What excatly do you mean by "displaying datagridview to another datagridview"?
Are you trying to extract the data from the server for use in a datagridview or are you past that and trying to do something with displaying it on screen?

And what is the format of parts[]? Without that we don't even know which code branch is being hit.

First thing to do is debug your code and make sure there are values to insert into the combo box after the selection statement has run e.g. check the reader isn't empty.

OK, from what I can make out in a few minutes reading is that the APIs are http based web calls. The base URI is https://api.bookshare.org/ and you add onto the required parameters to call a particular method.
For example the docs state the ISBN search looks like this:

/book/isbn/:isbn/format/:format

The parameter specified by the : character is the actual search term so an example web request to get the ISBN 12345 in xml format would look like this:
https://api.bookshare.org/book/isbn/12345/format/xml

You would use a standard C# or VB.Net HTTPWebRequest to call the URI and a HTTPWebResponse to hold the returned data. Of course some method calls require the API key to also be sent, the written docs explained that so I don't need to copy it here.

Are you accessing an APIs that already exist or creating an API for your software?
Most APIs come with some form of documentation to get you started so that is obviously the best place to start.
Before we can really help you, do you know what access method the APIs use?

If you only have the two options that the text can be a simple if statement inside the button click function is the easiest option.
Check if the current text is "Connect" and if so change the text property to "Disconnect" and vice versa.

if(connect.text == "Connect") {
    connect.text = "Disconnect";
} else {
    connect.text = "Connect";
}

Is it due to the overlapping selection lengths? You have 0 to 7 and 0 to 4 which obviously both include 0-4.

Are you asking how to send an email, store the info sent in a database or how to handle the confirmation part of the registration (or all of the above)?
If you looked at each part individually on Google you would find the answers you need.

Each combo box will have a selectedIndexChanged event which you can use to catch the selected option and then respond appropriately, in your case populating the second combobox based on the selection in the first. Does that make sense?

This link should help you out:
http://stackoverflow.com/questions/1938730/virtual-directory-not-being-configured-as-an-application-in-iis

The error tells you what is wrong - the directory isn't configured correctly for IIS. Read the link or seearch the error in goolge and you'll find tutorials on how to make the directory an application.

Is the user ID in the table different from the ID you store in the session (their email by the look of it).
As Mikey mentioned, if you are getting an error posting that up will help.

All you need todo is stop the timer when thee task is complete and then perform an INSERT operation (or maybe an UPDATE if each user just keeps the one time e.g. a time to beat) to push the user and time into the database table.
Is there a particular part of this you are having trouble with?

Joins are intensive work for the datatbase to do and each subsequent join in the same query just makes it worse. If the search is a repeated one you could consider creating a view of that data and extracting that instead.
Otherwise look for hints online for optimising both the database and the query.

Unfortunately if you aren't sure if you should be using classes then this project is beyond your current skill set (sorry, but its true). Is this project an assignment for your study or an actual production piece of software? Either way I would suggest getting some .Net coding books out of the library. I find learning from a software textbook better than forums and online tutorials when you're starting from square one.

If you are referring to how the logo looks then you need to think about your audience and their possible cultural norms and background.
So things like color can invoke certain moods or signify things and events. E.g. the colour yellow in most western countries means happiness or cowardice but in Japn it means courage, mexico mourning and India commerce.
If the logo is going to include slang or unusual words check what they mean in different languages - there have been some spectacular mistakes