6,934 Topics
 | |
| | How can I create a SQL Script using MySql? I already created a database and tables. I populated the tables and wrote queries to solve the questions in my homework. But the professor want me to submit the SQL script. Can anyone help me?  |
| | Hi, Hoe to insert multiple selection from checkbox(from jsp) in to one column of the table(sql server database ). Anyone can you help me? Thanx |
| | Hi, I am using vwd 2005 & SQL Server 2000. Now I got 2 problems - 1. How to Copy the SQL Server 2000 Database on Hosting Server(What i mean is where to search SQL 2000 Database file on my local PC)? 2.What Connection String to Use (should work on … |
| | HI I am developing a part of asp.net web site as a training project. My part is creating authentication structure and authorization. Can any body please tell me are there any way to do this except using sql membership provider. Because we have to implement according to the class definitions … |
| | I am working on an Oracle homework assignment, working in shell, trying to query a tricky display question my professor has asked for. I will show both tables, and what I have to execute. [code] SQL> describe orderline Name Null? Type ----------------------------------------- -------- ---------------------------- LINENUM NOT NULL NUMBER(3) ORDERNUM NOT … |
| | hi i'm using asp.net to create an online order form. i have 4 textboxes and i want to save the information from the textboxes to my database on click of a button. dbName = BikeOrderdb txtQty, txtBikeId, txtBikeName, txtPrice [B]Can you please help me with the code for connecting textboxes … |
| | [CODE]package Add; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.apache.struts.action.Action; import org.apache.struts.action.ActionForm; import org.apache.struts.action.ActionMapping; import org.apache.struts.action.ActionForward; public class AddSuccessAction extends Action { private final static String SUCCESS = "success"; public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception { … |
| | Hello every body. I'm trying to connect my asp.net website with SQL server 2005 database. I have two copies of my site. One in File system and other one in local IIS. When I try to connect website in file system it is OK. But I am unable to connect … |
| | hi please anyone solve this issue, i had stored an image in binary format from a windows form picture box control using VC#.net, it is stored in a binary format . i don't how to retrieve this back from the database and display it in the picture box. please help … |
| | Hey, Well I go this problem, I'm using ADO.NET to manage my database on a project now the problem is that I need to get the values from an external Binding source and when I click save they will be saved in the database I'm using at that moment; for … |
| | Hi all, i am new to java servlets. i simply created a login form with username and password fields. now when i deployed it on tomcat server, after i click on submit button it gives the following error: java.sql.SQLException: Column not found codin of this login servlet is attached below. … |
| | i am creating a bank application with connection of MS ACCESS Database which is already construct a table with the following statement [CODE] Statement stmt = con.createStatement(); stmt.executeUpdate("CREATE TABLE ACCOUNT " + "(AccName VARCHAR(32), AccNum INTEGER, Deposit FLOAT, " + "Balance FLOAT, Withdraw FLOAT)"); [/CODE] So everything works fine ,the …  |
 | [CODE]Sub QryReport() On Error Resume Next Dim QryDef As QueryDef Dim str As String Set QryDef = dbase.QueryDefs("balancesheet") dbase.QueryDefs.Refresh If Err.Number = 3265 Then Set QryDef = dbase.CreateQueryDef("balancesheet") dbase.QueryDefs.Refresh End If str = "select * from [balancesheet]" & _ " where Date ='" & Dtpicker.Value & "'" QryDef.SQL = str … |
| | Hello! I need help.. please.. i'm new at php... but i need to make this: i have a database (postgreSQL) on a server... now on my webpage, i want to insert (manually-in my webpage) like with a text box, i insert there the client name (and other box's for the … |
| | I have an arraylist in which i have stored structures. Now i store the arraylist in a session and pass the it to the nextpage. I am having trouble trying to figure out how to get the strusture values out of the arraylist and store in database.....???? Anyone who knows … |
| | Hello, when i input to database show error cannot convert type varchar to type numeric.. I' m using convert(numeric, quantity). Where my quantity is empty. Please help me. Thanks  |
| | Good , I need help. I have a blank aspx page where I want to add a drop down down from a sql database and get selection of dropdwon value. Coding in Notepad & not in Visual Studio I tried this example [url]http://www.webconcerns.co.uk/asp/combo/combo.asp[/url] that uses javscript but it connect to … |
| | I am using C#.net.I want to delete a datarow from the sql server database table when the delete button is clicked.Specific row should be selected according to a text field value.Say user enters a userID to a text box...then he clicks delete button to delete the relavent row. Please help …  |
| | Hi, i have created a window service with multithreading, but getting many deadlocks on sql in one Stored procedure when i start this service,and after that service does not do anything but in idle mode. the details of exception is below. Error :Wednesday, September 23, 2009 2:22:58 AM Method:UPD_CrawlerLastUrl 1. … |
| | hi guys, done heaps of googling and everything leads me to two outcomes. 1. You can't do it 2. You can do it this way [code] INSERT INTO User(userEmailAddress, userFirstName,userLastName,userStatus,userNickName,userMifrenzPassword,userEmailPassword,userDOB) SELECT 'overthehill@gmail.com','Ben','Hill','U','benny','milk','soccer','20-10-2000' UNION ALL SELECT 'smithy@gmail.com','Tony','Smith','A','smithy','bread','rugby','20-11-1976' UNION ALL SELECT 'hotpants@gmail.com','Sarah','Jane','U','hotty','toast','netball','15-1-2000' UNION ALL SELECT 'traci@gmail.com','Traci','Hill','U','raisins','coffee','hockey','20-10-2000' UNION ALL SELECT 'lol@gmail.com','Ben','Johns','U','stubby','jam','rowing','10-2-2001' UNION ALL … |
| | Hi Friends, I am having problem with the above code snippet. Initially it woked fine. But now it is giving an error of java.sql.SQLException: ORA-01722: invalid number. How can I resolve the exception? Thanks. [code=JSP] try { String ein=(String)session.getAttribute("EIN"); System.out.println("inside try block"); Class.forName("oracle.jdbc.driver.OracleDriver"); con=DriverManager.getConnection("jdbc:oracle:thin:@10.9.16.2:1521:TESTDB","HE","HE123"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select distinct REV_OWNER … |
| | With the release of [url=http://esd.ingres.com/] Ingres Database 9.3[/url] today, the company says it's now easier for developers to migrate their application to the open source system from MySQL, Oracle,SQL Server and Sybase. It does so, the company said, through "improved accessibility of table procedures from within the query" and support … |
| | i am constantly receiving a 'failure audit' error 18456 state 14...login failed for user 'sa' on my sql 2005 server. this is occurring every 5 minutes. Can someone give me a direction on where to start? I have checked several forums on the web, but none seem to lead me … |
| | This is a problem that is killing me. It is a school assignment and I can't figure it out so any help will be great. I have eleven questions, and I have five of them answered. I have these tables with these fields: Table:sales_rep Columns:Last|First|Street|City|St|Zip_Code|Total_Commision|Commision_Rate Table:customer Columns:Last|First|Street|City|St|Zip_Code|Balance|Credit_Limit|slsrep_number Table:part Columns: Part_number|part_description|Units_on_hand|it|warehouse_number|unit_price …  |
| | [CODE]using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; namespace WebApplication5 { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { SqlConnection conn = new SqlConnection( " Server =localhost\\SqlExpress; Database= … |
| | Hello everyone. I was wondering if you could help me out. I've setup a bridge between my gaming ladders script and my vbulletin. Basically so the people registered on my forums do not have to sign up twice to use my websites features. I can manually update the database by …  |
| | Dear Friends I worked with VB.NET V 2005 In my project i have using so many sql statements (insert, update..) those working properly In newly i created form i have coded sql insert statement so when i execute it its getting error "Number of query values and destination fields are … |
| | how to install the FRx reporting server software and on which PC(SQL server PC or Application(Microsoft Dynamics PC)) and how to install on Server and how to install on client Mechines. An earlier response in this regard will be highly appreciated. Regards, Rashid Iqbal |
| | Good day.! This will be my problem regarding on how to update the listview when one of the data in the field in sql server tables has been changed.basically, i have achieved the result by looping on the table continuesly with a timer. But is there any other way to … |
| | Hi , Can we have an sql query to get the max 5 values from a column? Please paste a sample code if its possible. Thanks in advance. |
| | Hi, I have a table structure like this in mysql [code=sql]CREATE TABLE abcd ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `path` varchar(500) NOT NULL, `tag` varchar(100) DEFAULT NULL, `name` varchar(45) NOT NULL, `type` int(10) unsigned NOT NULL, PRIMARY KEY (`id`), KEY `SRCHINDEX` (`TAG`,`TYP`) USING BTREE ) [/code] How do I … |
| | How i access vs.net project using sql express 2005, From Multiple Pc. Tell me about the process in details to make access the project in a server network. Please Help me. |
 | I would like to make it so that no matter what the client enters it will match words in the database. Example: they type [url]http://awebsite.com[/url] but only awebsite.com exists it still matches it and any combination such as they search awebsite.com and [url]http://awebsite.com[/url] is in the database it matches. Here … |
| | After all the next next work, i reach the Install button and when i click on install it says "TITLE: Microsoft SQL Server 2005 Setup ------------------------------ Could not find a package to install on the installation media." How to solve this problem.. |
| | I am, as you can assume from my login that I am a SQL DBA. I have been programming since 1994 and still loving it. I came to this site as I was looking for an answer to a C# question. I didn't find it but was impressed with what …  |
| | Right away, Im fairly new to vb.net. Is there a way to have a local db cache that will use a connection string saved in settings? IE: program obviously has a central db remote computers will sync with when connected. can I save the connection string in the program settings …  |
 | Hello My Friends, I have a question... How can i add a photo/picture into SQL Server 2000....? Need advice please. |
 | I using Visual studio 2008 to connect to SQL server 2000,while I run the application there is exception,but sometime there is no exception is generating.Below I mention the exception. [COLOR="Red"]Exception Error at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, … |
| | Wondering if someone can help me. I've been working on a form in VS2003 and trying to enable text boxes on that form to accept input to populate columns in an existing SQL server. I'm trying to perform the task entirely through the IDE (is it possible?), since my C# … |
| | Hi all, I have a program that need to insert the data to the database. In the form, I have 5 textbox control which required the user to insert the data in the database. To create this, I am using the visual studios 2005 and sql server 2005 for the … |
| | Hello everyone - first time poster here, long time reader. I have a minor issue that appear to simple to fix - but I've just hit a road block. I would like to create a three way inner join to display all the information I need in one SQL statement. … |
| | Hey everyone, I'm working on something ridiculously convoluted right now and am so close to finishing, hopefully I can get some proper help here. I have my base table, as so: [CODE] -- Insert statements for procedure here CREATE TABLE #starter ( emplid char(6), acct_code char(128), div char(3), payroll_sect char(3), … |
| | Hello, I'm using NetBeans 6.7.1, and Derby 10.5.3.0. I'm trying to learn how to write Database applications, and I'm having trouble connecting to my Database. It loads the Derby Driver (EmbeddedDriver), but won't connect to the the Database named test. I looked at tests Properties in NetBeans, and it said … |
| | Hi all, I'm using the PHP code below to get results to return to an autosuggest / autocomplete. The problem is that if an earlier SQL query takes longer to return from the database than the most recent SQL query then the results of the older query will be displayed …  |
| | hi every body i want to know the way to make the sql server avaliable on my network to share the data between many computers based on same network i need to know where i start to configure the setting from sql server ? or visual studio application ? if … |
| | I want to upload or import an excel file to the local SQL Server database. My problem is that I have an x64 computer and this connection/Provider, "Provider=Mocrosoft.jet.OLEDB.4.0;" & _ "data Source=" & Server.MapPath("ExcelImport.xls") & ";" & _"Extended Properties=Excel 8.0;" does not work simply because of OLE DB thing which … |
| | Hi I want to fetch results from a given table (in this case using MySql) and put them in a array or arrayList or List<> (whatever works better). The thing is that this must be made dynamically. The idea is something like this: [CODE] aResult = functionsMysql.getArray(query); class functionsMysql { … |
| | I want to detect when connectivity with SQL Server fails, so i can fire an alert for the user. Does anyone know a bit of code that will help me detect when connectivity with the SQL Server fails (SQL Server goes down, network cable is unplugged etc). I try with: …  |
| | I'm using netbeans 6.7.1 and i'm trying to connect to the sql server 2000 database that i have created and i get this error message, SQL Exception: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host pc05801, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an … |
 | Hi all, I have an SQL Datasource: [code=asp.net]<asp:SqlDataSource ID="shownMovie" runat="server" ConnectionString="<%$ ConnectionStrings:MovieTix %>" SelectCommand="SELECT movie.title, movie.category FROM [movie],[session],[theatre],[cinema] WHERE cinema.cinemaLocation=theatre.cinemaLocation AND theatre.theatreNumber=session.theatreNumber AND session.movieID=movie.movieID AND ([movieID] = @movieID)"> <SelectParameters> <asp:ControlParameter ControlID="GridView1" Name="movieID" PropertyName="SelectedValue" Type="String" /> </SelectParameters> </asp:SqlDataSource>[/code] However, i get the following error message: Ambiguous column name 'movieID'. Basically I …  |
The End.