2,403 Solved Topics
Remove Filter  | |
| | Hi There, I am using a sql query to show a row to users. The Problem is in the database there are single as well as duplicate records. My 1st code is – Works good if user has no duplicate records; [CODE] SELECT contacts.forenames, contacts.surname, addresses.postcode, contacts.contact_number FROM contacts LEFT … |
| | hello guys i have a question bout my sql. I create a system in vb.net using my sql database but the problem when i create a report using microsoft report viewer it does not detect mysql database whether i create a new connection..what is the problem??.. |
| | HI, pls help me in this.. How to import Excel Sheet data into SQL Server 2008.? i use Excel 2010. SQL Server 2008. how to import data? thanks in advance. jack Databases client-server microsoft-office mysql sql |
| | Hi ok I have a table: "rlbTerms" that contains basically a list of terms and their definitions. I create a page with a query that returns all the terms and definitions in a table layout and are order by terms ASC. What I want is a way to create anchor … Databases mysql |
| | Hi There, I do have 2 tables; Contacts table, Communications table Contacts table rows are; contact_number, forename, surname Communications table rows are; contact_number, number (number is used for emails) What I have is a little form to check/find out the contact number by filling; surname forename and email. Once they … |
| | Hi All, I am working on a booking system for vacation rental properties. I have two (simplified) tables properties and propertyAvailability: properties:- propID propName propertyAvailability:- propID dayOfTheYear availabilityStatus Rather than use dates for the bookings I convert everything to dayOfTheYear (using ColdFusion) and each DOTY for each property has a … Databases coldfusion mysql sql |
| | Hi I am using the following query: [CODE]"SELECT * FROM members WHERE name LIKE '$searchKey%';"[/CODE] Where $searchKey is a variable that contains the string to be searched. The problem is that the code only searches until it has found a space and even if characters after space match the value, … Databases mysql |
| | I have a problem with updating records in a database table. Background: The user can fetch data that belongs with an image. The data is displayed in a form. In this form the user can add/change data and then save this to the database. This part works fine. My next … Databases mssql |
| | |
| | Hello i am designing a project which is intended to store the values entered in a browser into database. Finding some difficulties in displaying the database contents on browser. Below i am posting my entire code. The data i enter in browser are getting inserted into the database. I checked … Databases xml |
| | After close to 40 years of programming one might think that databases would be a well known subject, but it's not for me. In fact I have never had a need for a database until now. I have installed Joomla because I want to develop my websites faster and more … Databases mysql |
| | I was told on another forum that my table was not set up properly. Specifically, two of my columns, "keywords" and "catagory" should be in child tables. I just dont see that, or I dont understand why I would need to do this for these columns. here is my info … Databases mysql |
| | I have a string that I need to convert to int before updating it in my database, but haven't managed to figure out how it's done. Here's my latest try: [code=c] int iLager = Int32.Parse(TextBoxProdNumberOf.Text); SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE Produkter SET iLager ='" + … Databases mssql |
 | I have a 2 tables that I want to select in a weird way but I'm not sure how to join them, should I use inner join or join left or group by etc... [CODE]//my desired out come employee_id | training_name ---------------------------- 1 | training a | training b | … Databases mysql |
| | Hello, I am designing a database for my school library. 10% of the books in the database are French, and thus have words with accents like Château. My issue is that I'd like the user to search for book by typing Chateau (as it is too difficult to type in … Databases |
| | Hi There, I do have an sql query to update and insert row into database which I use it within a form. Problem is ; This sql query works good in one form but in other one it does not at all(same query different form), looks like it is blocked …  |
| | I have this code that works fine: [code=c] protected void ButtonImgTextToDB_Click(object sender, EventArgs e) { string ID = TextBoxStartPictID.Text; string Rubrik = TextBoxHeadLineStart.Text; string Text = TextBoxTextStart.Text; SqlConnection conn = new SqlConnection(config); conn.Open(); string sql = "UPDATE StartImage SET Headline ='" + Rubrik + "', Text ='" + Text + … Databases mssql |
| | Hi There I do have a form and a little sql query to update the row before do something else. Problem is in the code below works when I enter the date like that= 01-02-2001 but I need to do it dynamic I know getdate() but it does not work.. … Databases mysql |
| | Hi: I have a process allowing the admin to view users information and download files that the user uploaded to MySQL. When the admin clicks on the file link in the admin page, I expect the file will display using the default program (i.e. pdf or txt), or download (i.e. … |
| | Hi everyone, I have a database with X items, and each of them can have one or more of 20+ properties. How I currently make this work is I have a huge table with each of the properties having it's own column, and a boolean to determine does the property … Databases database-design mysql |
| | Hi All, I am using MySql and wrote all my create table scripts directly on the command line client. Now I have no tracks of them. I need all the table scripts present in my database region for future reference. I used the below command to view the script of … Databases mysql |
| | I've used the code below previously with success, but I'm having problems this time around, and hoped someone could point me in the right direction. I complete the form, click submit, and receive the message confirming data has been added. However, when I look at the database, there's nothing there. … Databases mysql |
| | why i am i getting this synyax error when trying to display data from the database the code for saving the data is [CODE]// save content to db if(isset($_POST["inpContent"])) { $sContent=stripslashes($_POST['inpContent']); // remove slashes (/) $sContent=ereg_replace("'","''",$sContent); // fix SQL $sql="UPDATE cms_core SET editorial='$sContent' WHERE id=$id"; $query = mysql_query($sql); }[/CODE] and … Databases mysql |
| | Hi..... There is a problem with the following mysql query create table emp2 (Leave decimal(12,2) default NULL) [B][U]Error message[/U][/B] Error Code: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Leave decimal(12,2) … Databases mysql |
| | Hi there, I do have a database and I am using sql command to insert data in it. Date field is set to datetime (03/01/1900 00:00:00) In the field either there is a date only or it is empty. What I want to do is: Insert current+2yrs date even the … Databases mysql |
| | Greetings, I have table CUSTOMER: [CODE] mysql> describe CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(35) | NO | | NULL | | | STREET | … |
| | hi, i have read around and all i seem to find is one and in the where clause along with an OR or either but i was wondering if it was fine to use 2 or maybe 3 AND in the where clause? most of my where clauses in past … Databases mysql |
| | Is it possible to get system utilization information in pl/sql? are there any routines to get them? Databases motherboards-cpu-ram oracle  |
| | I am trying to execute a script, it gives me the error SP2-0640: not connected I then select to connect, type in my username, password, service, and select SYSDBA as the connect. I then get the error ORA-12505: TNS:listener does not currently know of SID given in connect descriptor. I … Databases oracle |
| | Hello Experts, I have following tables: Table_1: C_ID Inst_No Paid_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 13/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010 [/COLOR] Table_2: C_ID Inst_No Today_Dt 201 2 12/06/2010 [COLOR="Green"]202 2 12/06/2010[/COLOR] 203 3 12/06/2010 [COLOR="Green"]202 3 16/06/2010[/COLOR] Now, from the above two tables I want to display only … |
| | Every once in a while I run into this problem and finally decided to consult the experts. :) I insert foreign characters (Czech letters) into my MySQL database and see them there. They look fine. But when I try to retrieve them using PHP they come out with question marks … |
| | I have the following table: [CODE] mysql> describe LEVEL1_CUSTOMER; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | CUSTOMER_NUM | char(3) | NO | PRI | NULL | | | CUSTOMER_NAME | char(50) | YES | | NULL | | | BALANCE | … Databases mysql |
| | I need help guys, I want to be able to extract text from a string. This is an example of the string: @ ANSI 6360100102DL00390204ZF02430034DLDAACRUZ,JULIO,MIGUELDAG626 SIESTA KEY BLVD APT 434DAIDEERFIELD BEACHDAJFLDAK33441-0000 DAQC620433894240DARE DASA DAT DBA20141124DBB19891124DBC1DBD20080801DBHN DAU511 ZFZFA ZFB ZFCR050808010243ZFD I wanna be able to extract "CRUZ", "JULIO", "626 SIESTA KEY … Databases mysql |
| | Hi There. Is it possible to use the LOAD DATA LOCAL INFILE command from a crontab or what will the best way be of importing a csv on a hourly basis. Regards Databases mysql |
| | hi, i have been trying to work out how to list all the users on the database for my website with a particular access level and also only the user id that the client is associated to however i end up with duplicated users. here is my query so far …  |
| | Not sure if many ppl here use navicat, but I am somewhat confused by the way data entries are handled through my page and how that interacts with my local db server and my remote db server. For example, at work I am sometimes working on cfm templates on my … Databases mysql |
| | This is the part which searches and add the result to the 'pass' variable. At one stage I was getting a resource id number and found to get around that, but when I do this I get nothing on the pass variable [code] $result = mysql_query("SELECT `Pass` FROM `wiki` WHERE … |
| | Can I get some assistance with the T SQL syntax required to use the contents of this combo box in a pass thru query in order to improve performance response time over the LAN [CODE] [Forms]![WELCOME]![FILTER_BUILDER].[Form]![Combo28] [/CODE] Apparently TSQL doesn't like the "!" from Access: [CODE] SELECT dbo_A_VIEW_LOWEST_LEVEL.contract, dbo_A_VIEW_LOWEST_LEVEL.[Profit Center … Databases microsoft-access |
| | Ok back again. lol I just purchased a new hosting provider and was trying to transfer my database over to my new site. I exported the tables using Navicat and "tab" as the delimiter. I have three tables and they all saved as text files and look fine when I … Databases mysql |
| | Hi I have 2 tables say A and B. Table A has EmpID, First Name and Last Name. Table has Award Recipient, Award Presenter ID(EmpID format). I want to write a select query where I want to fetch First and Last name of the Award Presenter from table A based … Databases microsoft-access |
 | Hi all I have a table that has a datetime column. What I'm trying to do is select the time only like one does when selecting only the day or month from a date column (eg SELECT day(date)) Can anyone tell me how to get this right. Using the following … Databases mysql  |
 | HI All, my requirement is as below: lets product name is "aaa bbb ccc". Now in search coding i have use LIKE statement. [CODE]"... where product_name LIKE '%".$keyword."%'"[/CODE] Now when user insert 'aaa' or 'bbb' or 'ccc' or 'aaa bbb' or 'bbb ccc' search works. But if user insert 'aaa … Databases mysql |
| | i want to use federated tables in my db and not sure how to set them up in phpmyadmin...? does anyone have a solution for me...? |
| | I have a table with 3 columns, a record_num, a date field, and a description. In the date field there can be some rows that have a distinct date and others that have the same date. I wanted to take a look at all the rows that have dates that … Databases mysql |
| | Hi, I need to print all the orders with the month in the Monthly Order Report.How should I do it.Can someone tel me how to do it... This is my query.Order date should equal to the relavent month... [code] $this->result = mysql_query("SELECT * FROM tbl_order,tbl_order_items WHERE tbl_order.order_id=tbl_order_items.order_id AND tbl_order.order_status='accepted' AND … Databases mysql |
| | Greetings, I installed MySQL 5.1.48-2 on Fedora 13 64bit. Whenever I tried to connect using the terminal by typing : [B][user@work ~]$ mysql[/B] I get the following error: [B]ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)[/B] I also installed MySQL on Red Hat Enterprise 5 … Databases mysql |
| | hi all, i have a little issue with SUM query from this table UNIQUEID Date Production engine1 01/12/1999 1440 engine1 01/01/2000 6061 engine1 01/02/2000 5152 engine1 01/03/2000 5347 engine1 01/04/2000 4642 engine1 01/05/2000 5264 engine1 01/06/2000 5247 engine2 01/07/1995 561 engine2 01/08/1995 3066 engine2 01/09/1995 2133 engine2 01/10/1995 2282 engine2 … Databases mathematics mysql sql |
| | This is the error i get when im trying to Run my AccountServ.exe it pop ups an error DB LOG Connect Failed. SQLSTATE:IM002 error:[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Databases mssql |
| | hello, for my application I have created a database containing a table where my clients data is stored before they are allowed to use the website. When they are allowed, the info on this table has to be transferred to 3 different tables, using the insert...select-statement. Doing this I don't … Databases mysql |
| | We have 3 shifts running at our plant, day 0720 - 1520 swing 1520 - 1120 night 2320 - 0720 I have a table storing the bags packed on each shift, and now need to display the team (tech, packer_l, packer_r etc) with the greatest number of packed bags depending … Databases java-swing mysql |
The End.