7,494 Archived Topics
Remove Filter  | |
| | Does anyone know how to connect to an MSSQL View in syntax. If you know please right back asap. I need this project done quick. Thanks. Databases mssql |
| | I have a databse in mysql and am looking to select the last 5 values in the database and there contence. How would i do this. Will be using php to do this. Thanks There is an incramenting variable called Id and could use that if possible. Databases mysql |
| | Program- VB 6.0 Database- MS Access 2003 I'm build a database base on my household bills. And I have already the database connects to the program, but I am unable to get some of my functions to run correctly. These are the problems that I am having... 1. I am … Databases |
| | hi, i need to create a database of images. does anybody know where i can get a database of sample images? any help will be greatly appreciated, tristan |
| | I have a value E101 as my empId in my employees table and now i need to increment this value, i.e. E102, E103...etc. How can i get this to work? I've used the procedure but it's not working what am i doing wrong? ALTER PROCEDURE CalcPrimaryKey AS DECLARE @numValue int, … Databases mssql |
| | Hi there ,I am working on my web site and I need some help with my search result query's If you look here [url]http://www.sensitivetechnology.com/search.php[/url] and in the top search field enter 74AC86SC the resilt will show Product ID and Description ,but it won't show quantity and price And also I … Databases mysql |
| | [B][I]MSSQL Where Statement Problem[/I][/B] [COLOR=BLACK] [LEFT]I want to select all in a column if variable = null I am placing a php variable in there and i know how to do that so i no that is not the problem but i want a where statement to return all rows … Databases mssql |
| | Situation table1 has 2 columns: userid and requiredInfo It will have an entry for every user table2 has 2 columns: userid and optionalInfo It will have entries for some users but not others Problem: need a statement that returns either userid, table1.requiredInfo, table2.optionalInfo --if table2 has an entry OR userid, … Databases mssql |
| | PLs could somebody tell me how in MS SQL set the default value of a column as the sum of 2 columns column3=column1+column2 where column3 is bigint column1 and column2 are int column1 is primary key with identity incresed by 1 if posibble column2 is a column from another table … |
| | Hi all, I'm importing external data into Microsoft Excel XP from a database. Not wanting to query all 70 databases we have I'm thinking a macro or some visual basic would work nicely to automate this. However, I'm stuck because everything I read tells me that one cannot query multiple … Databases display dns microsoft microsoft-access visual-basic |
| | Hello guys, I have [COLOR=DarkSlateBlue]Oracle9i[/COLOR] installed in my homepc and my O.S. is [COLOR=Navy]Windowsxp-professional[/COLOR]. Now,I want to connect Vb using [COLOR=Indigo]Microsoft OLE DB Provier for oracle[/COLOR]. For this i have done the following steps--- 1. Created a text document and renamed it with extension .udl 2. On openning the file … |
| | Hello, I have a software package for monitoring warehouse transactions. I have a need to share information across many users in several different locations.I don't want to network the pc's i can't afford that. i however notice that putting the information online saves a lot of cost for me. I … Databases monitoring-software mssql |
| | I'm working with sql servre database I have two tables in the same database. thse are my tables, [code] CREATE TABLE [dbo].[Applicant] ( [UserID] [int] IDENTITY (1, 1) NOT NULL , [UserName] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails1] [varchar] (50) COLLATE Latin1_General_CI_AS NULL , [EducationDetails2] [varchar] (50) COLLATE Latin1_General_CI_AS … |
| | Hi, I have a database table which has a Field called birthday.I want to write SQL script which automatically search database every day and if someones birthday equal today then display a reminder(alert).how can I do this? can anyone help me? Thanks, aish. :o  |
| | I have asp.net C# web application I want to search jobvacancy details using jobrole. if user did not select any value I want to select all the details including null values. this Jobvacancy table has JobRole feild and it allow to insert null values, this is my stored procedure [Code] … |
| | I run MS SQL 2000, database is growing and my concern is the hard drive will soon run out of disk space. i wonder if i can add a new hard drive and tell SQL there is more space. my question is how i can combine the two hard disks … Databases hard-drive mssql sql |
 | Hi All, I'm messing around with different PHP scripts on my server. I can't seem to setup MySQL. I have installed and configured it. But I have now idea what to do with it. Is it like PHP where all you have to do is install it and its done? … Databases mysql windows-server  |
| | How would you calculate the difference between two dates? |
| | I have three tables, table1 store records which may have next level ID(child), table2 lists corresponding child ID, and table3 stores the possible message for that particular ID. table1: [CODE]------------------------------------------ ID | group | tochild ------------------------------------------ 1 A y 2 A n 3 B y 4 A y 5 A … |
| | I know it's possible, but I'm not sure how. I need several services to use one database. For instance, I need blogs,chat, and a forum to share a database so that when you sign up at one place, you are automatically signed up at all of them. |
| | In database I have three tables: t1,t2,t3 all three tables contain the same field (username) t1(username) ------- user1 user2 user3 user4 user5 t2(username) ------- user3 user4 t3(username) ------- user2 Now how can I write SELECT statment to retrieve all username from table1(t1) which is NOT included in table2(t2) and table3(t3)? … Databases mysql |
| | friends can u guide me how to get started using oracle .never used oracle before .is there any useful weblink. Databases oracle |
| | Hello New here, so don't know if doing this right, I am getting an error message that goes like this: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/www/target/geo/index.php on line 48 (here is the line in question) $count_result = mysql_num_rows($result); Warning: mysql_num_rows(): supplied argument is … Databases mysql |
| | I have three tables. table1: |-------|-----------| | Name | Studyarea | |------|-----------| | Joe | 1 | | Joe | 2 | | Chris | 1 | | Mike | 3 | |-------|----------| table2: |-----------|-----------| | Studyarea | CourseID | |-----------|-----------| | 1 | 1,2 | | 2 | 2 … Databases mysql |
 | This could be a stupid question but I’ll ask it anyways. I used “MySQL Migration Toolkit 1.0 Databases mysql |
| | Okay, another easy one, but I can't remember how to do it. I have a table that I want to be able to update multiple records in. I thought I could just run an update query, but I have 2 yes/no fields and one text field that I want to … Databases microsoft-access |
| | I am making a database that tracks the inventory of a tool room. This includes info about both shelf tools and tool box inventories. Each inventory has about 300 items in it, and there are about 9 kits. The info was already put into excel, and instead of re-typing the … Databases microsoft-access |
| | Hi everybody Hope I will get some help here. I have been using mysql database for quite sometime and had no problem till now. This database is either upgraded nor any change in the indexing, its been as it was from past one year. But recently we have observed that … Databases mysql |
| | Hi friends, I have very little knowledge of JOINs. Please, help me out in rewriting my sub-query to some kind of JOIN for earlier MySQL version TABLES IN MY DATABASE: Room (room_ no, room_ type, price) Guest (guest_ no, Fname, Sname, address) Booking (room_no, guest_no, Fname, Sname, arrival_date, departure_date, emp_no, … Databases mysql |
| | i have a very simple access DB and im tryin to update the records but the update never works. im using asp.net/vb.net and i've include the execute in a try/catch block and it always prints the sql string (the catch). here is my code, perhaps i have an error that … |
| | Hi, I have a dts package that I created which uses an odbc connection to go and copy a dbf file using visual fox pro drivers. The package runs fine when I execute it. But whenever I try to use the sql server agent to run it as a job … |
| | have a ver big problem, im new to mysql...and i been thinking of ways of solving it....but dont know how.... i have an excel list with 200 people, so what i do is convert the excel file to mysql, using a $24.90 sofware.....once i have the mysql databse i add … Databases mysql |
| | We were successful on linking the table from MS access to Oracle 10g, but we dont see any data in the MS access linked table. It shows as data #deleted. Can you please describe how we can see those datas. Databases oracle |
| | i wud like to select records which userStatus' values is sth. ive gt a tbl with a userStatus column, dis column is stored with statusID and the values in dis column, userStatus, are either numbers or nothing inside. now i wud like to retrieve the userStatus which values are sth … |
| | I have a site that my employer had designed and maintained by an outsider company. My employer is fine with the layout but doesn’t like that in order to update anything it requires a call to the designer who takes days to update. We want to be able to update … Databases first-post |
| | Take this situation: A Hospital Database containing information on over 800 employees. Which database software would you use? Is Access just as good as mysql? Databases mysql |
| | Hey there, i have a table in MySQL that is updated about every 5 minutes with about a hundred new records. For an application i am building, i only need the info from the most recent entry for each specific unit. But, i need all of the info in that … Databases mysql |
| | This sql command is for PHP but this is what happen to it after php had made chenges: [CODE]UPDATE Catalog SET Table='Harrow_VH' WHERE Name='Variable Action Harrow'[/CODE] I get this error both places php and mysql client it self: MySQL said: You have an error in your SQL syntax near 'TABLE … |
| | Hello everyone, I am new to mySQL. I want to know how to use mySQL with c#, and if there is any difference between MS SQL and mySQL. Also any links to tutorials would be great. Thanks |
| | I need a help. I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date. Does anyone have any idea how to solve this problem. |
| | Hi, Iam a MySQL user and Iam currently having some error messages in my code.I use TYPO3 as the frontend. I get these 2 warning messages [COLOR=DarkRed]Warning: Supplied argument is not a valid MySQL result resource in /var/www/typo3/lib/t3lib/class.t3lib_db.php on line 677 Warning: Cannot add header information - headers already sent … |
| | Current app runs a stored procedure which runs 16 nested procedures and takes from 3 to 10 min depending on how must data needs download from the as400. The problem is that there are some other web apps on the web serverr that use old com objects that have memory … Databases mssql |
| | Hello there, we are converting our applications from a sybase server over to MS SQL Server 2000 and have run across a query that is acceptable in sybase but not ms sql. It is giving us a table name correlation error that we can't figuire out. In sybase the sql … |
| | Hello, I have two questions, first some background info: We are running SQL 2000 on a Windows 2003 server for out aircraft parts database software. There are 7 workstations (windows 2000 and XP) that run the parts database. 4 of those workstations run really fast, the database calls are near … Databases mssql sql windows-server |
| | hi all, i want to migrate from SQLSerevr 2000 to MySQL 5.0.4. i've got a column type varchar(8000) in my source db. the reason of selecting varchar(8000) instead of text type is: we can't compare two text fields in SQLserver and i need to compare them some times. i don't … Databases mysql |
| | Please help !!! I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I … Databases mssql sql web-server |
| | Hi there, I'm using asp.net (c#) framework version 1.1 and trying to connect to my Oracle database 10G (10.1.0.2.0) which installed on the same server as the IIS and I'm getting the following error: OleDbException (0x80004005): error while trying to retrieve text for error ora 01019 I can connect through … Databases asp asp.net open-source oracle web-server |
| | hey all, i've worked with sql server 2000 before and configured the odbc driver to connect to it, using tcp/ip, named pipes, sql admin (sa), and so on....now we're starting to get involved with mysql and are trying to configure myodbc to talk to mysql so queries and tables and … Databases client-server mysql sql |
 | I am pretty good with mysql but I haven’t done much full text searching. I have this problem though with getting results. I learned how to do the fulltext searching at the mysql.com site. I plugged their exact example into my database with phpmyadmin and everything good. Then when I … |
 | i got this message plz help :: Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/baje/public_html/Templates Management/index.php on line 17 Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/baje/public_html/Templates Management/index.php on line 19 its like this plz point out session_start(); include_once('common/common.php'); // … |
The End.