Im using the ado components to connect to an ms sql database. I know how to show the result of a query in db grid. But i want to store the results as string in an array for example. Is this possible or is there another way to use the query results? ...
I'm using PDO to insert a record (mysql and php) $stmt->bindParam(':field1', $field1, PDO::PARAM_STR); $stmt->bindParam(':field2', $field2, PDO::PARAM_STR); $stmt->execute(); Is there a way to know if it inserted successfully, for example if the record was not inserted because it was a duplicate? Edit: of course I can look at the dat...
Hello all, I have a function on my that has a delete button to erase comments. I have the button all linked up and ready to go. I just don't know what I should put on the 'delte.php' script I am creating, and what to tell it php wise to send to the db to make the status dead. as well as deleting the comment off of the page. Thanks ...
So I almost have my delete function working...I have the page loading correctly without any fatal errors but still not doing the trick Here is the portion of my while loop: echo "<a href='http://www.@#@$#%##%#.org/Profile.php?id=".$prof->id."'>"; echo " delete"; echo "</a>"; and here is the portion of my query which is obviousl...
We had huge performance problem when deploying our ASP.NET app at a customer, which had the DB sitting on a remote location. We found that it was due to the fact that pages made ridiculous amount of individual SQL queries to the DB. It was never a problem we noticed because usually, the web and DB are on the same local network (low late...
Hi, Currently we got a web service up and running that handles all our C.R.U.D calls to our database, and pretty much every interaction between user and the database. (starting with checking the database to see if there's an update for the particular version of the end users application, checking credentials, checking/reading various ot...
What are examples of column-oriented DBMSs? Is there any difference in querying (do both use SQL?)? Performance? Data modeling? When and why should I use one over the other? ...
I found out that facebook use whats called a big table. Is there a way that I can use this "Big table" database in an application that I am using? ...
SELECT u.user_id, u.first_name, u.last_name, i.path AS image_path FROM bgy_users u LEFT JOIN bgy_images i ON i.image_id = u.image_id WHERE u.commentary_id = '0' Error: Unknown column 'u.image_id' in 'on clause' When there definitely is a column image_id in table bgy_users What am I doing wrong? Result for DESCRIBE BGY_USERS Re...
Hi i want to retrive some data from sharepoint database . what i have to do. how can i make query on sharepoint database? ...
I have 2 table one table is City Table ( int id, string name) and my another table is Distance table(int id,int cityId (FK city),int neighbourId(FK city)),and i want to use hibernate but i cant establish relationships of these table to Hibernate. Thanks for everything... ...
On a VB.NET 2008 form I have a DataGridView, BindingSource and TableAdapter. The BindingSource DataSource is a dataset. In the dataset I have a Fill command that joins three tables and this is displayed without a problem in the DataGridView. However, I am unable to Update the dataGridView because it has multiple tables from a single T...
im testing web application(e-learning which having users, content items, reporting,assigning ...) which had a DB migration from SQL 2000 to 2005. If somebody knows what are the area i should focus on testing Please let me know. ...
I have a mysql query that targets a single column in a single row "SELECT some_col_name FROM table_name WHERE user=:user" After I execute the statement $stmt->execute(); how do I get this single cell directly placed into a variable with no loops? In other words how to get from $stmt->execute(); to $col_value = 100; I tried the 2...
Question Rewritten: HOMEDIR="ftpuser" REMOTEIP="1.1.1.1" MYSQLPASS="password" Q1="DROP USER "$HOMEDIR"_shop;" Q2="DROP DATABASE "$HOMEDIR"_shop;" Q3="CREATE DATABASE IF NOT EXISTS "$HOMEDIR"_shop;" Q4="GRANT ALL ON "$HOMEDIR"_shop TO '"$HOMEDIR"_shop'@'localhost' IDENTIFIED BY '$MYSQLPASS';" Q5="GRANT ALL ON "$HOMEDIR"_shop TO '"$HOMED...
Following is the scenario and some proposed solutions. Are there any better solutions? There is a system A which has to "analyse" lots of URLs. Another system B generates these URLs - currently there are about 10 million of them in a database. Sample schema: id URL has_extracted 1 abc.com 0 2 bit.ly 1 My solutions are as follows: N...
I am logged into mysql... mysql -u root -pmypass And I have run the following command to remove the database user which worked succesfully mysql> FLUSH PRIVILEGES; DROP USER 'myuser_shop'; I can then add user successfully using the following command, again this works successfully mysql> FLUSH PRIVILEGES; CREATE USER 'myuser_shop' ...
Is it when you're trying to get data and there is no apparent easy way of doing it? When you find something should be a table on it's own? What are the laws? ...
The site, http://sqlite.phxsoftware.com/, talks about a mixed-mode assembly and a managed-only version of the provider. Are they both named System.Data.SQLite.dll? I installed the managed-only version in windows and it is working. Which, as I understand it, means that I must also have the native sqlite3.dll file somewhere on my machin...
Hi all, I have a database of events, and I need to be able to show an event occuring 'today'. The events have start and end dates in the format: Y-m-d h:i:s How would I do this? I've tried queries along the lines of: SELECT * FROM tbl_events WHERE start>='2009-11-03 16:00:00' and end<='2009-11-03 16:00:00' To no avail. Any advice...