6,934 Topics
 | |
| | Hi guys, I am trying to create a table in SQL Server 2005 through simple query which is as follows: [CODE]create table Appointment { Doc_ID numeric(4,0) references Patient(Pat_ID), Pat_ID numeric(4,0) references Doctor(Doc_ID), _Day day, Date datetime, Consultant_Name varchar(40), primary key(Doc_ID,Pat_ID) };[/CODE] but i am getting the error: Msg 102, Level …  |
| | Please Help me to solve that i just wana to search Data feilds from SQL Database and to show on different TExtboxes of VB.net forms..... [CODE] Dim Bio As New DataSet Dim Marks As New DataSet Dim Disp As New SqlDataAdapter Dim Dispp As New SqlDataAdapter Dim Bind As New … |
 | hi all. here's my problem;. I would like to have a macro to export data from an excel file into the database(SQL) for insert and update data purposes. but i'm not sure how to do this. can anyone suggest me or give some ideas on how to make it possible? … |
| | I have 3 tables: A, B, C. How to insert 100000 rows into table B, while inserting have data is the random data are taken from Table A and C Thanks for help!!!! |
| | Hi, I have a problem with reading a csv file with SQL server UNH+ATOPHOEXEDI+AVLABL' PLD+AII+RE11S' TRV+1+40+DU03+MAN+LCA+20110706:0000:1' ACC+1+SUNNY HILL HTL APTS ?+ POOL 3*:11113+:: PAPHOS+20110706+3:3 STAR++E:1:999' PRC+A:825:3*C:0:1:15+9+5:2475:9:1BDR APT 2/4 INLAND VIEW+2:4++SC: SELF CATERING' TRV+2+40+DU03+MAN+LCA+20110706:0000:7:N:20110713:0000' ACC+2+SUNNY HILL HTL APTS ?+ POOL 3*:11113+:: PAPHOS+20110706+3:3 STAR++E:1:999' PRC+A:4900:3*C:0:1:15+9+5:14700:9:1BDR APT 2/4 INLAND VIEW+2:4++SC: SELF CATERING' . … |
 | hi everyone. i want to list and show the table names in a database in a php page. how to do that? in phpmyadmin 'show tables' works in query window. bt showing it through a php script i think i would have to SELECT?  |
| | Dear all programmers I’ve search all over Google and have not found an answer. [B]My question is.........[/B] I have two DBF tables called product and ullage. The user enters data from products table into ullage, by searching for product id and adds their count into the ullage table. This part …  |
| | Hi! I need some help. Let's say I have 3 tables (t1(id,ds), t2(id,ds) and t3(id,ds)) where the tables don't necessarily have the same id fields. For example: t1 id ds 1 1 2 0 5 7 t2 id ds 8 5 1 2 t3 id ds 9 3 8 5 … |
| | IS this Correct or Please help me to find error, i cant solve that how to see record on my form Dim Slec As New SqlDataAdapter Slec.SelectCommand = New SqlCommand("SELECT Name'=" & txtname.Text & "', CNIC#='" & txtcnic.Text & "', F_Name='" & txtfname.Text & "', College='" & txtdept.Text & "', … |
| | I am trying to connect to a sql database and read from a table to determine if a username is valid upon a user entering in theirs. To just give you a background of the program: 1. The user needs to enter in their username and ID number. I already … |
 | Hi, I have DAL class and I have done Query Parametrization to avoid SQL injection. As you can see the weakpoing for Dynamic Query is table_name and column name. I have made small function to (hopefully) validate table variable before I can add to SQL command string. Now I was … |
| | I am having a hard time figuring out how to delete a row from the datagridview using a datasource that will also delete the row in SQL Database. [CODE] public partial class Form1 : Form { const String sStr = "Server= ************;Database=***; Integrated Security=SSPI"; SqlConnection sConn; SqlDataAdapter daCourse; DataSet ds; …  |
 | Hey everyone, I'm trying to count all Purchases and find ReceiptNo the ones that start with '434'.. [CODE] Select count(p.purchaseNo) from purchase p (select INSTR(TO_CHAR(p.recceiptNo), "434") >= 10; [/CODE] But this line doesn't only select all receipt number starting with 434.. it selects all receipt no that has 434 in … |
| | is there any way to backup an sql server 2000 database using the front end (Vb6) ...... Had been it in Access itz even possible via save as dilog I ve done it but sql 2000 is a problem  |
| | Hello, it now seems that I might be able to use SQL/MS Query to do what I tried to find a [URL="http://www.daniweb.com/software-development/visual-basic-4-5-6/threads/388319"]workaround[/URL]. (Even if this works that does not invalidate the problem posed in that thread, though its urgency would be reduced.) So: is there a way to perform in … |
| | Hi, I'm having trouble finding out whether I am doing my diagram the correct way or not. These are some of the properties of the diagram. Make an ER diagram and tables of the diagram: -Classroom contains the name of the building, the building number, and the space. -Reservation contains … |
| | Hi all, I queried results form MySQL database using php and stored the results in a text file. Now i want to store the text file contents in a single string variable. I would be thankful if anyone could help me with this. Thanking you. Have a nice day. cheers, … |
| | Hi guys i hm havig problem....My Code is [CODE] <?php $conn = mssql_connect("FARHAD-PC\SQLEXPRESS","",""); mssql_select_db("Testing",$conn); $query = "select * from User1"; echo $query; ?> [/CODE] The error iss Fatal error: Call to undefined function mssql_connect() in C:\wamp\www\Testing\SqlConnection.php on line 4 Hope someone will help me.. Regards.. Farhad |
| | I'm using Visual Studio 2010, Win 7, MS Access 2010, C++, Direct ODBC, 32 bit. The first SELECT statement executes. The INSERT, SELECT, SELECT and UPDATE statements don't nay help is appreciated. Thanks. [CODE] #include <windows.h> #include <stdio.h> #include <sqlext.h> const char* DAM = "Direct ODBC"; SQLCHAR szDSN[256] = "Driver={Microsoft …  |
 | I'm struggling very hard to get this to work and I don't know what I'm doing wrong. I have a register page that I want to take the data inserted into the form and INSERT it to the database with jQuery and AJAX. I'm not very experienced with AJAX AND … |
| | Can anyone see anything wrong with this statement? [CODE] CREATE OR REPLACE VIEW V_DEPT_AMOUNT AS SELECT DEPTNO AS DNO, DNAME AS DNAME, MAX(AMOUNT) AS MAX_AMOUNT, AVG(AMOUNT) AS AVG_AMOUNT, MIN(AMOUNT) AS MIN_AMOUNT, SUM(AMOUNT) AS TOTAL_AMOUNT FROM DEPT D, EMP E, PURCHASE P WHERE D.DEPTNO = E.DEPTNO GROUP BY DNAME, DEPTNO; [/CODE] … |
| | [CODE]Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim asm As String asm = ComboBox2.Text cmdOLEDB.CommandText = "SELECT * FROM sale " cmdOLEDB.Connection = cnnOLEDB Dim ab = DateTime.Now.ToString("MM/dd/yyyy HH:mm:ss") Dim dr = cmdOLEDB.ExecuteReader Do While dr.Read v1 = dr.Item("NAME") If (asm = v1) Then pa … |
| | Hi fellow programmers! What I want to do is this... * I have a list of registered users * next to each user is a link "Add as friend" * user_1 clicks the link to add user_2 * user_2 now needs to confirm or deny the request WILL THIS TABLE … |
 | Hey guys, Alright I have a tricky assignment to do in a view that will enable my next program to run MUCH faster and more reliable... Now I need to list all Items (1 table) and their locations where they are stored (2nd table) in a way that enables 1 … |
| | I am writing a code that will login the user then one they are logged in they will enter in other information in textboxes. I wanted to know how to check that the username, password and ID match what is in a sql database. Also once it goes through how … |
| | Can anyone tell me if the following query can be done? [CODE]mysql_query("SELECT a, b, (a+b) AS c FROM table WHERE c=1");[/CODE] When I try this I get an unknown column error for c. In order to get the query to work I have had to do this [CODE]mysql_query("SELECT a, b, …  |
| | Hi all, I need to run a query that performs a count(*) on a table. This gives me the subtotals for each group. Now I need to sumarize the subtotals with sum the results given by the previous count. What would be the best way to do this? Thanks. |
| | Hi everyone! Ok, let me quickly explain what I want to achieve. I have two tables. The first table is Requests and it looks like this [CODE] +------------------------------+ | Requests | +----+-------------+-----------+ | id | user_from | user_to | +----+-------------+-----------+ | | | | | | | | | | … |
| | Dear Friends Hi I have developed VB application which uses SQL Express. When We install SQL Express it is by default set to install Service Account = Network Service. But I want to create installer which should install SQL Express 2008 (With Service Account = Local System) and along my … |
| | Can anyone help me to do this : Select previous field based on previous field in sql. I had tried a lot of ways but it seems doesn't works. [CODE]Select alert_value , year_id from company_alert where year_id = "2010" and year_id = year_id - 1 group by year_id[/CODE] could anyone … |
| | I want the post_delete column to generate unique id's so that when I want to delete a comment for e.g. I can refer to the post_delete's value. [B]Here is my users TABLE[/B] [CODE]CREATE TABLE users ( user_id INT(8) NOT NULL AUTO_INCREMENT, user_name VARCHAR(30) NOT NULL, user_pass VARCHAR(255) NOT NULL, user_email … |
| | Hi! So I managed to upload the picture via php to a folder BUT my problem now is that I want to INSERT the location path of the uploaded picture to the user's pic_location in the database and I don't know how the query will look if I want to … |
 | Can sumone please give me a helping hand here am trying to do a simple sql search were it will look all items in SQL database and pull up the names that match but am having a abit of trouble with it it brings all my accounts up regardless of …  |
| | I'm using sessions to receive my info from my database table... But I'm not quite sure how to get a image because if I just say this: [CODE]echo "<img src='" . $_SESSION['pic_location'] . "' />";[/CODE] I only get like a little black dot thingy. I don't know if one could … |
 | I am trying to install sql server 2005 express edition from the visual studio 2008 CD. This is the error I get. [CODE] [04/19/11,00:56:13] Microsoft Visual Studio 2008 Professional Edition - ENU: [2] CMSIDirectory::SetDirectory - Invalid argument ***EndOfSession***[04/19/11,00:56:13] Microsoft Visual Studio 2008 Professional Edition - ENU: [2] CMSIDirectory::SetDirectory - Invalid … |
| | I'm creating a link sharing website and I want the user that registers to upload an avatar and use that avatar throughout the website. I got so far that the user can register but can't find a way for him/her to have an avatar. Here I have the signup.php (for … |
| | So I've been figuring this out for an hour now and I can't seem to find the problem is so i have this code: [CODE]$QUERYsubject="select * from tbltablestudent where S_ID='".$myusername."'"; $subject=mysql_query($QUERYsubject) or die(mysql_error()); $QUERYgr1="Select * from ".$subject[Subject].", tbltablestudent where ".$subject[Subject].".S_ID=tbltablestudent.S_ID and tbltablestudent.S_ID='".$myusername."' and Grading_period='1st_Grading'"; $gr1=mysql_query($QUERYgr1) or die(mysql_error());[/CODE] and I am … |
 | product_edit.php [CODE] <?php $result = mysql_query("SELECT * FROM produk AS p, kategori AS k WHERE id_produk='".$_REQUEST['id']. "', p.kategori_id = k.kategori_id") or die(mysql_error()); $data = mysql_fetch_array($result); // cari syntax sql yang pas //$result_kat = mysql_query("SELECT * FROM kategori WHERE id_produk=".$_REQUEST['id']) or die(mysql_error()); //$data_kat = mysql_fetch_array($result); ?> <form method = "POST" enctype="multipart/formdata" … |
| | Hey, [CODE] CREATE OR REPLACE TRIGGER "TRI_AMOUNT_REDUCTION" AFTER INSERT ON "PURCHASE" FOR EACH ROW BEGIN IF (:NEW.CLIENTNO = 122336) THEN :NEW.AMOUNT := AMOUNT * 0.1; END IF; END; / [/CODE] I have a query that selects my top client then want to pass the clientNo to the trigger. Is it … |
| | Hi all, just wondering what the best way is to structure time in sql database. For example, at present i use this format ; 19/08/2011 (which is day/month/year). when i call this in a sql statement, it shows all results, but not in a chronological order. Can any body solve … |
| | Having a problem with my sql, I am creating program for my ALevel and when I go to create a logins page I wish to have a button that will allow me to create a new login and save it to my database. when I click the button I keep … |
| | hi all. below is my code. what i want is the financial_year_end to return only year instead of yyyy-mm-dd format. can anyone show me how can i do that? many thanks in return :) [CODE]SELECT a.stock_code, a.financial_year_end, current_name, board_name, sector_name, sub_sector_name, e.year_id, (receivable*365/revenue) AS "totaldso" FROM qiddb.company_info a LEFT JOIN … |
| | I had a problem on displaying count sql in vb. Anyone would help me? I had google about this, and I had to use executereader but I don't know how to use it [CODE]Dim dso1 As Label = CType(e.Item.FindControl("dso1"), Label) If Not IsNothing(dso1) Then Dim name As String name = … |
| | Anyone know how to install Oracle Sql developer on Mac? |
| | From where can I download sql plus 8.0? Please help as I have to submit the project tomorrow..:scared:  |
| | Hi here is the scenario. I am using Form View to insert data to the table. My table is MS sql server table of which all the columns are allow no nulls However, sometimes i need to empty values ie no value to the table column. Is it possible? |
| | Hi All, I have a table which holds the values like shown below [ICODE]ID Col-1 Col-2 Col-3 FID 1 Good Yes Easy 101 2 Bad Yes Hard 101 3 Good Yes Medium 101 4 Good No Medium 101 5 Good No Medium 101[/ICODE] I want to have a query which … |
| | |
| | Hi. I have an bounded datagridview with cell decimal different formating (N2 and N4). If I enter a 4.5265 value to a cell with N2, I formated this to appear 4.53 ... and this is wonderfull. My problem is when I try to save data ... in my sql table … |
| | I had using this code to show the alert_value in repeater. But it no output is shown in the column dso. I want to count the number of alert_value which is above than 150 which the alert id is dso. anyone can fixed it? [CODE]Dim dso1 As Label = CType(e.Item.FindControl("dso1"), …  |
The End.