7,494 Archived Topics
Remove Filter  | |
| | Hi not sure if this is possible so wanted some guidance.. I have a database with 3 columns.. id, data,timestamp id is auto increment and data is json array and timestamp is unix timestamp.. the field I wanted to update was data but I wanted to replace just a part …  |
 | Hi I Have an App that connects to an 2010 access DB (.accdb) using OELDB Driver. In my dev pc the application works fine. I also tried installing it on different pc and it worked fine using a access database runtime. Now when Installing it on a pc running access … Databases microsoft-access |
 | |
 | I am using OS Ticket and I have another site for Members Area,I am trying to join the 3 tables that have the information that corresponds to the customer by EMAIL. the first table is:qbcd_ticket: ticket_id | number | user_id | user_email_id | status_id | dept_id | and more... 5 … |
 | To all database genius out there, I hope you can help me with this error I encountered when importing excel file to SQL Server 2005. This is the error: [CODE]Executing (Error) Messages Error 0xc020901c: Data Flow Task 1: There was an error with output column "Description" (21) on output "Excel … Databases microsoft-office mssql sql |
| | I am trying to cast/ convert varchar to a numeric value. I have done this succesfuly when I eval the lower range, however I get an error when I do the upper range. this is my evaluation section that works. isnull(cast(measurmentdata.measvalue as numeric),0) < productinfo.lowerrange however when I try to … |
| | Hi Experts, I had completed a database in vb.net with access database. Now my question is, how to make it accessible online? Thanks. Databases microsoft-access vb.net  |
 | Hello, I am trying to upload mysql file into my xampp. (Max: 2,048KiB) I wonder why it cannot exceed that limit? I have tried to update my php.ini file : upload_max_filesize=10M and save it but it does not change the fact. I have to upload like 2.6 M file but … Databases sql |
| | Hello Everyone, I am working in MySQL Workbench 6.3 CE and trying to use a trigger inside of a stored procedure to see if it will detect if my email format is not in the right format I specified in the message text error, but I am having trouble because … |
 | Only one of mysql databases stopped working. Unfortunately, it was the most important database: Table was marked as crashed and should be repaired. It happened on MySQL 5.6, and I don’t know how to overcome this error. I need to restore microsoft my sql 2000. Databases mysql  |
 | Hello, I've joined Daniweb months ago, but haven't really had the time to post here. I apologize if I posted in the wrong section, as I tried to look for the most specific one. So far I've seen `Linux/Unix > server` as the closest. I'm currently stuck with my situation … Databases client-server unix  |
 | I have a code in two files and I want to convert it from mysql to mysqli. func.php: <?php $con = mysql_connect('*','*','*'); mysql_select_db("*",$con); function search_results($keywords){ $returned_results = array(); $where = ""; $keywords = preg_split('/[\s]+/',$keywords); $total_keywords = count($keywords); foreach ($keywords as $key => $keyword) { $keyword = strtolower($keyword); $where .= "LOWER(`keywords`) … |
 | i have this code..,. i dont see what's wrong why its only working on the first record of LOOP of X set serveroutput on size 30000; DECLARE VTEMP NUMBER; VPARENT NUMBER; BEGIN FOR X IN ( SELECT TEMPLATE_ID, TYPE_ID, TYPE_KIND, RECORD_ID FROM RT_RECORDS WHERE TEMPLATE_ID = 106 )LOOP DBMS_OUTPUT.PUT_LINE('TYPE_ID X …  |
 | Hi Everyone, I have a real noob question please, I am trying to update a mysql database using the code below, I know the invoice number variable is correct, But for some reason the database is not updating, Can someone point me in the right direction please, I have tried … Databases mysql |
 | Hi good day guys.. i am doing a POS in Microsoft access for my thesis.. the problem .. i create a button and i want to enter a data to the list box.. if you click the menu button it will automatically add the item on list box.. and i … Databases microsoft microsoft-access |
 | **I can't update inserted data via GUI, Its working well on inserting records before I modify it, and when am trying to modify in order to update inserted data its not update as I expect to happen. I can display inserted data well by echo them to GUI Below is … |
 | Hi friends , I have three table Countdown, Walk, Bon de reception The Id_marche is a foreign key in the countdown table and The Receipt table contains the Id_marche I want to insert in recordings in the counting table which contains Amount TTC so to calculate Amount TTC = TVA* … Databases sql  |
 | i am a new bee to oracle and database world, i need your help, as i am a student i learnt some commands in class, how to retrieve the tables and its contents in 10g, my question is that, is there any builtin tables in oracle 11g as well if … Databases oracle |
 | hi guys. is it possible to make a new tables using vb6 and duplicate some field names on the database access 2003. the program were to work just like this. the program can create a unlimited numbers of table that only changes the month date and some field names for … Databases visual-basic |
| | Hi, I have used current_timestamp, i am submitting same values then current_timestamp not updating. I have used below for updating timestamp. (timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP) Kindly help me to update timestamp, on every hit Databases mysql |
| | Good day, I having a problem where creating my setting table as condition below column User_id setting effective_date effective_end_date Row 1: 1 ABC 2017-03-01 2018-02-28 Row 2: 1 DEF 2018-03-01 2019-03-01 I wish to add a constraint to block if same user add in a setting with the effective_date or … Databases mssql |
 | I would like to show data in a table in SQL server database to Gridview in ASP.NET project, but the gridview shows nothing. Could you please help me to find where is the problem, and how to fix it. Thanks Here is my code: protected void Page_Load(object sender, EventArgs e) …  |
 | Hi Everyone Dont know if this is the right place to ask this but i Just wanted to consult anybody of you that might have an idea on what this core dump message means. Yesterday my website is down for almost 30 min and when i called the hosting provider … Databases client-server mysql php |
| | Hello, so, I'm playing a bit with **MariaDB 10.0.29** and I cannot understand why `FOUND_ROWS()` keeps returning the `1` whatever happens to the latest select query. Here's my test: > CREATE TABLE `test` (`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY, `msg` VARCHAR(100) NULL) ENGINE = InnoDB; Query OK, 0 rows affected … |
 | “RunTime-13” Type mismatch error in code after access 2003 convert to 2010. Databases microsoft-access  |
 | How can I do a bulk insert of rows but only if specific combinations of columns don't already exist? Those columns are not unique to the table. (Otherwise I could easily use INSERT IGNORE). Rather, I just need this to happen for one particular SQL query. Databases mysql |
| | Im working with Forms Builder. Ive built my form, when Im testing, it shows: FRM-41045::cannot find item:invalid ID. See Help>Online help for details But, online help sucks - there are only unanswered questions (forum-like site) Any help? Databases client-server oracle sql |
| | Hello, I rebooted my server and it won't startup due to the below error, now server is not getting up, its throwing the below error and keep trying to connect to Oracle, so I am unable to access the server to free some space if its the issue as per … Databases oracle  |
| | Why was `INSERT DELAYED` deprecated? https://dev.mysql.com/doc/refman/5.7/en/insert-delayed.html I used to use it and it was incredibly useful. Databases mysql  |
| | I have an InnoDB table called `articles_read` with fewer than 20,000 rows in it. It consists of 3 columns: member_id article_id timestamp There are two indexes: A unique index on (member_id, article_id) and a regular index on (timestamp). It is read from fairly more than it is written to, and … Databases mysql  |
| | SAMPLE TABLE 1 =================================== product Division sales % =================================== product1 divsion1 99 product2 divsion1 51 product3 divsion1 50 product4 divsion2 98 product5 divsion2 41 product6 divsion2 40 product7 divsion3 97 product8 divsion3 31 product9 divsion3 30 =================================== Expected output 1 =================================== product2 divsion1 51 product3 divsion1 50 product5 divsion2 41 … Databases mysql |
 | HI, I have recently upgraded my mysql database to version 5.1.72 community log. I am having an issue that all my select queries are showing the columns as NULL if there is no entry added for a specific column. For exmaple I have a table table_employee and the employee name … |
 | Hi hope you can help me. I have studied a lot to make my website using php and mysql and I know how to insert data in a table from a form, how to select and display data on page etc. Lately I got involved with wordpress which is a … |
| | Hi all, I'm working on a SQL procedure to insert a row for new clients based on a template account that already exists in the database. I thought about Declaring a variable and selecting the value from the table one at a time, but with many columns needed, this seems … Databases sql |
| | Hello, I built a website on my personal server and everything work fine. But when I uploaded it on the production server there is a problem with the database - the character encoding is wrong so the text is unreadable (users submit greek words). The collation of the tables is … |
| | The issue I am having has to do with not being able to show different OrderDate for the same Unit Unit OrderDate ShipDate ReceiptDate Robot 20160101 20160102 20160103 Robot 20160102 20160103 20160104 Robot 20160103 20160104 20160105 What is happening instead is that it is showing the same OrderDate for all … |
 | Hi hope someone can help me Read sqlite datatable is verry slow I have a listview in detail mode with 45 columns. and a datatable to add, read, delete and update datarows with 45 colums. Only i have a problem to read the datatable and show it all in the … Databases listview open-source sqlite vb.net  |
| | What is FIND_IN_SET() performance like? It it something that should be avoided at all costs? I want to search a column that consists of comma-delimited numbers for rows that contain a specific number. Databases mysql |
 | Hello friends. Please help me to solve my problem. I am using sql server 2008. When I try to access it recieve the following error: "Cannot connect to localhost ". So my question is, how to repair sql server? Hopefully someone will be able to help me with this.  |
| | I am working on a report that is requesting to count the total number of errors per element in the total row of the report for a given County. When I use the COUNT function it is taking the max value from the number of reads complete column for that … Databases sql |
 | /DROP TABLE STATEMENTS/ DROP TABLE BRANCH CASCADE CONSTRAINT PURGE; DROP TABLE SCREEN CASCADE CONSTRAINT PURGE; DROP TABLE SESSIONS CASCADE CONSTRAINT PURGE; DROP TABLE MOVIE CASCADE CONSTRAINT PURGE; /CREATE TABLE STATEMENT/ CREATE TABLE BRANCH( BRANCHID CHAR(2)NOT NULL, BRANCHNAME VARCHAR2(20), BRANCHSUBURB VARCHAR2(15), BRANCHPOSTCODE CHAR(4), CONSTRAINT BRANCH_PK PRIMARY KEY(BRANCHID)); CREATE TABLE SCREEN( SCREENID …  |
 | Hi to all! I am using sql server 2008 enterprise edition. My instance name is "saboor-pc/ SQLSERVERENT". I am using this server for many months and i am satisfied but today an unexpected error occured when i clicked on "connect" button in sql server management studio. The error was: "Cannot … Databases client-server sql |
 | Help me....! Actually I have records about 1000 credit customers, My collection boys go to their door on due date(eg. 15-11-2016) for collection of money. but they have no money to pay,that's why they call my collection boy after 10 day(eg. 26-11-2016). Now, I want the query in Sql. if … Databases sql |
 | I am working on a table that will hold batch data. The table will have a BatchDate column as a DateTime type. I'm considering adding a column for BatchYear as an integer and BatchPeriod (which could be a week number, a month number or a quarter number) as an integer, … Databases database-design mssql |
| | Hello to all! I am going to make a stock management and Point of sale for a person on Ms Excel file. Actually my client has a store of bedding accessories (e.g pillows, blankets, quilts, cushions. bedsheets and many other items).I have to maintain such an excel file that should … Databases  |
 | Hi, can some one please help? I want to double-click on a "customer name" in form1 datagridview and then see "customer details" of selected customer on form2.. (in ms access it called "linked forms") I use VS2012 (vb.net) and SQL database.. Thanks, Michelle Databases sql vb.net web-design |
 | I want to retrive data from two tables. I used below code : (SELECT sum(total_amount) as tr from loan where loan_status = 'not finish') union (SELECT sum(amount) as tt from settlement where sett_status = 'Active') But It load data by one column and these two values load under the another …  |
| | I'm a beginner with databases and I'm trying to design a database in Microsoft Access that will allow users to make bookings for fitness classes. There are two slots per day that these classes can be booked for and each session can cater for 10 people. What I am struggling … Databases database-design microsoft-access session  |
| | I had mysql database and had many tables in database. For this problem we need details only about two tables. These tables are customer and guarantor. For each customer had two guarantors. In Customer tables it's primary key is Customer_id In Guarantor table it's primary key is Guarantor_id Then I … Databases mysql |
 | I am using the Ionic framwork for the mobile app and Bootstrap for the web app, this has been set by my University as what we have to use, so we can't change them, but is there a way to link the data base to both services? Thanks in advance … Databases client-server microsoft-access mysql php sql |
The End.