pritaeas

Not in the UK, but watched Taxi in The Netherlands a looooooong time ago. Hill Street Blues comes to mind... (although not a sitcom)

http://www.microsoftvirtualacademy.com https://channel9.msdn.com

Can you give an example of what you are trying to achieve?

Missing comma between regtime and odds.

Why are you not using `BETWEEN` in the export query as in the first query? That is the issue you have.

A downvote with an upvote will register as zero on the posts page, so won't be visible.

This forum is not a problem solving service. If you have problems coding this, post what you have, clearly explain your issue and you will get help.

This might work: Select ID, TrDate, Description, Debit, Credit, Balance, Details From Bank_Acct Where TrDate Between '2009-07-01' and '2010-06-30' Union select * from (Select Top 1 ID, TrDate, 'Opening Balance' as Description, 0 as Debit, 0 as Credit, Balance, '' as Details From Bank_Acct Where TrDate<'2009-07-01' Order By TrDate Desc, …

If you split your query into four parts using `UNION ALL`, then the order is at your leisure: SELECT 1 AS Idx, ICAO_Ident AS ID, Location_Identifier AS LocID, Official_Facility_Name AS Name, Landing_Facility_Type AS AptType, Associated_State_Post_Office_Code AS State, Associated_City_Name AS City FROM APT WHERE `Location_Identifier` LIKE '%$fix%' UNION ALL SELECT 2 …

INNER JOIN forums ON forums.id = forums.parent This is a self-join without a relation to either topics or members. Without knowing more it's ringing alarm bells. Perhaps: INNER JOIN forums ON forums.id = topics.parent Besides that, I'm not too sure about the parenthesis. They have no function, but may trigger …

Perhaps [Restler](https://github.com/Luracast/Restler)

SELECT * FROM MyTable MT1 WHERE Username IN ( SELECT BookedUser FROM MyTable MT2 WHERE MT2.BookedUser = MT1.Username AND MT2.Status IN ('Offered', 'Scheduled', 'Paid') ) Something like that?

http://php.net/manual/en/mysqli-stmt.bind-param.php https://www.daniweb.com/programming/web-development/code/462098/mysqli-binding-example

Is `conn` perhaps a global variable? When you are trying to access the same variable over multiple threads, such errors are bound to happen. It would be more straightforward for every thread to have it's own connection.

Why don't you give an example with some data? Are you perhaps looking for the DISTINCT keyword?

Something like this: WebRequest request = WebRequest.Create("ftp://example.com/folder"); request.Method = WebRequestMethods.Ftp.MakeDirectory; request.Credentials = new NetworkCredential("username", "password"); using (FtpWebResponse response = (FtpWebResponse) request.GetResponse()) { Console.WriteLine(response.StatusCode); } This assumes that you have the right permissions to create a folder. For your request you'll need the above code nested for each folder you want …

So, what exactly do you need help with? Share your code so far, add specific questions.

It depends on what you have. In some cases, redirecting to a different page after the form post can prevent the issue, because they would be refreshing the page to which they were redirected. But if you go back with the browser, then that can be circumvented as well. In …

MySQL server is the database part that stores the information and lets you retrieve it. The MySQL client library is the interface between your program and the server, making it easy for you to communicate with the MySQL server. WAMP/LAMP installations come with both, a MySQL server version and the …

Page_content is a string that is outputted to the browser. It will not interpret any code. If you really want that to happen, you can use `eval()`, but be very careful with it.

You can call $('#datatables').dataTable({...}); only once.

Show your code and explain where it fails.

Can you elaborate a bit? Adding code means changing the solution/project and rebuilding/deploying. Is that really what you want? My guess is you have a problem where you need a more generic solution that that.

[DISABLE TRIGGER](https://msdn.microsoft.com/en-us/library/ms189748.aspx) is probably what you are looking for.

Sorry to say, I still cannot access the administration queue and Dani is very busy so I'm afraid nothing will happen at this time.

Did you include the typeahead.js script in your page?

The error message indicates that the SelectedIndex is higher than the number of items in the listbox.

md = New SqlCommand("INSERT INTO Stock ([Stock description], [Quantity], [Barcode]) VALUES (SELECT TOP 1 [Item description] FROM Items WHERE Barcode = '" & Item & "', '" & Quantity & "', '" & Item & "')", con) This might work, but you need to make sure there can only be …

In what programming language do you need your lambda? In .NET languages Contains() is an option, assuming you create an array for your ID's.

https://dev.mysql.com/doc/refman/5.5/en/keywords.html password is a reserved word, escape it with backticks. Next to that, are you sure $this->db is initialized correctly?

I can recommend: - http://www.amazon.com/Code-Complete-Practical-Handbook-Construction/dp/0735619670 - http://www.amazon.com/Design-Patterns-Elements-Reusable-Object-Oriented/dp/0201633612 - http://www.amazon.com/Algorithms-Structures-Prentice-Hall-Automatic-Computation/dp/0130224189

I have seen that error pop up when you do not explicitly close your mysql connections when you're done.

Safe in what sense?

Am guessing it's this: $sql = "select $fieldname FROM {$this->db_name}.$tablen order by $order $by"; $sql = "select $fieldname from {$this->db_name}.$table"; You probably don't get an exception unless you explicitly turn it on in `getConnection`: $this->conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

https://msdn.microsoft.com/en-us/library/k9x6w0hc.aspx You can use a static constructor to initialize your fields. The only problem is that you have absolutely no control over when this happens. The only thing you can be sure of is that it will be called before any call. A property is a wrapper around your field. …

What do you have so far? What language are you using?

> If I launch the project, what problems will I face? Technically none yet. At some point in the future if you decide to upgrade to a newer PHP version, your code will stop working. http://php.net/manual/en/mysqlinfo.api.choosing.php

What do you have so far, and what exactly do you need help with?

> Please help me someone. Stop bumping your posts, and show a little patience.

Without any code it's hard to say, but shouldn't you be using dtpDate.Value?

If you do not include init.php in your navigation.php then the $db variable will not be initialized. Hence the error.

Read up on how an RTF file works, because it contains markup to indicate paragraphs etc. You cannot just append a file at the end, it has to be inserted in the right spot and without the start and end markup of that file (you only want it's text). The …

Instead of bashing what doesn't work, it would be better if you create a SqlFiddle with some data, so we can actually see what's going on and what you want to extract. `SELECT TOP 1 * `definitely works in SQL server, although your query might need some tweaking.

I'm wondering as to why you'd want to have Excel do the calculation. If you are creating a forms application, and also do the calculation in your form, you're no longer dependent on having to have Excel installed to calculate your results. As for importing/exporting from/to Excel, we use the …

V3.7?? The latest is 5.31. I suggest you download and try a more recent version.

I recommend using the 2015 community edition instead of express. If you select File -> New -> Web Site you get a range of options. Depending on the technology you want to use, take a pick.

[This](http://global.qlik.com/en/landing/go-sm/download-free-kit) was something demonstrated to me by a coworker last year. Have to say that it was pretty easy to work with, although importing your data is a bit more work.

He's not looking for PHP code, but for a Javascript event to trigger the PHP session destroy (I think). See [URL="http://stackoverflow.com/questions/1631959/browser-window-close-event"]this[/URL], it's an example with jQuery. In that event, you can use AJAX to call a PHP function to clear the session.