7,494 Archived Topics
Remove Filter  | |
 | Good day! I am currently working on this code. My problem is that the delete option don't function. It gets the error "There has been a fatal error." as stated in the code, so please help me to fix this code. Thank you <html> <head> <title>Buyer's Profile</title> </head> <body> <?php …  |
| | Good day! I have 3 tables name property, personal and spouse, they have all the same id. I want to join the 3 of them, I had already join property and personal table but I can't join the spouse table. $userquery = mysql_query("SELECT * FROM property, personal WHERE property.id=personal.id") or … Databases mysql |
| | I need to change the timezone of mysql to 'Asia/Calcutta'. I am on shared goaddy hosting. Please tell me how to do the same Databases mysql |
 | Hi, Im trying to extract data from sql server where conditions are multiple and variying I have a datagridview with 2 columns ID and Name I need to create Select Query to extract data where condition is 'ID should be equal to the value or values in Datagridview ID Column. … |
 | hello i wanted to insert data into database like html format i mean i text wich contain html tag like H1 H2 OR P, and any basic other i must use BLOB OR LONGTEXT, if i uses BLOB i must enter that directly in database or upluad that file ?? … Databases mysql |
| | What do you think about PL/SQL ? Is this a language worth learning for the feature along with SAP? Databases oracle |
 | A clustering index is an ordered file with two fields; the first field is of the same type as the clustering field of the data file, and the second field is a disk block pointer. There is one entry in the clustering index for each distinct value of the clustering … Databases  |
| | Is there a way to get a total counts from the resultset of two unions? This will be for DB2. select count(*) from ( select count(*) from xyz where abc='1' union all select count(*) from x1y1z1 where abc='1' ) Databases mssql |
| | I need to know how the primary index is classified as a sparse index? The sparse index as described by some aticles and books has index entries for only some of the search values and has a fewer entries than the number of records in the file. When you make … Databases client-server sql |
| | I'm implement if else in stored procedure with and oprator . If both Conditions are true the if statement should return 1 else -1. here username and email should not be duplicate please review query below. alter proc spUserdetailss @name Nvarchar(50), @passwords Nvarchar(100), @emailadd Nvarchar(50), @Gender nvarchar(50) as begin declare … |
| | Hi!I'm stundent in year 2 in computer science i would ask all frind to tell me the best book that i can read so that i get better knoledge about database Databases  |
| | This function I have created to return all recorded Stock numbers in the Table "ContributorDeeds" the table contains only the start number of the stocks and the end number of the stocks (e.g, from number - to number) I need to get all the numbers between within that range. The … Databases client-server mssql sql |
| | hello friends I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net. update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = …  |
| | Hi, I have to correct some data in SQL Server 2008 R2 database for an accounting system that was accidently over written. Basically I've to take stock items with fixed prices and compare those fixed prices against Sales Order Transactions for the stock item and correct entries where the transaction … Databases mssql |
| | Hi all i need to update some iframe values in my videos table, embed column. Can I achieve this with this kind code below ? I tried already but i got syntax errors. Please help me. here is the code type of column embed is text. UPDATE videos SET embed … Databases mysql |
| | Good afternoon, I'm drawing a complete blank on this, and decided someone in here could answer the question for me without an issue. I have a mysql DB with thousands of records in it, and over time have used an inadequate system for maintaining terminated records. I've been simply prepending … Databases mysql |
| | I have written a SQL query to find product information in a c# program and it doesn't seem to work at all! I have tested a variety of other queries with my C# code and it works fine, but this throws an exception every time. SELECT TOP (1) CONVERT(varchar, tmpRptAssetEvent.EventTimeStamp, … Databases mssql  |
| | Hi I have an issue in below stored procedure. below Store procedure is working fine. But fixed the Year. Any one know How can do the year dynamically select by user? SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo pivot (Sum(gross) for [yearno] in ([2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]) )pivotTable pls advice Maideen Databases mssql |
| | Greetings, I'm facing a problem with the SQL Server and this problem concerning numbers when compared each other and these numbers are stored in the columns of data type NVARCHAR or VARCHAR. For example, if I'm having a column with data type NVARCHAR and it contains such values: 1 2 … Databases mssql |
| | Hi all, I have created a table in which i have a DateTime Column . i need that i dont want to insert values in that column from the front end. i have created a trigger for that purpose. whenever i insert a row in that table the dateTime column … Databases mssql |
| | Hello, I have my database xampp mysql and i put values from visual studio 2012. I have the code for INSERT INTO mytable, but always i insert the value, this value appears like 0. I dont know the reason beacause if i'm conected to the database and i send the … Databases mysql visual-studio |
| | Can you help me with this program?. I am trying to insert data into two mysql tables at once. I have two tables: property and personal. <?php define('DB_NAME', 'purchase'); define('DB_USER', 'root'); define('DB_PASSWORD', 'root'); define('DB_HOST', 'localhost'); $connection = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$connection) { die('Could not connect: ' . mysql_error()); } … |
| | I have this query as part of a stored procedure, and this query as it is listed here works: INSERT INTO OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 8.0;Database=G:\KF\GBSData.xls;', 'SELECT * FROM [Sheet1$]') SELECT * FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE invoiceNumber IN ( SELECT invoiceNumber FROM [KWF_GBSData].[dbo].[tblKWF_WorkTable2] WHERE stockNumberShipped LIKE 'CCCOMBO%' ) I would like to change … Databases microsoft-office mssql sql |
 | Hello everyone. I have 4 tables whose Structures are provided with my question as snapshots Table 1--> Students Table 2--> Courses Table 3--> Student_Courses Table 4--> Users I want 3 columns in the output which are. 1- Course 2- Classes Attempt 3- Classes Missed Now : --Only those courses should … Databases mysql |
| | I have the following code.. echo "<table align='center' border='1': bordercolor='silver'>"; echo "<tr>"; echo "<td align='center' width='200'>" . "<h4> "."Course" . " " . "</td>"; //echo "<td>" . " " ."</td>"; echo "<td align='center' width='200'>" . "<h4> "."Classes Attended" . " " . "</td>"; //echo "<td>" . " " ."</td>"; echo … Databases  |
 | I have a code behind in my web pages and I'm trying to write Greek characters in my SQL 2010 Tables. I write in my Tables but what I get is ????? why is that? What I have to do in my SQL in order get the Greek characters? Thank … Databases mssql |
 | Hey guys. I'm writing myself an online toolbox (for my code snippets). I have a "Snippets" table. My question is this. Would you save the snippet source in a Text column or would you have the snippet saved to a text file and the Snippet entry would reference the file … Databases mysql |
| | Hi, I want to create a trigger to increment value of my VisibleNo field if it gets duplicate value. My Application is my multiple users at same time . When at first suppose two users open application it gets same visible no and it saves duplicate number. I want use … Databases mssql |
| | Hi.. I'm getting error in my query.. while using it in oracle it is working.. But when using it in mysql it is not working.. i'm getting error as insert into ProjectHealthReportAudit(clientid, projectid, month, year, phasesId,ACTIVITIESSUBTYPEID, ACTIVITIESARTIFACTSID,processConformance,comments, pcinumber, pciscore, colour, createddate,createdby) values ( (select clientid from client where clientName = … |
| |  In the above model I have an Images table which holds all the filenames relevant to the image. I have two relationship tables (Image_Has_People and Image_Has_Event). Both of these tables have an FK ImageID linked to the Image table's PK idImage. I'm wondering, if I set both relationship … Databases mysql |
| | Hi guys, I'm currently on the pretty cool Database development path. I've quickly got to terms with basic SQL with individual tables, and various queries. Now things seen to be getting a little beyond a concept I had been taught from a young age. Am I doing this right. The … |
| | I need to do a search that specifies in witch line of the search that the information was found. For example: select * from table where height=100; this code returns 50 lines, but i want, for example, in that search, the person 'Matheus' was in the 28th line of the … Databases mysql  |
 | Hi need some insight on how to show record from different database on the same server. i also tried using join but didnt get the correct output. im finding a way to make it work using just one query. my last resort will be using different query to select the … Databases mysql |
 | Ok, what I'm trying to do is have next and prev buttons to navigate through a mysql database sorted by date. Currently, the code I wrote does this, but gets stuck on duplicate dates. $Next = mysql_query("SELECT * FROM $logbook WHERE Date>='$Date' AND ID!='$ID' ORDER BY Date LIMIT 1"); $Prev … |
 | i have a datagridview and a combobox. the combobox is auto populated by values from a database. i need to filter the datagridview using combobox. this is the code that i've done. it shows a error : Cannot find column [year]. can you help me??? Imports MySql.Data.MySqlClient Public Class ReportGradeLevel … |
| | Hi all , Grasping at straws really, I have a local gym who had BioStar installed on there PC, the PC finally gave up the ghost and they had a new one. I saved the .exe for the program and have a walk through pdf. Having installed and got it … |
 | Hi all, I have two db, one db "latestdb" which have latest six months records second db "backupdb" which have oldest records of "latestdb" and this records deleted from "latestdb" I have a query which should return records from both db. Query will return new records from "latestdb" and old … Databases mysql |
 | So I currently am trying to insert a row into a MEMORY table but only if the primary key doesn't already exist. I'm using INSERT IGNORE but I was reading, much to my surprise, that INSERT IGNORE is actually slower than INSERT ... ON DUPLICATE KEY, but that letting the … Databases mysql |
 | Hi All, While going through my project work, I just came across a situation, where I needed to alter my table. I needed to add a column at the beginning of the table, i.e. the first column of the table. We have syntax for appending a column to a table … Databases mysql |
| | Hello. I need some help to update two table.. This is my coding: $query = "UPDATE br.discharged_Date, b.book_Status SET br.patron_ID = b.patron_ID FROM borrow br INNER JOIN book b ON br.patron_ID = b.patron_ID WHERE b.patron_ID = '$patron_ID'"; Databases mysql |
 | Hi..I sure hope you can help me ! 2 years ago you helped with a Update Form and I've been trying to adapt the form to my mySQL Database.As I'm just learning and trying to figure some of this out I've seemed to have hit a road block. . . … |
| | hello everyone, I am having some difficulty setting up a connection to my database. I created one on godaddy but am unable to get past this one hump: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: NO)' in /home/badinvestor/public_html/config/connection.php:9 Stack trace: #0 … |
| | Hello All, I am facing a problem coming up with a SQL query for a certain issue: Table 1 ------------------- Client ID|Name of Client|Customer Type|Account Type| 01| A | AB | 30 | 02| B | AB | 30 | 03| C | CD | 30 | 04| D | … |
| | i am trying to check availability of a room i have the following code: ALTER procedure [dbo].[CheckAvailability] @checkIn datetime, @checkout datetime as Select r.RoomName, RoomNO, [Description],Location, RoomPic, Price from [Room-Type] t , Room r, Booking b where r.TypeNo= t.TypeNo AND r.RoomName Not IN( Select b.CheckinDate from Booking b where ( … Databases mssql  |
| | Hello All, I want to start by saying thank you for your help and reviewing my post. I am relatively new to MySQL and databases in general so please be polite. I need help with some of my queries. I have done some but these are complex queries for me. … Databases mysql  |
 | Hello, I have one query with timestamp. I got below error. select users.login, FROM_UNIXTIME(AVG(UNIX_TIMESTAMP(ticket_history.create_time)-UNIX_TIMESTAMP(ticket.create_time))) from ticket_history_type inner join ticket_history on ticket_history.history_type_id=ticket_history_type.id inner join ticket on ticket.id = ticket_history.ticket_id inner join users on users.id = ticket_history.change_by where ticket.create_time BETWEEN '2014-10-01' AND '2014-10-15' AND ticket_history.name ='%%new%%Fermeture réussie%%' group by users.id *`error: function … |
 | Gentlemen, I have a problem in entering a "DATE" in to MySQL table via a Java SWING interface. I used 'jdatepicker' to select a date & I use XAMPP server for MySQL database. Earlier I converted the selected date in to String values & feed as VARCHAR in mysql table. … Databases java-swing mysql |
| | hello, how could i create a timestamp or time_of_posting column in my site such that there is no sync problem bw server time and visitor's time... also that column will be used for finding if diff bw time_of_posting and current time is >11months and less than 12 months |
 | |
| | hello,i have a column in my database named 'skills' where all the skills of a person are saved. if i want to find a person with multiple skills like he should be professional in cpppl,javapl,actionscriptpl,matlabpl i will do query like this select email from table where skills regexp 'javapl' and … Databases mysql |
The End.