1,694 Topics
 | |
 | A report from Hold Security claims that one of the biggest ever online heists has been committed by a Russian crime gang. It would appear that the data theft includes, wait for it, no less than 1.2 billion (yes billion) username and passwords along with around half a billion email … |
| | Hey guys I really need some help if you can ASAP, my website is now done and this is the last thing that needs to be sorted.... I seriously need some help. I have added in 80 questions into the database. The website is a learning aid for users like … |
| | Hello guys I'm wondering how to update rows dynamically for instance: if cart contains one product then update its quantity and if cart contains more than one product update their quantities |
| | Hello guys I've coded cart class with cart items and showed cart items in a table but I had a problem when I try to update the cart.. It updates all the cart items when I'm changing quantity in one of the items **HTML** <div class="cartContainer"> <h1 class="shoppingBag">your shopping bag</h1> … |
 | I tried to create the database connection SQL Server 2008 R2 Express with ODBC connection using TCP / IP After I try the following error appears : Connection failed : SQLState : '01000 ' SQL Server Error : 10060 [ Microsoft ] [ ODBC SQLServer Driver ] [ TCP / … |
| | ** Hello i am newbiw to MYSQL .... iwant to create stored procedure in PHPMYADMIN . But when i am same procedue od MS SQL in MYSQL it is giving error . #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL …  |
 | I am developing a project on PHP and MySQL. My problem is "I am unable to show a uniqueID in a textbox like 'GHY00001, GHY00002, etc' auto-incremented everytime i load the page and insert it into the database". I already tried some php tutorials but didn't find usuable to my …  |
| | I'm implementing something similar to a shopping cart - a "my favorites" page for products. Users can click on an "add to favorites" link and add products to a favorites table from which they can view the details of those products at a later time. There's no purchase on the … |
| | HI can any one please help me how to convert timestamp to IST jtime = 2014-07-23 02:41:05 to Date H:i:s am/pm formate  |
| | I am currently working on an online website which houses a database inside that has 50-75 fields. I have what I believe may be a somewhat rudimentary question. Assuming we want to query the Database how would one go about making it so it builds a query statement using the … |
| | I am trying to insert some values into a database and I have the following SQL: insertString = "INSERT INTO SocialHistory (ExamID, Occupation, SafetyYN, ComputerYN, ComputerHrs) Values('" & CurrentExamID.ToString & "', (SELECT Occupation, SafetyYN, ComputerYN, ComputerHrs FROM SocialHistory WHERE ExamID = '" & LastExamID & "'))" When I execute the … |
 | Hi, I want to Count the number of occurences of data in a table, then multiply it in a value from other table, After that I want to sum up the product of count and the value from other table, As of now, I cant count and then multiple but … |
| | Hi, can someone explain to me why my code is returning wrong output. I want this code, First I have additional UPDATE query for a category 10, if it is not category 10 then it should ignore the update code. It is running correct if I input an item which … |
 | Hi Ive been using my sql server lately but for this past few days, its been crashing. I'm trying to find solution but seems nothing works or I'm just doing it wrong. Its sql server 2008 R2 Error details: Problem signature: Problem Event Name: BEX Application Name: Ssms.exe Application Version: …  |
| | Hi guys. I wanted to create a quiz for my website. I have found some code from a website called (getcode.org) (prev world of webcraft). The quiz now works as it should and I'm very happy it does. There is one problem I have adapited it to the needs of …  |
| | I am trying to insert records in a SQL table from Excel sheet with VBA code. Data contains of a range with all the rows to be inserted. I am using below code for the same. Insert INTO [odbc;Driver={SQL Server};Server=myserver;Database=mydb;Uid=abc;PWD=abc].DPR Select * FROM [TempRange] I am getting error as above. …  |
| | This should be an easy question. I just need to make so that when you click on some function in pgAdmin 3 and then click the SQL button on the top (the focus glass icon) the code form the selected function (showing in the sql pane) to automatically show in … |
| | i tried to mimic the code of a tutorial for a live updatable table....dat is connected to the MYSQL server .... i copied it and edited it a bit...but its not working... i was not able to understand the code so dont knw where the problem is here is the … |
| | Hi, Not sure what exactly is happening here as I'm used to dealing with Microsoft SQL server rather than Oracle but here goes: I have a C# project that connects to an Oracle database using the OracleCommand Object to bring back records but I've been noticing some strange behaviour. Here … |
| | Suppose I have a tow SQL tables: Fathers id | name ------------- 1 | Clinton 2 | Gates 3 | Bush 4 | Clinton Sons id | fatherid | name --------------------- 1 | 1 | bill 2 | 1 | suzy 3 | 2 | mera 4 | 2 | … |
| | Hi there, I just can't figure this out and I hope someone may be kind enough to help me. I am trying to paginate search results from a simple form. The script I am using works fine for the first page of results but resorts to displaying all the rows …  |
| | I NEED TO WRITE A CODE IN VB.NET , THAT LET ME EXPORT DATA FROM ACCESS DATABASE ( THE TABLE ATTACHED AS IMAGE ) AND IMPORT IT INTO SQL SERVER 2008 R2 . **NB : TAKING INTO CONSIDERATION DUPLICATION ** Example : if you see in the image the access …  |
| | Can somebody please explain exatly what surrogate, natural and candidate keys are and how they differentate from each other? Thankyou |
| | 1. What exactly is a surrogate primary key? 2. Is a surrogate primary key just a made up attribute inserted into a table by the database administrator? All I know is that you use a surrogate key when there is no primary key or the natural key may not be … |
| | I do not know what seems the problem in my code. I want to add the data to my database (using windows form) but whenever I refresh my database, no updates were observed. Thank you for your help. Here is my code: public void btnSave_Click(object sender, EventArgs e) { string … |
| | Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Stylus T10 1 1 Repair 1 2 Monitor 2 HP 1 2 Repair 3 3 ViewSonic 2 I need to count how many printers, Monitors etc. are …  |
| | I am trying to build a java program for user login but I am not sure if my MVC design is accurate. I have the following classes: LoginControl - servlet LoginBean - data holder java class with private variables getters and setters LoginDAO - concrete java class where I am …  |
| | i want to copy data from an access database to a sql database 2008 through coding in vb.net any help ? NB : I WANT ALSO TO CHECK FOR DUPLICATES EACH I SELECT FROM ACCESS TO COPY IN SQL |
| | hey, I need help with this code, I have made database and code for inserting data, now I need code that will display data for group, in database I have groupnaziv, and id, here is code for inserting which works great, after that I will post code that I need … |
| | I am trying to connect a Crystal report to my database.mdf i.e SQL Server database. When using the wizard At the [I]Database Expert[/I] window after choosing the [I]OLE DB (ADO) [/I]i can not find any server and a database in the drop down menu. how to get that? i have … |
The End.