6,934 Topics
 | |
| | Hello, I am quite stuck. I have my database running on a seperate machine from where I am writing my application. The connection between Visual Studio and the database seems to be fine as I can display data in various controls on the GUI. My problem arises when I try …  |
| | Hi There, I create an SQL statement to retrieve some data from DB. However I can not do the third if statement! my code; [CODE] $search = care_query(" SELECT contact_number, role, is_active FROM contact_roles WHERE contact_number='$mn' AND is_active='Y' AND role like 'S%'; "); while($row = care_fetch_array($search)) { $role= $row['role'];echo "<pre>"; … |
| | Guys! im doing a search program where in ill just search the name of the product then print it. [CODE] Private Sub txtSearch_Change() rsTransaction.Close rsTransaction.Open "select * from tblTransaction where mid$(Date,3,2) like '" & txtSearch.Text & "%'", con, 3, 2 end sub [/CODE] it is actually doing fine but i …  |
| | <?php echo '<?xml version="1.0" encoding="UTF-8"?>'; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>age.php</title> </head> <body> <?php require_once( 'output_functions.php' ); function connect_to_database( $host, $user, $password, $dbname ) { // Try to connect to database $dbconnection = mysql_connect('......', '...', '.....'); if ( ! $dbconnection ) …  |
| | This is my code. [CODE] <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Registration Page</title> </head> <body background= "bg8.jpg" width="1000" height="1000" alt="work1"> <form action="clientlogin.jsp"><table> <tr> <td> Company Name</td><td> <input type="text" name="cname" value="" /></td> </tr> <tr> <td> Password </td><td><input type="password" name="pwd" value="" /></td> </tr> <tr> <td>Location of company </td><td><input type="text" name="location" value="" /></td></tr> …  |
| | I'm looking for cool code editors for Windows 7 Ultimate 32bit. If you have any please tell me! I am using... [LIST] [*]Adobe Dreamweaver CS5 [*]Intype [*]Notepad++ [*]ConTEXT [*]Notepad 2 [/LIST] I don't really give a frogs fat aśś when it comes to how heavy the program is. Whether it …  |
| | HI All.. I want to develop a dynamic time table for a school. But the subjects and periods are not fixed ...so there can be any number of rows and columns in this which will be decided by user at runtime. when user enters number of row and columns according …  |
| | I found this script online for full DB backups but I was wondering how to change this to also set differential backups? [CODE]DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) -- filename for backup DECLARE @fileDate VARCHAR(20) -- used for file …  |
| | I am trying to write some queries and I am confused on exactly what to do. Here are my tables that reference my 3 questions. Branch ([U]branch_id[/U], branch_name, street_address, city, state, zipcode, phone, branch_manager, library_id) FK – library_id > library Library ([U]library_id[/U], library_name, street_address, city, state, zipcode, phone, manager_name) Patron … |
| | in a database for a company,what technology is best for enabling for examples certain staff memebers to make bookings/access the database from any location using a **Browser**? how do i implement this and how can i make it work? please HELP! p.s i have been researching and thinking creating a … |
| | i have code to produce a database and tables but now i am looking 4 code 2 add relationships to the tables i would have made [code] Sub Create_ALL_Tables(ByVal dbName As String) Dim sql_Area As String = "CREATE TABLE Area (Category_ID bigint IDENTITY NOT NULL," & _ "Category nvarchar(50) NULL,Area_Name …  |
| | I'm curious. I've been taught when is the proper time for XML, and when it's better to use SQL. I know what the text book says about it, what does the IT real world say about it? When would you use SQL vs. using XML? |
| | My hosting provider assigns the server name, database name, user name and password after I import/upload my SQL server database to them. When I run locally for testing it will be different. How can I effectively test and publish my site without having to change this all the time? |
| | Hi Friends, i ve a doubt in sql.. want to display all dates between 2 dates.. for example if our input are 9/2/2011 and 12/2/2011 na, the output are 10/2/2011 11/2/2011 .. i need query for this..can u clear my doubts.. |
| | Hi, For the benefit of newbies here is a list of all the topics you need to know to program a connection using VB to a SQL Server database and develop a database software. 1. Network Operating system. 2. SQL Server 2000 Installation on a Client / Server Network. 3. … |
 | Hi there, Does anybody know how to refresh a windows form after inserting into a database using a dataTableAdapter or any other method for that matter without having to close the form or use the fill method to reload the form? The problem with this is that you are taken … |
| | Hello All, I am writing my self a simple little address book application and I seem to be having some trouble with updating the dataset. I have written the code and I cant see for any reason why it shouldnt work, but during run time, when I delete an entry … |
| | Can anyone help me with this? I need for select out the posts where type_lbiltank=1 from this SQL-sentence: $query = sprintf("SELECT address, name, email, type_lbiltank, type_lbilut, type_lbilborst, type_pbilselv, type_pbilauto, lat, tlf, lng, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) …  |
| | G'day Folks. This is a general question and not a request for code. I have a client with many DTS packages on their sql server 2000. Has anyone had to migrate these buggers to sql server 2005 or 2008? Was it difficult? - After substantial googling/searching I'm not sure I … |
| | hi.. i'm having problem w/ my [COLOR="Red"]UPDATE SYNTAX [/COLOR] .. I CAN'T FIGURE OUT WHAT'S WRONG WITH MY SYNTAX.. PLEASE HELP ME.. I REALLY NEED TO FINISH THIS FOR MY DTR SYSTEM THESIS.. i can't move on to my other codes.. please... --the error that i get is.. UPDATE SYNTAX … |
| | MyTable: People who moved from Blah City, Blah State: Name Location Date Kids Jack LA 02/05/1999 0 Cindy Chicago 12/15/2005 2 Randy LA 06/19/2003 3 Jason Seattle 04/06/2002 0 1. Who moved to LA? [CODE] SELECT Name, Location FROM MyTable ORDER BY Location; [/CODE] Expected result: LA Jack, Randy What … |
 | Hi Everyone, I have a table that has a 2 column primary key. I set up the key where the 2nd column is an identity column. When I ran my VB application I discovered the ID (2nd column) did not increment the correct way. I was hoping it would increment … |
| | Hello Friends, I am new to .NET and to this forum too. I need to move approx 2K rows from an oracle to SQL server table every week. I am planning to develop a C# console application to achieve this. Any ideas how to start and what is the best … |
 | i have this code and it kinda works but not properly. i need it to look at the coloum in a datagrid and make the back colour red if over 1.6(in sql this field is saved as Varchar(10)) but at the min, i have a value of 1.5 and it … |
| | Hi! I need to be able to change the location of the database at runtime through a menu in my program. My question is how to best achieve this. If for example the ip to the server change, the user need to be able to update the database path; i.e. … |
| | Hello, I'm doing my final project and I'm thinking about creating an application that is user based.. A user can login (See their score etc) and also register if they haven't got an account yet.. I'm thinking about doing this using SQL and I haven't really done it before, other …  |
| | please I need a sql command similar to decode in oracle becuase am getting an error when i verified as an sql command. below is my code which, please help by correting the problem [CODE=SQL]SELECT dbo.Trans_Head.Doc_Date, dbo.Trans_Head.Document_No, dbo.Trans_Head.Account_Type, dbo.NewAccount.Surname + '' + dbo.NewAccount.First_Name AS Account_Holder, dbo.Trans_Details.Account_Name,SUM(NVL(DECODE(dbo.Trans_Details.Trans_type, 'DR', dbo.Trans_Details.Amount), 0)) Payemnt, … |
 | I've constructed an inventory program that relies on a database for information. Previously, I've used Access 2007, because it is easy and n00b friendly. Unfortunately, I'm not so sure Access can handle the requirements (Multiple simultaneous users over a LAN connection). So I switched to SQL Server 2005 Express. And … |
| | Hi, I have recently finished a windows desktop application for a client that connects to a sql server database. Throughout development while the server instance was on my local machine the application and server communicated fine with the connection string below [CODE] <add name="myString" connectionString="Data Source=myServerName;Initial Catalog="myDbName";Integrated Security=True" providerName="System.Data.SqlClient" /> … |
| | Hello, I'm newbie to VB.Net and thus I need an urgent help so doing this posting. I'm currently working on a project to track officers attendance time. I have several table in SQL backend. The 2 obvious tables are tblStaff which keeps all the staff's records, and the tblAttendance which … |
| | I have the following set of tables but I don't care for the design. It seems like there should be a better way of doing this. Let me explain what's going on: -A visitor comes to our website and has the option of inputting a promotional code when buying our … |
| | Hi, I tried installing MS SQL server 2008 on win 7 Ultimate x86. It was slipstreamed installation with SQL SP1. I got 7 errors during installation. All of them are showing almost similar messages (but different event ids)except the 2nd error (which was about failure to open some registry). The … |
| | Hi I am having some issues with sage pay php form integration. I have built a shopping cart that selects product information from a database and am having issues integrating it with the kit. When I test against the sage servers, everything passes except the cart contents. Is there anyone … |
| | I created JSP page containing form with two comboboxes, I need to pass the selected value from the first combobox to SQL statement used by the second combobox. Any suggestions? [CODE] <form name="subfrm" align="center" action="SaveSubscription"> Event Category: [COLOR="Red"]<select name="evnt_cat"> [/COLOR] [COLOR="red"]get the selected value[/COLOR] <option value="0">--Select Category--</option> <% try { … |
| | PLEASE I HAVE OVER TEN CLIENT COMPUTERS. AM DESIGNING AN VB.NET WITH MSSQL SERVER 2005 EXPRESS APPLICATION THAT THE CLIENT CAN CONNECT TO THE DATABASE ON A ON COMPUTER HOW DO I DO THAT.# ie vb.net + sql server network application |
| | Hi every one,Could you help me in creating one login page,in which the username and password get validate with the backend db(sql server)And the password is encrypted and stored in db.So I want to know how to encrypt the user inputting password and validate that one against the encryted password … |
| | i try to create an application that can sent the value from vb.net to SQL database.. the problem is i dont know how....i created the interface, just a simple one like inserting name, D.O.B, hobbies & phone nmber(all this using text area)...and a submit button... pleaseeeeee........... help me :'( -im … |
| | This is my app.config [CODE]<?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key="radicalGuard" value="Data Source = MICHAEL-PC\SQLEXPRESS; Initial Catalog = radicalGuardDB; Integrated Security = True" /> </appSettings> </configuration>[/CODE] And this is my connection string [CODE]SqlConnection con = new SqlConnection(ConfigurationSettings.AppSettings["radicalGuard"].ToString());[/CODE] Whenever I try to debug, it says "object reference not set to … |
| | Hi i was installing sql 2000 on win 7 but it gave a message something like "sql have compatibility issues with this version of windows". I want to use sql 2000 with vs2005. Is it possible to run sql server 2000 on win 7? If yes how can i run …  |
| | hi there i have a database called employee and in that there is a table called EmpDetails and in that there is column namely firstname awhat i want to do is to return all the first names in the database. i am using the 3 tier architecture. from the dbcommection … |
| | I am using COLDFUSION . And using coldfusion i am inserting a table using URLEncode function. For instance, the word 'Registration Fee' will be inserted into a table like 'Registration%20Fee' after encoding using URLEncode function in coldfusion.But I need to write a mssql statement to decode the word and want … |
| | Hello, I am trying to write an sql query in oracle that solves this question: [B]List top three customers from each state that has the most number of orders (4 points).[/B] Here is my query now that is just ranking every customer based on the # of orders they have … |
| | The Current loads for the below formulas are 53, 60 and 52. Below is a formula I have currently and runs properly: (SUM([Bus Duct # 1 Phase A Current Load])+ SUM([Bus Duct # 1 Phase B Current Load]) + SUM([Bus Duct # 1 Phase C Current Load])) / 3 AS … |
| | Hi Everyone! I am a beginner at VB. I have been a systems admin for some time and my new employers are forcing my hand into programming. I am currently Trying to write custom software that interfaces with our Advantage Database. I have the data source and connection opening fine. … |
| | Hello, Question: List the top 25% of employees in terms of sales. Your list should include employee number, last name, first name, total number of orders, total sales. Here is what I have so far (not sure if my inner joins or even the query is totally correct): select e.employee_no, … |
| | Hi I am having trouble trying to normalise my tables, I would really appreciate some help! So far I have: [B][U]Customer Table[/U][/B] CustId(pk) Cust Name Cust Address Cust Postcode Cust Email [B][U]Order Table [/U][/B] OrderID (pk) Order Date_Time CustID(fk) [B][U]OrderDetails[/U][/B] DetailsID(pk) Quantity OrderNo(fk) DeliveryID(fk) [B][U]Product[/U][/B] ProductID(pk) ProductType ProductDescription DetailsID(fk) PartID(fk) … |
| | Hello,I'm having problem with SQL INSERT statement In Europe we use comma instead dot for decimal number. But when I try to insert it with SQL statement I get this error: "Number of query values and destination fields are not the same." Can anyone help me with this? Thanks |
| | Hi Friends , I got a row in my table like follows date | Name | id -------------------------- 22-August | Ram | 15 14-July | Krish | 17 14_March | Anwar | 145 --------------------------- I want to sort this with date ie, 14-March 14-Jusy 22-August Using both date and month …  |
| | Hey, I have a online mysql database and it has a table with a few thousand records. Now nothing special there, my question is however. One of the fields of every row has content like this: 2 9 14 119 5 543 1479 35 90 .... <-- this field will …  |
| | Hello my friends. I've been dealing with a problem in an asp.net page that im developing. Generally I don't develop in ASP.NET i prefer desktop applications. But here is my problem, I have to create a kind of image wall (4 Faces in a 2x2 row), i'm almost done with … |
The End.