Databases Forum

LOL - I figured it out - but thanks for looking :)

I want to automate the file transfer from a remote site to my pc over a WAN. Can anyone please suggest an industry standard secure file transfer tool for a windows environment? I am looking for an industry accepted, more secure than traditional FTP. Thanks!

I am currently designing the product/product variation tables for my e-commerce site. my tables so far are as follows (ive taken columns that arent related to the problem out). PRODUCT(prod_id*, name, desc, price) //product details VARIATION(var_id*, name) //colour, weight, strength etc VARIATIONS(vars_id*, name) //blue, green, 100g, 200g, 5x etc. PRODUCT_VARIATION(prod_var_id*, …

Hello I am really new at this and are having trouble with MySQL updating .php files in the database program I am using. This used to work until I changed some of the .php file. I only changed the front end of these files and cannot see why what used …

Hi all, I want to add a string and a character to two columns of a sql database table. To do that I use a Command object rather to use the same connection on different functions. At the same time used a stored procedure to add data. Hear are some …

I have a standard SELECT query as follows: [code=MySQL]SELECT eid, title, content, thumb_image FROM diary ORDER BY eid DESC LIMIT 3[/code] ...and a SELECT SUBTRING query as follows: [code=MySQL]SELECT SUBSTRING(content, 1, 200) FROM diary[/code] I'd like to combine the two so that it selects the latest 3 entries in the …

Hello all, i have recently finished work on a clients database. they now wish for one field in the database to have 10% taken off for each record. can this be performed soley through an SQL statement on the MYSQL database.

Hi guys and gals Just curious to know if it's possible to select the 3 latest entries in a table. Would be an added bonus to my project. ;)

Hi there What I'd like to do is store a paragraph in a column and pull roughly the first 200 characters of the paragraph and display them on a page as a snippet. Is this possible? If so could someone give me a link or code snippet on how to …

hey all, i have a project so i wana design a database using ER model but i need an idea fopr this database..i want a new one i mean not consumed idea and creative.

Im trying to figure out a way to access a row I 'just created' via the primary key. As it being a primary key it is auto incremented. I am using php/mysql to create the row then I require to access that same row (via the primary key) to be …

i wanted to restrict the national holidays in validation rule (msaccess),i could restict one holiday ex:-15-aug every year by applying ([hdate])<>15 and month([hdate])<>"aug" but when i tried to enter two holidays ex:-([hdate])<>15 and month([hdate])<>"aug" AND([hdate])<>26 and month([hdate])<>"jan",it did not work.Help please. pramoda

Hello Daniweb Community, I wish to use a microsoft access database for my website. I want it to do the following: 1. work as a login script 2. work as the points script I wish for users to log in using microsoft access - can I get a script for …

I've created my own forum and would like to display username - from users table title - form topics table and a count of comments - from replies table I 've got the first bit sorted ok SELECT username, title FROM users, topics WHERE users.userid = topics.userid ORDER BY RAND() …

I am actually new to schema designing. I have read few articles about data modeling and started building schemas for real time data. I have done one. I need guidance in my first steps. Just some one who can have a glance at it and can suggest mistakes that I …

haw can i make tree in access please with sample

I have a customer with a small accounting/invoice software program (order pro). Not very fancy at all. At any rate, the software stores all of the invoice data in one ".XDB" file. Anyone have any idea what type of database this could be? It seems like the application is an …

Hi, I'm trying to load a plain archive (txt) to an Oracle table with SQL Loader, but we are having problems when the field is a Date + time. Only Date gets saved into the field of the table, ignoring the time included. When creating the archive the date + …

Hi new to the forum. I hope there is someone that can help me. I need to retrive some data from a table in sql server. The data is going to be used in an import to some other tool. The problem i have is as follow. I want to …

Hii guys, Here v can discuss about Problems in database design. If u know the answers , plese post ur answers here. How do u get the distinct rows in a table/resultset? How do u get the distinct rows without using the keyword DISTINCT?

Ok, ran into some problems in one of the newsgroups so thought here would be an excellent place to turn. Actually have only posted once or twice here and was real surprised at the pleasantness of the answers. So. You have [B]bOrders [/B]and [B]bUser [/B]listed respectivly below. In the simplest …

i have three table 1st viewleave 2nd applyleave 3rd personal based on the leaveid in viewleavetable i wnt to fetch the spid in the second table,based on the spid i want to select spid email address........please tell how to do tat.. CREATE TABLE `viewleave` ( `leaveid` varchar(25) NOT NULL, `message` …

Hello, hope all people around will be fine and enjoying programming. I want to do get data from the database which is available on internet domain while my application is window base application. Is there any complete method i can get data from the database.

Hey everyone, This problem I've been working with has got me stumped. Let me show you the table layout first. ID_NUM int, SEQ_NUM int, ATTRIBUTE_CODE char(2), ATTRIBUTE_DEF char(50), JOB_TIME datetime This table contains a list of activities individuals like and there is no way of knowing which one they like …

Hey everyone, I'm attempting to delete records within my database but I'm having problems writing the query. What I need to do is delete records from my database that, within a field in this record, have a substring that I will pass to the mysql command. So for example, A …

Hi, I'm having a having a hard time trying to insert some data into a mysql DB, so I'd like to know if there is some kind of error log that could help me. I've already looked into the binary log but it didn't help me. I also started mysql …

Data Management Software makes it possible at organizations to make sure that the principal data of company are precise and formed firmly then leaves this information with the trade partners. It makes sure that the processes, policies and the necessary procedures are set up so that the advantages gained are …

i have a column "discription" in my item table that is full of HTML code. It was created using and editor like the one i am using here. It is five pages long when i print it out. I need to update the column in all records of the table. …

when i run this query ...... update item set description=(select description from item where itemid=5384); i get this error message... Msg 279, Level 16, State 3, Line 1 The text, ntext, and image data types are invalid in this subquery or aggregate expression. there is a lot of text in …

Hi guys. I have a program which needs to store some user profile data. I want to use a database to do this, but i've never worked with databases. I was wondering if anyone can help me with it. My program is written in the java programming language, and i …

hi :) any comments appreciated about my site [url]http://extendedprocedure.com/[/url]

hi guys, i'm doin a prjct in which i've used oracle9i @ backend n jsp @frontend.can u tell me how do i retrieve the data back from the database to the jsp.i've successfully inserted d values but i'm clueless as to how to get it back in the proper order.:sad:

I am unclear how to write a query where I want all the entries in a specific month and date format from a MySQL table. I am not using DATE_FORMAT() with a NOW() correctly. I need to write a query that has a time field in the yyyy-mm-dd format to …

I am working on an ASP.net 2.0 application written in C#, pulling data from an Oracle 10g database on a remote server (i.e. the application and database are on different servers). The data is pulled via a SqlDataSource control. When I run small, quick queries, everything works fine, but when …

probably, all of you have seen this scenario a lot when entering customerID into a large database it takes AGES to bring back one simple record of a single customer === let's say, this has been DONE already , for tuning performance separate the CUSTOMERS table into 2 TBLcustomer1 -- …

Hi. I am fairly new to mysql, so help is appreciated. I have two tables and I wish to count some results from two tables and combine them onto one row, and then join an ID to another table. The problem is as follows: Table A: This lists information of …

hi ! i m new to IT.i want to know ,how the data from a mysql database can be sent to excel sheet...............kindly help me..............thanks

i need help in drawing ER diagrams for the database tables of our company website ([url]www.gtcareer.com[/url]) Tables along with their fields of the gtcareer website 1)user_login userid (pk) pwd 2)user_details userid (fk) email address city state country pincode contactno 3) user_compdetails userid (fk ) totalexp annualsal currentfunarea industrytype keyskills academic_qualification …

hi I need some help in my research it is about the query processing I need some help to get some information about it I have already search at Google and didn't found a lot of information please help me

Hi guys, I'm in a real spot of bother and this is really beginning to get me down. Basically, I need to program a class which will connect to a MSAccess database. I'm using Visual Studio 2005 and C#. I'm really at a loss for what to do. I've looked …

I've a table named [transaction] [B]idtransaction [/B] is my primary key ---------------- [transaction] ------------------------- idtransaction | customerID | amount | transDate [B]Amount[/B] is the credit or debit / they differ when amount < 0 it is credit and when amount > 0 it's debit Sample Data idtransaction | customerID | …

Hi everybody, I am Hugo . I want to know something more about SQL. please can anybody give me some idea about some basic SQl questions? First of all i want to know, 1.What is the SQL Data Manipulation Language(DML)? 2.What is the SQL Data Defenition Language(DDL)?

Hello DBA, Can any one help me this? The table TEST contains CNAME CNO EXTRA ------------------------------ ---------- ---------- bijaya 645896 mantri 525896 mantri12 525126 testing for null My requirement is to find the column which contains all the rows null(null column) I have created the following procedure to accomplish this …

I want to put together a set of packages to help in unit testing PL/SQL code - does anyone know of any software ( commercial or not ) or books which I could look at for some inspiration. Thanks Nige

Hi I would really appreciate some assistance on the following as I suck a bit when it comes to joins i have 3 tables consultants,points,orders all tables have the column id_number I need to run a query that will give me a list of all the consultants with a total …

what is the best way to design a room hotel resveration system is it by crating entites : reservation( room_id, start_date, end date) or by creating entites : calender( calender_id, date), reservation(reservation_id, room_id, client_id) bookedates(reservation_id, calender_id) where to store dates of reservation ps : it will be an onlnie reservation …

I made a query that joins 3 tables. Products, parts, and sales invoice tables. The thing is, the common key between the 3 tables is the sales invoice number, but when I try to execute the the query it displays duplicates. One example is when I make a query on …

Hi everyone I'm looking for advice on building up a database. Any sort of general do's and don't s. The one and only thing that I realize is that putting ALL my info into one table is not a good thing. This is the first database I'll be creating so …

Hi all, I'm not sure how to phrase this question... I have a table that requires a foreign key of anything table - this foreign key is automatically generated and the key field in the 'foreign' table. So I have the following situation (kind of): Table Observation [INDENT][B]Time_Stamp[/B] - [I]primary …

Recently had to re-install all of pc...not a prob as all (except db) was backed up to seperate hd. I develop locally using MSSQL client tools and adp's and then upload new tables as and when ready. I had done quite a bit of work when pc died, and now …