2,403 Solved Topics
Remove Filter  | |
| | Good Morning... I seem to be having a problem getting the data that I want from a single query... I have a table that contains various information on record processing it has an auto increment field called period_id also a field called max_pl_trans What I need to be able to … Databases mysql |
| | hello! I got this error when I tried to connect to my db in sql server. > Unable to add data connection. Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 8945dcd8080cc91' or one of its dependencies. The system cannot find the file specified. … Databases client-server mssql sql |
| | Hello I had a problem uploading or adding a file on the database and shows the error stated on the title. The column holding the binary data was set to varbinary(MAX). I couldn't find what was my error because I was able to upload a 900kb MS Word Document but … Databases mssql |
| | Heres my statement: SELECT A.AccountID, A.LastName, (SELECT SUM(InvCurrency) FROM B WHERE B.BillingPeriodStart Between '2012-01-01 00:00:00.000' AND '2012-12-31 23:59:59.000' AND A.AccountID = B.AccountID AND StatusID = 1 AND (ServiceCode=13 OR ServiceCode=14) AND (ServiceCode=15 OR ServiceCode=16) AND (ServiceCode=17 OR ServiceCode=18) AND (ServiceCode=19 OR ServiceCode=20) AND (ServiceCode=21 OR ServiceCode=26) ) AS 'Paid' FROM … Databases sql  |
| | Good Morning, Hopefully someone can help me with a quick answer. I have a transaction table with a 'description' column that contains a combination of the members name and some static information i.e. "'username' PURCHASE" or "'username' PAYMENT" and a 'type' column that contains various types of transactions i.e. 'FEE' … Databases mysql |
| | Hi, ok I have about 1600 records in a mySQL db. Many of them have a forward slash "/" in the itemName column. In my site, I am passing the itemName as a URL variable on many search forms, so obviously the forward slash is not a good naming convention … |
| | Hello DaniWeb, I personally work with SQL databases for web development work however I need to learn about Access databases for some upcoming AS Level exams. I asked my teacher, whether Access was vulnerable to Injection attacks and she looked at me with a quizical expression on her face so … Databases |
| | Dear All, I'm facing a problem when using DISTINCT in mysql. Please refer my database design below. id lang album singer title family writer song hits In my db i want distinct title and the id from the db. I'm trying the following code. But it only fetching the results … Databases database-design mysql php  |
 | This is my word "नमस्कार". (It is Indian language (Marathi language) ) mysql is showing like something in image attached How to store Unicode characters to Mysql to show properly? Databases mysql |
 | Hi all, I am attempting to rename a file using the File System Task Editor in SSIS. In the Expression Builder, I have @[User::fileName]+(DT_WSTR,2)DATEPART("mm",GETDATE())+(DT_WSTR,4)DATEPART("yyyy",GETDATE())+".zip" but it returns the following error: > TITLE: Expression Builder >------------------------------ >Expression cannot be evaluated. >------------------------------ >ADDITIONAL INFORMATION: >The data types "DT_I4" and "DT_WSTR" are incompatible … Databases mssql |
 | Hello all. I want to know whether it is possible to retrieve list of all tables found in a particular database titled 'Company'? It have got several tables with the names, Suppliers, Customers, etc etc. Just like Oracle, where you retrive all tables using select * from tab; . Is … |
| | I'm having a strange issue that I'm sure has a reasonable answer, but it's making me nuts. I am using the code below, but no matter what I do, on the host's server it displays the created_date as '0000-00-00 00:00:00'. I get the correct response locally. If I go to … Databases mysql |
| | Wow.. I guess I must have been living with my head in the sand for a few years. I write everything using PHP/MySql, and now it seems that eveything I am reading is referencing MySqli... So I started researching that and found that it has been around for years and … Databases mysql |
| | In my database table, 16 rows are inserted with null values for all columns. How can I delete these rows using SQL statement? Databases mssql  |
| | I need to update values form one table to another and create values if they are not there How can I do this for all values or form values from one ID to another This is the query but I need to run it for every ID and that is … Databases mysql |
| | Hey guys, I'm working on a job. I need sql statement for the following query: "List all Employees Names with equal ages." (If possible, along with their year of birth, or date of birth.) Databases mssql |
| | hi friends, i am using oracle 10xe edition, when i use "select * from tab" in between other table name i found "BIN$VAmBblokS5GK+8YXdhI5EA==$0" give me tips to delete this. thanks for your time. Databases oracle  |
| | I have a problem with retrieving a value from a query. I know what the problem is but not sure how to solve it. Pretend I have this code: $sql = mysql_query("SELECT * FROM sometable WHERE thisvalue = '$_SESSION["value"]'"); // This will always return one result. $result = mysql_fetch_row($sql); echo … Databases mysql |
| | Hello :D I am using the twitter API to perform a search for a certain author, and storing the results in a database so that I can perfrom an action on each entry. However, there are many duplicate results that have small differences at the beginning of the string or … |
| | I have a table with these columns: stockNumber, storageID, lastPutDate, qtyOnHand Each stockNumber can have multiple storageID's but only one lastPutDate and qtyOnHand for each storageID. Here is an example of what the rows might look like: stockNumber storageID lastPutDate qtyOnHand ----------- --------- ----------- --------- 100505 R010101 2012-10-18 150.00 100505 … |
 | I habe table one with Col 1 (PK) Col 2 (NN) Col 3 (NN) Col 4 (NN) Col 5 (NN) Col 6 Col 7 Col 8 Then I create table two with Col 1 (PK) (AI) Col 2 Col 3 (FK) That col 3 from table two is col 1 … Databases mysql  |
| | Hi all, This is something I should know but for some reason the answer is eluding me. In a SSIS Script Task Editor, I am trying to set a package String variable called ReNameFile with the following VB.NET line using DateParts for month and year: Dts.Variables("User::ReNameFile").Value = Dts.Variables("User::fileName").Value.ToString + DatePart(DateInterval.Month, … Databases mssql |
| | I am creating a basic PM system for my website. I have just a basic table for a pm: mysql>describe PM; +--------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+----------------+ | PMID | mediumint(9) | NO | PRI | NULL | auto_increment | | … Databases mysql |
| | Hi all, I have a csv that has over 800,000 records that gets loaded into my db via SSIS package routines. However, there are about 190 records that I do not want to be loaded into the the database. The csv comes from an external source and is unaltered at … Databases mssql |
 | i have tblScrutiny , COLUMNS: teamid name userid now confusion is that every team has many members, so how how would i mention them, like e.g i mention 1 member in teamid =1 , then in next row the teamid changes (identity=ON) , so how to mention 2nd member ? Databases client-server sql |
 | Hey there, I need help with a query. The typical situation is like this: I expect, say, 1000 rows out of a query that is based, say, on lastName column. One column is, say, firstName. I know I only have like twenty unique names that occur on multiple rows. I … Databases mysql |
 | Hello Community, Is there a website that has a database like phpmyadmin that i can access from my website? Please help... Databases mysql |
| | Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) … |
| | I have the following code which is intended to supply the family and given names of people who are in the users table but not in the quiz table. Can I even do this, and this throws an error anyway? `$query = mysql_query("SELECT quiz.userGroup AS q_userGroup, quiz.userDate, users.userGroup AS u_userGroup, … Databases mysql |
| | Dear all, I would really appreciate your help and assistance with a bug i'm facing in myphpadmin Mysql table. I have a table which is named as total amount. I also have a front end php. interface where i do my data entry from. When I enter for example (100000) …  |
 | i have a view named vw_admissionform with columns familycode,Regno,studentname,class for admission form . now if i want to print a student admission form by enetring registration no "regno" in txt1.text then his siblings should also be mentioned on the admission form as requirment by client. for this am using familycode … Databases mssql |
| | Does anybody have any experience with changing an INT column to BIGINT so it will handle larger integer numbers? I have read a lot from searching the subject, but still a little leary of changing it on a live database. Would be nice if someone here has done it without … Databases mysql |
| | so iam create a ecommerce base site. where user can buy stuff. i need some help with coming up a good database structures. so far i got 5 tables. here is what iam thinking: "user" table to keep track of users "user_info" table to keep there detial inforamtion "billing" table … Databases ecommerce |
| | Dear all, I have a huge problem and cant figure it out how to resolve it. I have a mysql database. which has plenty of entries in the table. I have linked my search.php page with my database everything is working fine the data is being fetched and showing the … |
| | HI, I am new to mysql and have two problems. 1. I have two tables that need to have same values from one field , if that values are not same in second table change it to value of first table Frist table is ps_product and they all need to … Databases mysql  |
| | my xampp was giving me problem so i del it and download a new one. now the problem is that all my database and table got del. however i did safe my old xampp folder before del it. if there a way i can get my sql table script from … Databases |
| | I'm not sure that my title is descriptive enough, but here is what I need to do... I had a bit of a screwup today with launching a site... Within about 10 minutes of opening the site, the members created 337 transactions (stored in trans_table) Each of those transaction should … Databases mysql |
| | Hi All, Something strange just happened. I just tried to open a package that I have been working on but nothing opens in Recent Projects on the Start Page in SSIS. The package title is also grey. I have no idea what happened or what I could have done to … Databases mssql |
| | I am not a programmer just learning. I would like to know how to save the scheme info into a table ? I have this sql statement that seems to work but how do i save the info into a table Dim CmdStr As String = " SELECT TABLE_NAME FROM … Databases |
 | Hi guyz , PHP newbie and this piece is givin me a hard time please Help, have indicated the source of the error with a comment <?php ob_start(); include("dataaccess.php"); ?> <?php $strAction = "list"; $num = ""; $strTable = ""; $strkey = ""; if(!empty($_POST)) { if (trim($strTable) == "" ) … |
| | Hello all: I have the following mysql query statement: SELECT COUNT(*) as ttl_rows FROM (SELECT DISTINCT(date(timeentry)) AS day, COUNT(*) AS total FROM history where MONTH(CAST(timeentry as date)) = MONTH(NOW()) AND YEAR(CAST(timeentry as date)) = YEAR(NOW()) GROUP BY DATE_FORMAT(timeentry, '%d') ASC) as ttl_row the statement performs a search for all records … |
| | Hi all, This is going to be difficult for me to describe but I'm going to give it a go! I have tables called tblCPI, tblCPI_Staging, & tblVSeriesList. Please see the diagram.  Right now I am using SSIS 2008 to get data from Statistics Canada and load the … Databases java-swing mssql |
 | Query to make movement of a record I have this tables User Description Item UID Name DeID Dgroup ID DeID Name 1 Jose 1 Printer 1 1 Stylus 2 James 2 Monitor 2 1 Epson 3 2 Viewsonic Transaction Details Ttype IID UserName NewUser Release 1 Jose Release 2 Jose … |
| | Hello, everyone I'm new into databases. I have an Oracle insert sequence that I need to convert to SQL server if anyone could help me to get this to work. I'm not sure if nextval is compatible with SQL Server. Here is the code: // original insert into invoice select … |
| | i have this query: $item_query = mysql_query("SELECT * FROM item"); this will always get the data from 1st row to bottom row. how can i get random data? SELECT * FROM item ORDER BY RAND() or SELECT * FROM item ORDER BY NEWID() i want the best way to get … Databases sql |
| | Hi all, I'm having some trouble inserting records into my MySQL db because of how I've set up my foreign keys. The problem is, I don't know how to fix it to make it do what I need it to. Here is my schema: http://imgur.com/t5bVt Here is my php code … Databases mysql |
| | The idea is to check whether if phone number already exists(data table). If the number exists, then it will create a new row under another table(output table) with the customer ID for that customer. Table data is where pre-loaded phone numbers are stored. Table input is the table where feed … Databases mssql  |
 | Hello, used tech: C# 4.0, sql-Server 2008 i have this stored proc: -- ================================================ -- Template generated from Template Explorer using: -- Create Procedure (New Menu).SQL -- -- Use the Specify Values for Template Parameters -- command (Ctrl-Shift-M) to fill in the parameter -- values below. -- -- This block … Databases mssql |
 | Can anyone suggest a good sqlite3/php tutorial for beginners? I've been using sqlite, and now wanting to learn sqlite3, am looking for a good tutorial but the only ones I seem to find are either assuming you know version 3 already, or are for command line. Databases sqlite |
| | Hi, I have 3 tables Description, Item, Transaction Description Item Transaction DeID Name IID Name DeID TranNo Type IID Date 1 Printer 1 Styl T10 1 1 Repair 1 2 Monitor 2 MPS 1 2 Repair 3 3 ImpSonic 2 I need to count how many printers, Monitors etc. are … |
The End.