-
All Sites sql sql-server-2008 sql-server-2000 sql-server-2005 sql-server-2008-r2 sql-server-2008-express sql-server-2008r2-express sql-server-2005-express tsql sql-server sql-server-express sql-server-2011 ssrs ssrs-2008 stored-procedures reporting-services reportingservices-2005 reportingservices-2008 integration-services ssis mysql database-design database-schema relational-database database-connection
Error getting a INT out of a database
This is my function. In tblAlgemeen is a AlgemeenID. But it's a INT public function GetAllNews() { $conn = new mysqli("localhost","root","root","SquareNews"); $sql = "SELECT * FROM …
stackoverflow.com Local network speed appears to be being limited
I have a dedicated server setup that has just started causing us issues. Our immediate problem, is that last week, could log into an admin page of one of our websites just fine, now we can't. It does …
serverfault.com CakePHP X hasMany Y, find X that has Y.name = “value1” AND at the same time has Y.name = “value2”
So my model association is as follows: Person hasMany Award Person columns: id, name Award columns: id, person_id, name So people can have many awards, but I want to retrieve only those specific …
mcrypt/mysql syntax error on login page
I've got such code as an auth file for my CMS on login page: //$login=true; $iv_size = mcrypt_get_iv_size(MCRYPT_RIJNDAEL_256, MCRYPT_MODE_ECB); $iv = mcrypt_create_iv($iv_size, ...
Submitting Dates between Date Range - mySQL
In teaching myself php and mySQL a year or two ago, I created a movie database for the theater I work at, to help automate the more mundane web updates that need to be done weekly. So far this only …
get_long_lat_pt equivalent in mysql
Oracle provides get_long_lat_pt(lon,lat) to get a point in which can be used to analyse Geo spatial queries . For eg. SELECT * FROM places WHERE SDO_CONTAINS("place", get_long_lat_pt(11.551563, …
Selecting data from row above and below selected row in query…Possible?
How can I select all 'ITEM #' lines, concatinate with the line below and conditionally concatinate the line above if it has and "X" in it? Possible? I also want to be able to select say all items ...
Merge two tables, inheriting values from one to another
I have two tables that I would like to display as a single result, using UNION or other technique. The ID field relates both tables. The second table has one field missing, so that missing value ...
Moving MySQL datadir
I am trying to move the data directory of my MySQL database to a second disk array that I have as a mount point /array2/ The problem I am having is I have tried everything and after I modify the ...
askubuntu.com Error while creating a Membership user “The password-answer supplied is invalid”
I tried creating a new user using CreateUser method. but when I click create user button I get this weird error : "The password-answer supplied is invalid". I already tried putting a strong password …
Using SQL for a Realtime Multiplayer Game Server's Working Data (Fast Enough?)
The game I'm working on currently has a Client in Flash AS3, and a Server in C# (multithreaded). Currently I use mySQL to handle logins (Raw access: no middleman for accessing the database) which ...
gamedev.stackexchange.com How do you query an int column for any value?
How can you query a column for any value in that column? Sometimes I would query for actual value (like 1, 2...) so I can't not have a condition either. Is there a wild card? select int_col ...
Wrapping words in a SQL query string with regex
i have a database class that is written in PHP and it should take care of some things i don't want to care about. One of these features is handling the decryption of columns that are encoded with the …
How is it possible to have a good EXPLAIN and a slow query?
How is it possible to have a good plan in EXPLAIN like below and have a slow query. With few rows, using index, no filesort. The query is running in 9s. The main table has around 500k rows. When I …
Object reference not set to an instance of an object with no NULL fields present
I have the following code in my CMS 3.0 project SurveyController.cs private BuisnessSurveyEntities bsdb = new BuisnessSurveyEntities(); [HttpGet] public ViewResult BizSurveyCDF() { var bquery = …
Paginate SQL query
On a winform, in a datagrid, I am displaying about 100k rows, selected from the DB. Showing all these records take a lot of time. Is there a way to make the select query faster or maybe load the first …
PHP/MySQL Table with Hyperlinks
I have 2 PHP forms. One displays a list of events and the other displays the results of each specific event. On the page with the list of events I would like it so that a hyperlink can be created to …
SQL Server procedure returning no results
OK, so I have the following procedure in my SQL Server 2005 Database. I am trying to figure out why it is giving me no results. The user attempting to access it is an administrator, but I have also …
Best way to load content into application
I have a project where I need to write text from a database into an HTML5 canvas / Javascript application. To select this content, I've specified an attribute "reference" where I can ask the database …
Are there alternatives to Microsoft Access, like Hyperion?
Our office is using Microsoft Access to generate reports and to create front ends for updating/adding data to our SQL Server database. Put another way; We use Access for creating a Front End for end …
How to Stop SSMS 2012 from scripting SPs using sp_executesql
I realise this is a very similar question to this. However, they seem to have changed the behaviour with SSMS 2012. If you have the 'Check for existence' option selected, as in: ... it now ...
How can I get Openfire 3.7.1 to 'remember' its configuration?
I have (well, had up until this morning) an Openfire intranet XMPP server that had been running merrily along for 370 days without being touched, and a total of about 3 years of running. Users ...
Getting the count of 2 different columns in one statement
I'm trying to get a count from 2 tables working and I'm struggling! I've got a table with notebook items, a table with links to contacts, a table linking contacts to clients and a table linking ...
Reflecting sub records in PHP from MySQL
I am trying to get records from my DB using 2 seperate tables. The query is public function get_pages_by_campign_id($campaignID) { $campaignID = $this->real_escape_string($campaignID); …
Converting X y Coordinates to lat/long
I have a table that has X y coordinates in SQL Server2008.But the other table in the DB only stores the lat long. so I need to convert the X y coordinates and enter it in that another table. How to …
Round *UP* to the nearest 100 in SQL Server
Is it possible to easily round a figure up to the nearest 100 (or 1000, 500, 200 etc.) in SQL Server? So: 720 -> 800 790 -> 800 1401 -> 1500
Return value from OleDbCommand
sqlQuery = "SELECT [ID] from [users] WHERE CallerName=@CallerName"; OleDbConnection conn = new OleDbConnection(connectionString); conn.Open(); cmd = new OleDbCommand(sqlQuery, conn); cmd.CommandText …
Connecting to MySQL from Django
its my first project with django..i already tried the connection with sqlite.but now m using django's connection with mysql n m getting following error... D:\project\wogma>manage.py syncdb ...
update table inside for loop
I am trying to update a mysql table while inside a c# for loop and a if statement well a few if statements. While running with a break point it will run the executenonquery once but the next loop it …
DataList and stored procedures
My DataList isn't working. I inserted a table into its item template, and a label into each table cell. In the ascx file I associated each label with: <%# Eval("Field1") %>, <%# ...
Email Updates
Log in to receive emails of new questions in this filter. You can receive emails every 15 minutes, every 3 hours, or daily.These users asked the most up-voted questions on this page
