6,934 Topics
 | |
| | Hi, i need to know how to convert ms access database to work on sql. Any help would be appreciated. Thank you  |
| | For the purpose of synchronizing data in sql server, such as: **1. Synchronize data between servers and client 2. When loss of internet, the client can still work based on the data required to run on the client. 3. When have the internet connection, data from workstations to be synchronized … |
 | Hello, I've built a timekeeping aplication from a fingerprint machine with automatic import to db and I'm getting some reports. One report is that I'm getting the employees time if they are late from work. But my table is small with 20.000 entries, but with the following query, the results … |
| | halo guys, I having problem executing the SQL statement in the visual studio but when in the MySQL it work fine. Here are my code. Dim sql As String = "SELECT * FROM (SELECT @row:= @row + 1 AS rowNum, std.* FROM Student std ,(SELECT @row:= 0) r) AS t … |
| | I really hope someone can help me with this one. It is a Hotel Booking System: Tbl Room (RoomID, Floor, Notes) Tbl BookingsRoom (RoomID, BookingID) Tbl Bookings (BookingsID, StartDate, EndDate, Comments) I have to create an SQL select statement for checking if a room is bookable during a given time …  |
| | I know there are multiple variations of this question here, but not in this form. My Ledger table, in a basic form have the following columns. TransactionID | DateOfEntrydate | TransactionDate | ClientID | TrIsDebit | OpeningBalance | Amount | ClosingBalance DateOfEntry is a colums which stores time of insert … |
| | Hi all, i have a table for instance, systemid | phonenumber 1 62222222 1 92222222 1 64444444 2 91111111 3 63333333 3 63333333 i want my select query output to be systemid | phonenumber | phonenumber2 | phonenumber3 1 62222222 92222222 64444444 2 91111111 3 63333333 63333333 I tried to … |
| | Hi, All, I have a data table that looks like this: USERNAME ICOUNT IAVERAGE DATE_LOGGED LAGX01 1245 1245 05-07-2012 LAGX02 2211 1422 05-07-2012 LAGX03 1698 1112 05-07-2012 LAGX04 4598 1555 05-07-2012 LAGX05 2589 3245 05-07-2012 LAGX06 3321 1155 05-07-2012 LAGX07 3698 3458 05-07-2012 LAGX08 2589 4587 05-07-2012 LAGX09 1598 1142 … |
| | In sql server , my query brings out more than one row of data SELECT * FROM TABLE 1 WHERE COLUMN LIKE 'PARAMETER' Now i am trying to make it in a dtagrid that the datagrid shows allpossible rows that is supposed to show .This is the code Dim objCommand … |
| | I have a problem trying to link my my datagrid view to my sql server stored procedure. The way it should work is that when I select an item in a list from my combo box it returns a set of rows on the datagrid view specific only to that … |
| | |
| | Hello Friends, i have created a page, here a sql query retrieve students name from database and put these values in drop down options. now i want, i select a value from drop down and send it ot another page. but it is not working. on my next page nothing …  |
| | Hi all! I am looking for some advice on how to best design C++ programs that read, write, and update data in MySQL databases. I have completed a system that successfully does this but I'm not sure if I designed it the right way to take advantage of OOP principles … |
 | HI Is it possible for vb6 to add the sql database as a back end for my program?and i would like it to add it during the deployment of my program as a prerequisite of it. Please let me know thank you  |
 | Here is a class to SQL use an access database: Class MyDB Public DBName As String Private con As New OleDbConnection(ConStr) Sub New(ByVal DBN) DBName = DBN End Sub Private Function ConStr() ConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DBName & ";" End Function Private Sub ConInit() If con.State <> ConnectionState.Open Then … |
| | Hi I populate a drop down menu like this: <select name="mySelect"> <?php $result= mysql_query('SELECT DISTINCT Year FROM MonthlySales'); ?> <?php while($row= mysql_fetch_assoc($result)) { ?> <option value="<?php echo htmlspecialchars($row['Year']);?>"> <?php echo htmlspecialchars($row['Year']); ?> </option> <?php } ?> </select> Then build a HTML table like this: <?php while( $row = mysql_fetch_row($results) ) … |
| | i have a table with day_date and price each record is displayed as below: Day_date Price Allotment 2012-05-20 500 2 2012-05-21 500 2 2012-05-22 500 2 2012-05-23 600 4 2012-05-24 600 4 2012-05-25 500 7 2012-05-26 500 7 2012-05-27 700 2 2012-05-28 700 2 what i want to do is … |
| | I currently have this login form in my python program with a submit button: <input type="text" class="input-small" placeholder="Email"> <input type="password" class="input-small" placeholder="Password"> and I have an sql database that has emails/logins/etc. How do I make it so the after pushing the submit button, the email/password is verified with the database … |
| | I don't have any proper experience with MySQL but need to make a query from python to a database that would return a list of vacant apartments. So, I know the number_of_beds, start_date and end_date and need to get a list of available apartments. The two MySQl tables that I … |
| | I need help with the format for single qoutes. I am using dynamic sql in an SSRS for error trapping records inserted with single qoutes during bulk imports but I cannot seem to format the actual select statement properly. SQL Sever 2005 Dev edition. Any help is great. Declare @DB …  |
| | Hi folks! I got a little problem with my assignment. The idea is to create online bookstore. As far didn't have much troubles with the project, until now. Problem occures when I'm trying to update/delete an entry to mySql. if you take a look at line 93 - there is …  |
| | Hi, I have a doubt in MS SQL, The below condition in the WHERE clause as you can see, "Where COTDetails NOT BETWEEN 32 AND 63 OR COTDetails is NULL", I want to the WHERE clause in such a way that the COTDetails is not between 32 and 63 and …  |
| | Hi! I have started learn about Query and PHP, and i don't know what to do next. I have made table with query help i can show in table records from my Database, so far i have well, but next what i want to do is every record in table … |
| | Hello, I'm new with Python and running into an error trying to print data I have retrieved from a database. The code works but there are characters being printed with it that are not displayed in the database...here is my current code: con = mysql.connect(host="silo.soic.indiana.edu", port=3306, user="XXXXXXX", passwd="XXXXXX", db="XXXXXXXXX") cursor …  |
| | I want to display text in Flash in a dynamic text field one by one (Fade In /Out). My database is Oracle SQL and I am using Flash CS5. I am given a task to create News and Events ticker. Being a designer I dont know much about flash action … |
| | Hello Friends, I m Developing an windows form application. i have a winform on which i have datagridview and i am saving the data to Sql Server database from datagridview directly . i m using the following code for connecting & saving data of datagridview to database using button click … |
| | So, I have this following snippet of code: if (isset($_POST['type1'])) { mysql_query("UPDATE table SET status = 1 WHERE id = '". $_GET['repid']."'", $c2) or die(mysql_error()); } if (isset($_POST['type2'])) { mysql_query("UPDATE table SET status = 1 WHERE id = '". $_GET['repid']."'", $c2) or die(mysql_error()); } if (isset($_POST['type3'])) { mysql_query("UPDATE table SET … |
| | Hi Guys, I am trying to retrieve all the users in the Active Directory and dump into a Sql Server Table(Sql2008). I was able to search one employee at a time but could not able to search all the employees in the Active Directory. Basically i want to retrieve 1.SamAccountname … |
| | Hi, I wonder what is the best way to prevent injection against user input. There are a lot of examples but one say "magic_quotes_gpc" is good but removed from PHP soon. Therefore, no point of using it. Another says "mysql_real_escape_string and addslashes" just used to clean iptuts. Etc etc. I … |
| | Hi Java Developers, I don't know if this is the right place to ask but I hope It is. First of all this is not my programming language, I am an intermediate .net developer, I just came up with this problem that I need to solve which what the thread … |
 | how do i create service accounts for the various SQL Server 2008 components? |
 | I have a checklistbox that I have been working on and I need to commit the changes made to those checkstates to a sql table, removing rows where the checkbox is not checked and adding rows where the checkbox is checked (assuming the checkstate actually changed). Instead of doing a … |
 | I need to transfer the sql server databse tables to mysql . How can i do that?.  |
| | *There is no any specific area to add this problem of mine. Thats why i add this in to windows server area.* **This is a SQL problem.** I want to combine 2 columns in to one column (2 columns are in 2 tables). There are a lot of codes in … |
 | I have a query in which I need to display some group function figures SUM COUNT etc from a joined table. I also need to select the latest version (by datetime) of a matching record from a separate table, which I can do using an ordered subquery in the join. … |
| | can any body help me by giving me a guideline on how to insert data from a populated datagrid into sql server table and how to make the values conform to the specified datatypes constructe in the sql server side...assuming the datagrid headings have already been created in the sql …  |
| | am total newbie to programming, apart from knowing SQL, the thing is i have been given a MYSQL database containing various information about kids diseases and a web interface written in php to create reports from the database that can be accessed via the interface. there are almost 25 different … |
| | Hi, I am getting the following error and I cannot understand why. SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM. Before i try and insert the data into the database I print it out and this is what i get: **09/04/2012 00:00:00** The code below is … |
| | Hello ppl... How to insert a list of lines to sql through php and create a id for each line example....i have flames flintones flames1 .... .... so on after submitting these lines i need a short id for these lines like (short id can be anything) 1232 1546 1578 … |
 | # EER for Rental store, to be put into Oracle for a database. # I have a databases project due monday. I'm still very new to databases so my understanding is minimal. I'm sorry if the answer to this is already on the web or somewhere on daniweb but I … |
| | Dear All, I am using VB.NET 2010 and SQL Sever CE 3.5 database. I insert some data into my database (SDF file) and I can do any all manipulations with those data. But I cannot see those data in the data table using Data Source or Server Explorer in Visual … |
| | This is my query SELECT DISTINCT brand, category FROM product WHERE subcategory = '$subcategory' My problem is that i want the distinct to work on both brand and category, but it is only working on brand. How could i fix this? |
| | so i've been working on a database in oracle for a booking system and I am trying to create dyanmic query results... was just wondering if there is a way to create a query to add up all the seats in a arena with booking numbers (not necessarily the same … |
| | #**Can anyone please tell what are the differences between Microsoft Access and traditional DBMSes (i.e. SQL Server, Oracle, Postgres, and MySQL) in reference to how they handle record-locking, rollbacks, and database updates? **# |
| | Hi, I need to create windows services that will back up MS SQL database. Parameter should be time period when I want to backup database (for example every hours, every 2 hours etc). I haven't any experience with backing up database. Once I made WCF service. How can I do … |
| | I am new to sql.i am little bit confused in the concept of group by. Please suggest me online sites.books for detailed knowledge of sql i have 2 tables 1)emp :empid empname empphone dept_id 2)dept :dept_id,dept_name select dept_id,count(*) from emp group by dept_id; its give the expected result. dept_id count(*) … |
| | Ok I need help. I have a couple hundred databases, which are different cities, that I am trying to connect with one query. each city has the same Sports table in it. I want to put the 100 most recent results on one page . The code below gets the … |
| | **Bold Text Here** i cant perform edit option in my sql/php page.....while editing it return 0 and it is not updating my database....in the database the same is seen (as 0)...donno hw to correct this...will anyone help to continue my work..... Thanks in advance.  |
| | hello all! I have this SQL code that I am supposed to write and am worried that my code may be wrong. I am fairly confident that the first 2 questions are correct but after that......who knows! I have attached an ER diagram( which is acutally really messed up...but whatever) …  |
| | I have a database with structure like users: usr_id usr_fname usr_lname usr_uname usr_pass organizarion: org_id org_name org_address org_tel org_web org_email org_cat org_desc departments: dpt_id dpt_name dpt_desc sections: sec_id sec_dpt_id sec_name sec_desc designations: dsg_id dsg_sec_id dsg_name dsg_desc employee: emp_id emp_fname emp_lname emp_phone emp_email emp_addr emp_join_dt emp_salary emp_card_no emp_dsg_id emp_sft_id shifts: sft_id … |
The End.