7,494 Archived Topics
Remove Filter  | |
| | Hi Looking for some general advice: I have taken over support of a large and complex web site, which uses multiple Access databases. At present it makes use of the MS Jet database engine (Provider=Microsoft.Jet.OLEDB.4.0). (as well as MySQL, used in a Snitz forum). After solving many specific problems I … Databases asp microsoft-access  |
| | Guys, When i run this sscript i got an error in Where clause? Where should be place this where clause? [CODE] SELECT p.ESN, p.ReturnDate,s.Receiptdate,e.Shipdate FROM USProductRecovery p with (nolock) OUTER APPLY((SELECT TOP 1 Receiptdate FROM ESNSalvReceipts s with (nolock) WHERE ESN = p.ESN AND Receiptdate > p.Returndate ORDER BY Receiptdate … Databases mssql  |
 | Hi all! I am trying to connect to a remote MySQL database in a VB.NET application. This database is located on my LAN at the address 192.168.1.2. I am using MySQL Connector/ODBC 3.51 (MyODBC 3.51) for the connection. The connection string that I am using is the following- Driver={MySQL ODBC …  |
 | I'm trying to make a table and mysql is giving me this error: [QUOTE] #1005 - Can't create table 'likes.users' (errno: 150) [/QUOTE] That would be great to see a website that explains mysql errors like this for oracle [url]http://ora-code.com/[/url] [CODE] CREATE TABLE IF NOT EXISTS `users` ( `user_id` int(2) … |
| | i want to increase the size of the column [CODE]ALTER TABLE employee ALTER COLUMN department_name VARCHAR(50)[/CODE] Databases mysql |
| | I am a newbie looking at designing a simple database for my manufacture-based company, part of the job it does is maintaining a Purchase Order Table, a typical one and it suits all the customers we have, except for 1 particular customer which typically issues a Quantity Contract - a … Databases database-design |
| | Hi everyone, I have created tables and deleted some rows and then inserted new rows. The IDs of the later created rows didn't start at 0 or 1. I dropped my entire database then recreated the same one with the same tables and fields. Unfortunately, newly entered rows started from … Databases mysql |
| | i am starting to learn to connect a cprogram to a mysql database. i have got this elementary program to connect to server , create a database and disconnect from it. [code]#include <stdio.h> #include<windows.h> #include <mysql.h> static char *opt_host_name = NULL; /* server host (default=localhost) */ static char *opt_user_name =NULL; … Databases mysql |
| | Hi.... I am trying to connect sql server with vb.net in Visual Studio 2008 with foll. code.... but it is having problem....what is the problem? Please tell me.... 1. I created "publication" databse. In table i took 2 columns...fname and lname and fill the records... 2. I took DataGridView onto …  |
| | i had a database with 4 column and each column has a value, below are the sample. ---------------------- col1-col2-col3-col4 -- 1------4-----7--------- 5------3----------10--- 6------------5----12--- my question is how can i get the lowest value in each row? here's an output that i wanted to get: 1 3 5 and here's my … |
| | |
| | Hi all, I haven't changed anything in the config file in phpMyAdmin folder. I don't know why the WAMP server gives me this error. Although everything was working perfectly yesterday. Does anyone know how I can fix this problem? [CODE] You don't have permission to access /phpmyadmin/ on this server. … |
| | I have all my customer information in a database program called Maximizer CRM 11. I inherited this info from another worker. I would rather use Microsoft Access. I am thinking that I can export the Maximizer database to a csv file. Will that include all the fields and can I … Databases microsoft-access |
 | I am getting an access denied error when I am writing to the database I am using this line [CODE] LOAD DATA INFILE 'upload.txt' REPLACE INTO TABLE Test FIELDS TERMINATED BY ',' [/CODE] I have made sure I allowed remote SQL, and I made sure to give the user all … |
| | hi! another query! i want to insert values into the table 'employee' for the 'adddress' field in such a way that the large address comes in two or three lines like this [code] empid empname address mobile grade basic Joyban1 Joy banerjee 5/67, 1234567890 2000 10000 nehru colony, kolkata 700045 … Databases mysql  |
 | I have a very simple wish, to dump all databases so I can lock up a backup of the databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2}""$h"_mysql_dumpall.sql[/CODE] worked, however the file contained a little error message telling me I had … Databases debian mysql postgresql ubuntu |
 | is it possible to move a database from one machine to another? maybe like copying the tables... Databases mysql |
| | i am creating a table employee which looks like this [code]use employeemaster; drop table if exists employee; create table employee ( serial int unsigned NOT NULL auto_increment, empid tinytext NOT NULL , empname varchar(255) NOT NULL, address text NOT NULL mobile bigint unsigned NOT NULL, grade char(2) NOT NULL, basic … Databases mysql |
| | All right. So i have child, parent, activity and register table and i want know how much money a parent will pay for his child if the child have 1 or more activities. So i came out with this code: [CODE]SELECT CONCAT_WS (' ', parent_title, parent_fname, parent_sname) AS 'Parent/Carer Name', … Databases finance mathematics mysql |
| | I have a database full of user. This is roughly how the database looks: [CODE]| username | sex | birthdate | zip_code | |----------+-----+------------+----------| | coolUser | M | 02-14-1987 | 90210 | | blueUser | F | 06-16-1982 | 10011 | | . | . | . | . … |
| | I know this sounds strange, but I messed up in a 'Manual' change to a DB table, and need to find a couple of records that I have no pathway to find... Explanation We have a member table called 'members' several different position tables, one for each level called position_1, … Databases mysql |
| | Hey guys, Basically i want to create a database in Access 2002 that will hold names of functions of a mobile phone. When the user enters a search the databse should query the information held within it, display the appropriate search results. It should be able to serach for precise … Databases display email microsoft-access sql |
| | Is there anyway i can link a session to a particular table within my database, well i think this is how i need to do it. I have different tables which hold information for different shifts. The user selects the Site from one page, then selects the shift from another … |
| | Hello, My db table is this (semester result table) [B]sem1 regno(int) s1(enum) s2(enum), s3(enum), s4(enum) [/B] I want to find number of subjects in which the student with given id has gotten a particular grade. (ie no of subjects he/she has failed). Is it possible or shld i change the … Databases mysql |
| | Hello, Am new to php and I have a question that is probably very easy. I have been watching tutorials online to learn how to work with databases, but none of them speak on how to upload to server. This is my problem: am using vertrigoserv but specifically using PHPMyAdmin … Databases file-system mysql php |
| | i am using mysql for the first time and following an online tutorial. i am using the command prompt to connect to the mysql server. the problem is that , i want to create a new database named bookstore. so, in the mysql> prompt i am writing [CODE] create database … Databases file-system mysql |
| | Hi, I am trying to add up the quantity of various items found in a table, that is controlled by a second/third joined table using the IN search criteria. However I am unable to work out getting the SUM of all the items. The tables are as below: [ICODE]Table One: … Databases mssql |
| | I am trying to link fields between 2 of my tables but its not working. I have a table called assets, which consists of Asset_ID and AssetType and a table called t5_week3_shift3 which also consists of these 2 plus others. Im not sure whether to do away with the assets … Databases mysql |
| | hello :) i wanted to know that how can i move my database here and there..?? i'm working on Sql using some 'xamp' named software.. i have to create few tables, then i need to give this database to my friend..he'll add few more tables in it..then finally, we have … Databases mysql |
| | I am trying to write a program that can access my database from a remote computer and change it. How can I figure out the url of my database? according to my source it should be something like this [CODE] jdbc:mysql://host_name:port/dbname [/CODE] Thanks for your help. Databases mysql |
| | Hi everyone!!! I wanted to know the incorrect values for oracle data types. like for example, string data type cannot accept ' value. What other values does string data type does not allow.? and what about other data types like number, float. Thanks in advance.. Databases oracle |
| | Hi there, I was wondering if someone could tell me how to store multiple checkbox values into a MySQL table? I know how to work it with Python on its own but I need to store into a database. Any ideas? Databases mysql |
| | Guyz i need changes in this stored procedure "between" or anything like ven i enter a start date and end date on as 26 dec twice i get error set @Result = (select COUNT(*) from Employee_Leave where Employee_Id = @Employee_Id and Leave_Date = @start_Date AND ) and does not duplicate … Databases mssql |
| | I am trying to display the result from a query in to a table. I can do this pretty easily when doing queries from mysql, but cannot get it to work with mssql. Below is the code I used to actually make sure I could get the data (and it … |
 | Hi friends, can you guys help me to find the best way to track information changes in sql server 2000, like a free utility. The problem is that i need to track every single table because i want to figure something out. we have an ERP System and there is … |
| | i have two column in table select Col1 + ' ' + Col2 from test It gives output as Arun Kumar But i want output as Arun Kumar Can anyone help me out Databases mssql |
| | Hi, I need to use query to check if a person has made a purchase during the month of his / her birthday. If yes, I have to give the person 10% discount. So, I have my database as such (Some of the tables are omitted due to its relavancy): … Databases mssql |
| | hi, when i insert date time into my database it insert server time not local time how can i change this? even i tried ; [CODE]$currntdate = date("F j, Y, g:i a");[/CODE] which didn't work either.. thanx in advance. Databases client-server mysql php |
| | I am using MySQL to store the RSS feed contents that are updated every few hours. I truncate the database once a day. But during the day, whenever same feeds are updated every few hours I get duplicate entries piled up. Is there any PHP script that I can run … Databases mysql |
 | Hi Guys I want to crete the SQL Tigger.There is table called Fruits.In fruits table it contain ITEM_CODE,ITEM_NAME and PRICE.So there is application that used to insert the values into fruits table. So I want once ITEM_Name or ITEM_CODE is update then sql trigger execute and It insert the update … Databases mssql |
| | Does anyone know the SQL statement for replacing a string in the whole of a database. My database is called DB1 and I want to remove any instance of "Table/". Many Thanks, Databases mysql |
| | This is a part of hospital diagram. Each nurse can be assigned to different wards on different days of the week so a nurse must be supervised by another one who is assigned to the same ward on the same day of the week as the nurse or the nurse … Databases |
| | what are the diffrences between CREATE INDEX [WITH IGNORE_DUPLICATE_KEY OFF] and CREATE UNIQUE INDEX it sounds the same! and if anyone knows when creating a plain INDEX just CREATE INDEX whether it creates a clustered or nonclustered index couldnt find an anshwer to that thanks in advance Databases mssql  |
| | Hi everubody! I have a huge issue with dates and encoding in my database. Two weeks ago I restored a database from an Xcloner copy to my site, since then all problems are there. My site language is Spanish, and I was using in Wordpress define('DB_CHARSET', 'UTF8'); Since then if …  |
| | I made a test database to store items in a database, but I keep getting an error when trying to import from a txt file. Here is my txt file [CODE] 1,Lánc 2,Fa 3,Csavar 4,Lakat [/CODE] How could I fix this problem? Also is there a reason I need to … Databases mysql |
| | hi, i looked all the codes but i could not really see it - i dont really understand coding-. after registration this website send an activation code but i want to make the user active when they actually register. when they register their status is set to A but for … Databases mysql |
 | hi all, I have doubt on Index,I know Index are used to increase the performance of table but my question is where to create Index whether primary key table or foreign key tables ? Databases mysql |
| | Hi, I want to create a database like Dmoz(dmoz.org). I have a problem with creating parent child relation. I want to create parent child relation. This parent child relation will be assigned to a 'links' table. In the links table I will insert data whether in root category or subcategory … |
| | Hi, i want to write a query for employee's who's name start with "a" and end with "b". Thnks in advance :) Databases mssql |
| | hi, my client side files are in one server and server side codes and the mysql in one on my client side files config i see the below [ICODE]$config["db_host"] = "mysevercodessideIP"; $config["db_user"] = "myuser"; $config["db_pass"] = "mypassword"; $config["db_name"] = "myDBName";[/ICODE] i get the error [ICODE]MySQL Error:Can't connect to local MySQL … Databases client-server mysql |
The End.