6,934 Topics
 | |
| | I copied book1.xls into IISServer c:/inetpup/wwwroot objConn.Open "Driver={Microsoft Excel Driver (*.xls)};DriverId=790;DBQ=" & Server.mappath("/book1.xls") &";ReadOnly= true ; UID=admin;" Dim strSQL excelfilename = "Book1.xls" strSQL = "select * from " & excelfilename Dim objRS Set objRS = Server.CreateObject ("ADODB.RecordSet") objRS.Open strSQL, objConn,3,3 When I execute the page Error Type: Microsoft OLE DB … |
| | Okay, so I have a program that deletes an entry from the database. It is linked to the program with an ADOQuery. How can I check if a record with a certain primary key exists in the database? And then it has to take that ID, and then report to …  |
| | I'm currently building a website for my friends and me, and I've decided to have the homepage use a news system. I have the page working with PHP to load articles from my MySQL Database, and that's working fine. My real issue is with the page that adds items to …  |
| | I'm a bit of a SQL newbie so I'm wondering if you can help me. I've looked on Google it for some time, but maybe I'm not using the proper terms. Here is my question: I have TableA that has the following columns: ID(PK), location, departA, departB. I would like …  |
 | I want to perform an UPDATE query but i'm getting this error:  This is my Sub in vb.net: Public Sub changeStatus() Dim Sqlstr As String Dim connectionString As String = "server=xxxx;uid=xxxx;pwd=xxxx;database=xxxx" Dim strtTime As String Dim endTime As String strtTime = DateTime.Today.ToString("yyyy/MM/dd") & " " & "06:15:00" endTime … |
| | I cannot work out how to get an integer value from a textbox from inside a datalist for a variable to insert into SQL. Here is my code. int qty = int.parse(dlProducts.Controls[0].FindControl("txtProductQty")); and this variable will be put into an insert Query. into a textbox inside a datalist id="dlProducts" <asp:TextBox …  |
| | I'm working on a database project. I avve to build a DB for medical record (hospital) but I'm not too familiar with hospital stuff. I have to come up with entity sets with their attributes, build an ER diagram and then do a Query with GUI included. What I need … |
| | I have a trigger(that prohibits the attribution of more than 10000 dollars to a worker that is not manager nor president) that i want to modify. CREATE OR REPLACE TRIGGER restrict_salary BEFORE UPDATE ON EMP FOR EACH ROW WHEN (new.sal > 10000) DECLARE job ename.job%type; BEGIN select job into job …  |
| | I'm getting this error in one of my scripts: **You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-25,25' at line 1** Below is part of the code any help would be great <?php … |
| | String query = "create table emails " + "(ID int, " + "To varchar(20), " + "From varchar(20), " + "Message varchar(50))"; this java statment looks right. but getting a syntax error. |
| | Im trying to convert a procedure from using sql plus to mysql but cannot get it to work. **SQL Plus:** CREATE OR REPLACE PROCEDURE PRC_CUS_BALANCE_UPDATE (W_IN IN NUMBER) AS W_CUS NUMBER := 0; W_TOT NUMBER := 0; BEGIN -- GET THE CUS_CODE SELECT CUS_CODE INTO W_CUS FROM INVOICE WHERE INVOICE.INV_NUMBER … |
| | Hi, I have a table and I need to write a SQL to limit the resulset set based on 2 conditions, by IP and out of that resultset, remove the rows which have nothing in 2 columns. So I have tried this but it's not producing the expected results: SELECT … |
 | I have two tables major and student majorname is the foreign key of Student table Student primary key=Reg_No I want to delete entire student record from student i used the coding like this........... Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click myConnection = New SqlConnection(connectionstring) myConnection.Open() …  |
| | When the exchCode is empty the record shouldn't be displayed. However the code below display the records. SELECT * FROM( SELECT bhCliCode, exchCode = CASE X.Which WHEN 'accSgx' THEN accSgx WHEN 'accHk' THEN accHk WHEN 'accIdx' THEN accIdx WHEN 'accUs' THEN accUs WHEN 'accSet' THEN accSet WHEN 'accPhp' THEN accPhp … |
 | Hi all, Quick one for you, designing a bit of software in VB.net for a company that inputs data into an mdb file and then uses a web service to take this data an insert into an SQL server 2008 R2 database. I know I can have to instances of … |
| | Hi i am having problems designing a solution for this problem : I have a form where you can choose the items you wish and type the quantity and then add them to a listview item. The itema are already saved in a database ( i am using sqlite ) …  |
| | ok i need help with this code i more than triple checked the spelling so i dont know what is wrong anymore and i have checked that i inserted the right data also. This is my code i use to insert into my DB when i break it i get … |
| | here is an example that if i enter id then it will retrieve data from database & print it within form fields. my database has only three column- id, name & number. here is my index.html file: <html> <head> <script> function showData(str) { if (str=="") { document.getElementById("ajax-content").innerHTML=""; return; } // … |
| | hey every one . i write a atm program and neew to read some information from sql server db . and give service to costomers . what i need . 1. read from server and check user and pass . 2. if its correct read the data and load it …  |
 | I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete … |
| | I have created a table named student including column stu_id, stu_name & Blood_group.I created a delete button to delete rows and I used the following code when delete button is pressed.I take input using jtextfield.But this can only delete by taking input in stu_id.But now i also want to delete … |
| | I used to code on MS Visual Studio 2008. It had MSSQL Server 2005 installed with it. Recently I uninstalled MS Visual Studio 2008 and installed MS Visual Studio 2010. But it didnt uninstalled MSSQL Server 2005. And MS Visual Studio 2010 installed MSSQL Server 2008. So basically I have … |
| | Hi I have two tables Employee and Job, Employee's prmary key is EID and in Job there is a EID that is a foreign key to Job. job has another column as the status of the employee. first the employee is added to the database and then the job detils …  |
| | How do you display an image in a dgv..i can display all the other info in the table, just need to know how to display an image. |
| | I've inherited a small C# command line program that takes a date and creates several spreadsheets containing data pulled from a microsoft sql server database based on that supplied date and some names hard coded into the program. I'm looking to change the program to pull the data from a …  |
| | Hello, I have the following table, for readability I broke down the after every manager for every case number. The last column is the cumulative sum of the second last column. Value for month should ideally run from 1-3 (Like you see for both the cases for Chicago). But from … |
| | Hi all, I'm pretty new here but I do have "some" knowledge of sql and PhP, I'll start by telling you what I have and then ask what I need. What I have: I have a database which holds multiple tables, the one in question is called storage.sql The table … |
| | I am having trouble figuring out how to execut the following SQL query. Say for example I have the following 2 databases. Db1 Col_1 Col_2 1 a 2 b 3 c 4 d 5 e 6 f 7 g 8 j 9 h 10 i Db2 Col_1 Col_2 1 j …  |
| | Can anyone assist me. I keep getting and error stating that the Column count doesnt match row 1. I have counted all of my fields and referenced all of them but still no dice. $con=mysql_connect($host, $username, $pass); if(!$con) { die("Could Not Connect: ".mysql_error()); } mysql_select_db($db); $CustLName=$_POST['CustLName']; $CustFName=$_POST['CustFName']; $CBR=$_POST['CBR']; $AcctNum=$_POST['AcctNum']; $CustCode=$_POST['CustCode']; …  |
| | Hallo good people, Am doing a project in which every time a delete record is done i want it to fire a trigger which then helps me capture who deleted the record and at what time this happened. All this details should be written in a flat file. Any help … |
| | Hey everyone, So I'm starting a new thread because my other thread was solved and I had forgotten it was. Anyway, I am creating a forum stite from scratch as a side project and I have a main forum page that "includes" two tables that get data from three different … |
| | Greetings, I have two tables named 'copyright' and 'logs'. Table : copyright Field : Copyr_md5 Table : logs Field : md5checksum Problem 1 Say i have a value stored in `$md5check` in php , now i want to check if the value stored in `$md5check` is found in field `Copyr_md5`.If … |
| | Please help me I got a error:Incorrect syntax near ')'. It pointed to the update_product.ExecuteNonQuery() Dim update_product As SqlCommand = New SqlCommand("Update sell Set Mode_Of_Payement(Cash)='" & TextBox9.Text & "',Payement='" & TextBox6.Text & "',Balance='" & TextBox8.Text & "', Mode_Of_Payement(Cheque)='" & TextBox9.Text & "',Cheque_No='" & TextBox4.Text & "' where Bill_No='" & txtbillno.Text … |
 | Hello dear ALL I am working with a form in vb.net which have the follwing attribute i.e BOOK TITLE(text box) , CATEGORY NAME(combo box) ,YEAR PUBLISHED(t.box) and SAVE button .the CATEGORY combo pickup data from CATEGORY TABLE on cat_name . on back end (SQL SERVER) there are two tbl i.e … |
| | i have 2 dropdownlists and a submit button when i should click the submit button the selected values shold be taken as input parametres for filtering and populating the data in gridview? |
 | I want to display table by default in ascendind order with dynamically changing header. Here is my code. It is displaying the rows unordered. It should be in ascending at first look and then can change by column. $order = (isset($_GET['sortCostCode']) && strcasecmp($_GET['sortCostCode'], 'desc') == 0) ? 'DESC' : 'ASC'; … |
| | I'm managing a server running Windows Server 2008 R2 for a client and after investigating some high memory usage, I discovered that the Windows Internal Database SQL instance is using over half of the server's RAM. Capping the instance's memory usage is easy, but unfortunately my user account (which is …  |
| | so i now how to write quies and really really easy. its alot easier than being computer programmer. but sql salary are really high and computer programer which is alot harder is lower. why is this. a phd student told me that sql job are really boring. is that true?? |
| | hi trying to get a job where i have to write sql queries. i have writen some queries but i have to do a project. that way i can show the project to other people. any ideas of a sql projects? |
| | Hi all, I had originally installed MS SQL Server 2008 R2 in my C: when I was developing the application. While I had the SQL DErver in my C:, everything was fine, no problems at all. Then I began getting low disc space messages, so I uninstalled it from my … |
| | Hey everyone, So I'm doing a project just for the heck of it. However, I'm stuck on an issue. I want to query the database to select the last comment in the answers table so I can display it on the main forum page under the specified topic. How do … |
| | i want to connect the sql dabase to vb.net form. can anyone tel me how to do it. i tired google. but it only says about ms access database. please help me |
 | Hi all, I have a very nasty issue here where SQL values are changing but I haven't been hacked because the changes are just too abnormal. People vote for their servers and every so often the top few servers values roll back. For example at 03:00 a server has 66 … |
| | Imports System.Data Imports System.Data.SqlClient Partial Class test Inherits System.Web.UI.Page Protected Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim txtName As String = TextName.Text Dim txtcomment As String = TextComment.Text Dim txtemail As String = TextEmail.Text Dim con As SqlConnection Dim cmd As SqlCommand con.ConnectionString = "SqlData Source=(LocalDB)\v11.0;AttachDbFilename=App_Data\library.mdf; Integrated … |
| | I'm trying to do, an order and some orderline. Imagine that the user come and select several item from the shop then when he click on the checkout, the reference number in the order is send back to the several item in the orderline table. How would i insert that … |
| | I need help and thank you in advance for any advice. I'm new to Php and Mysql. I've put three drop down menus in one cell of a table and I want to display results of a simple query (4 fields per record) in another cell of the table. Only …  |
| | I have two tables (points, pointsmatch) Table 'points' have following fields id (int) seriesid (int) team (varchar) points (int) id seriesid team points 1 9 Chennai 4 2 9 Delhi 0 3 9 Kolkata 0 4 9 Mumbai 0 5 9 Bangalore 0 6 9 Mohali 0 7 9 Rajasthan … |
| | hope i worded this well enough... :D trouble working out a query Table: weeklyrevenue Week Number||value 25||20 26||40 28||60 Table daily_totals Week Number||quantity 26||10 27||10 28||10 Need week 27 totals to be multiplyed by week 26 revenue not week 28 revenue as the revenue would have been generated by the …  |
| | l need to generate a dynamic PDO update query. l am not sure of the behaviour where we have the same placeholder name in th update and WHERE clause for example UPDATE users SET name = 'Master User' WHERE name = 'Dev User' As you can see placeholder name will … |
| | heloo everyone, i am new to mysql and php. here i am diplaying my data by joining 3 tables.what this query is doing 1) displaying course name 2) displaying subject name 3) displaying status if any there are three statuses (applied, accepted, rejected) what i want to display is 1) … |
The End.