[database] Forum Topics

I need your help!!!. I need to query a table in my database that has record of goods sold. I want the query to detect a particular product and also calculate the quantity sold. The product are 300 now, but it would increase in the future. Below is a sample …

I'm struggling on this on and would appreciate any help I can get. I have a huge text file which has about 4000 records. If I open the text file using Programmers File editor I can see that there are page breaks ( chr(12)) between each record. What I need …

Hi all, i have m y search setup which brings back a part number, a description and then underneath any associated manufacturers name and part number which could range from 1 to 20, my problem is i just want to populate my table if there is something there and if …

I've created a game and want to record highscores through textboxes. I've thought using an Access database may be one idea but seems quite complicated at my level of programming. I'm looking for some ideas or an alternative to using access. If not then some way i could go about …

I want to write a complex piece of coding that will do several things: 1) It will clear the contents of a folder named "Cache". 2) It will open (if not already) Mozilla Thunderbird. 3) It will find the latest email that starts with a specific title. 4) It will …

I'm using an access database to save plain textboxes. I've made a connection with the database. Now i need to find the code to add the textboxes to my database. I've tried to add with the bindingnavigator but it won't work... please help...

Hi there, I’m very new to ColdFusion and I’m still going through the learning process. I have a report to create in CF and I don’t know how to start: I have three tables in 2 databases: tblEmployeID with EMPLOYEEID, EMPNAME, MGRName (this is in SQL 2000) tblCategories with CODEID, …

Hi Every one !!! I want to know how i need to capture a duplicate value in database..For example if user enters the same E-mail which already in the database, I want to give a javascript alert or else re-direct to another page and wants to tell that "This is …

Hi all! I need some help. What I need is, to make a listbox, and fill it from a mysql database, which contains users from my website. The idea was, to select two or more users from that listbox, and after hitting a submit button, I would see the comments …

hello. i want to have a database in which i can have data of proteins and their structures .I'm New to php and have a biological background i studies . so can any one help me step by step that how can i build the database. regards Stefano [email]sa_kushi@gmail.com[/email]

In my application i have a view page(html or jsp) with five field (Qualification, Semester, Maximum Mark, Obtained Mark, Percentage). I have one add button, if i click on add button one java-script will be called and it will display a row in the same page with five column (Qualification, …

In my application i have a view page(html or jsp) with five field (Qualification, Semester, Maximum Mark, Obtained Mark, Percentage). I have one add button, if i click on add button one java-script will be called and it will display a row in the same page with five column (Qualification, …

[code] try Dim da As String = "+100acs+" Dim con As SqlConnection = New SqlConnection("Data Source=RAHUL-034890AF0\SERVER2005;Initial Catalog=user_accounts; Integrated Security =True") Dim command As Data.SqlClient.SqlCommand = New Data.SqlClient.SqlCommand("Insert into sales_details (bill_number,product_id,quantity,rate,amount) VALUES ('" + da + " ','" + Ddpproducts.SelectedItem.ToString + " ','" + Textquant.Text + "','" + Ddpproducts.SelectedValue + "','" …

Can someone explain to me how to write the VBA Code that will close another Access Application/Database? I have two Access Programs running. The first Access Program, called Main Program. It is the primary program which contains numerous tables, records, et cetera. I have created a second database, called Employees …

hi - i have coded a seacrch box and its results are displayed in a tabular form. i have also a print button which when pressed shud create a pdf based on that table that is displayed. for this i have a separate page called pdf.php. i am using ezpdf …

I am trying to search data in database at runtime.... when a user put the license no in the text box and press button this is my query but it is not working, for every search it is showing first record of the database...... Set rd = New Recordset rd.Open …

Hello everyone, Im new here. I'm not new to web design but a bit new to PHP. I really need some help with this. I have an email script that sends a bunch of user choices to me. The choices ware one or more and are sent to the email …

Pls help me , i can not run it correctly with "AddNew, Update, Update, Delete, Cxl" , i have tried many ways but no effect ? My database has 5 tables , i choose one which has 7 columns , the 7th col (name = "ID") is identity number (1/1). …

I posted this on Oracle Forums to the sound of crickets chirping. This question entails more Oracle specific tasks then java but since my code is in java, here goes" Hello, I have a java package where I am attempting to implement a database Change notification registration and listener. I …

Hey , I'm having trouble showing data from my data base in php. i always get the " No database selected " line and also i was wondering why the second echo doesn't show the result is : first echo No database selected this is my code [code] <?php require($_server["DOCUMENT_ROOT"]."/config/db_config.php"); …

Hello! I have more or less zero knowledge about coding in PHP. The most I've done is includes, to help me maintaining my sites more efficiently. I hope I will not offend anyone with this question. Anyhow, towards my issue. I have one table containing several fields, with information such …

Dear Frined my simple update statement is not working on my database software with .mdb CompanyDa.Update(CompanyDs, "DisplaycenterData") it works but only in cache, when i restart my application the record is not updated. i solved my problem with some informal steps. i m attaching vb projects zip file, plz open …

Hy, Let's say that I have class Node with some parameters Node[] child's, string id, string content ... This class is like a another storage for data from mssql database. And that web-application is running on IIS server and is written in ASP.NET C# Now when one user open that …

Hi, I can't solve this problem: I have a query which fetches the contents of the page meta tags from a database. It works fine when I have the query on page but when I turn it into a function (which is placed in my functions file) and call it …

Hello. I am using Delphi 2010 to build a small application that builds a very very simple database in CSV file format. I am using the Jcl and JVCL libraries (TJvCSVDataset, TJvDataSource and TJvDBGrid). I set up the fields ("Last Name", "First Name" and "Email"), where "Email" is the only …

I am developing a website in ASP.net 3.5 where there is a very big database. I have to show data on one single page dynamically changing from the database and that database will contain data of about 4000 pages having text and images. With formatting tags and lot of tags, …

Hi, I'm writing my first application in VB and need some help with my Access database. I have 2 problems; the first one is the most important, the second I would just be very grateful for any help/advice. Firstly, I need help updating a record from my database. I have …

I am trying to add a new record to a database using VB.net. I have used code for one table in the database which worked and then copied and pasted it and changed the column names to the ones in the other table and then I got an error saying …

Hi I'm doing a project where I need to have people register by entering a username and password. When they click register I want them to be added to the database, but I'm having trouble doing this. Can anyone help? This is my first time using VB. This is the …

Here is the thing. This code segment is supposed to add the Subject Codes for Student each time I change the Student ID from [I]jcmbDIT [/I]combo box. Initialization works well. and after I handled [I]NullPointerException[/I] subject codes are loaded into the [I]jcmbSubCode[/I] combo box correctly. [CODE]private void jcmbDITActionPerformed(java.awt.event.ActionEvent evt) { …