6,934 Topics
 | |
| | I have several columns in each row stored with a user's information. I have put a checkbox at the end of each row and a Delete button at the at the bottom of the table. How can I check a box and simply delete the whole row from the database? … |
| | I've been trying for hours to do this and can't figure it out.. I'm trying to add a new record to a table in my local database.. Heres the SQL code im using at the minute.. I keep getting this error "The data was truncated while converting from one data … |
| | Hi again............ I have got something new that........... i was using MS Access as the database with my JAVA Japplet.... In my applet i used JTextArea to display the output ..... The output to display is fetched from the database which is connected using DSNless connection as with connection string... … |
| | hi frndz i m making a project on hospital management in cSharp n in that i have made a form of "patient registration" in that i have taken ten textbox for diff entry.... n i want to coonnect this form with patient detail table in sql in that table i … |
 | Does anybody have any ideas of how to make an advanced search function? I would like to accept a string as the search query. i want it to run a query on the string as a whole, and for each word in the query. The problem is here: The results … |
| | hello all, i am new to VB. i am trying to execute SQL Stored procedures from a macro in excel. but i fail to do so. i managed to write a code that imports a table, but not to execute a SP or a function. heres my code: [code] Sub … |
| | Hi all, still relatively new to c# and asp.net. Can anyone tell me what I'm doing wrong here: [CODE]string updateSql = "UPDATE FirstData " + "SET numplay=numplay+1 " + "WHERE PlayerNum = @PlayerNum"; SqlCommand UpdateCmd = new SqlCommand(updateSql, thisConnection); UpdateCmd.Parameters.Add("@PlayerNum", SqlDbType.Int,10, "PlayerNum"); //UpdateCmd.Parameters.Add("@numaddval", SqlDbType.Int,10, "[numplay]"); UpdateCmd.Parameters["@PlayerNum"].Value = "2"; UpdateCmd.Transaction = …  |
| | hi........ can anyone tell me the connection strings to connect JAVA JAPPLET to sql server 2005 database and also the execution of SQL statement in java thanks  |
| | Our server growth is too fast from 30GB from last month now it reaches into 50GB. Is their a problem in our database? Can this be possible to shrink this database into a minimal Size? Our server is MS SQL server 2000. |
| | hello, please help me on my updatebutton..can you please help me how to use the update statement...i want to save the changes that i made in my textfield...hoping for your positive responds...thanks in advance [CODE]Private Sub cmdupdate_Click() sql = "Update * from merchandise_table where mch_no = '" & m_mchno & … |
| | Hiya All, Not sure if i should be putting thi up on the SQL section but i think the problem lies in the PHP part of my code. This is what i've got. I'm counting the number of times a category shows up in my database returning the name of … |
| | Hi, I have [code] SessionData sdc = new SessionData(); [/code] And all the properties of sdc are stored in a table in sql server. I want to retrieve the properties of the sdc dynamically. And i know [code] sdc. reader1["xmlname"]= [/code] is a wrong way of doing it. So can … |
| | Hello .. :) Im on ma way completing my C# project,, but i have a small issue .. let me tell you what it is /// since its complicated to send the whole image to a db i only the send the image name to the database ( table ) … |
| | Hay, I had a question about a login system that i want to create. I have SQL express 2005 with value's ( business name, passwords e.d. ). This system we use to fill in what we did at the company, and how much time we spend on it. This system … |
| | Hello, I have a little issue getting what I want displayed from a single table. Basically, here is what I am trying to accomplish. I have the following type of table: Place Action B/S Qty Type City Full B 1 View City Partial B 1 View City Partial B 1 … |
| | Hi......... Can u tell me SQL query to retrieve UNICODE Strings from the database................... Specifications........ 1] Language JAVA::: a) JAVA SWING applet b) JDBC-ODBC Bridge 2] Database a) MS Access b) Datatype :: TEXT Thanks in advance  |
| | hey guys im currently working on a project for college. (USING VB) wat the form im working on does, allows the user to enter an ID of a customer and this then displays the customers details the user can then change the details however they want and update them which …  |
| | hello all, im a student and doing a project to automate a process. For which i ve to download files from clients site.. my doubt is can zip files be stored in sql database. if its possible means how can i achieve this.. need help! good day.  |
 | Hi guys , I am creating a timekeeping application to keep track of users. In my database I have a table which stores the time a user starts their break and finishes their break. I want to return the total time that the user is on break in minutes to … |
| | Hy everyone, I got a problem with doin a sum of a column where are only "int" datas, I get those data from Sql Db with a Sql Data Source and use that sds with a nested gridview. I tried with select sum() but it for each employer i get … |
| | Hello All; I would like to start off by saying hello, and that this is actually my first post to the group, even though I have been a member for many years. I am a ASP Classic Programmer, professionally for a little over a year, I have developed some rather … |
| | Hi all, I have a c# winform with a SQL Server 2005 backend. When I update my database from textboxes in the form, in one particular table all the nvarchar entries are padded with white space. This doesn't happen for other tables. All the fields that are being padded are … |
| | Hello! I'm hoping that you can help me Alter a SQL table to provide a unique constraint over 2 columns. For instance let's say I have a departments table called Dpt_tbl with two columns that I want to be unique Name Location So I want to make sure that you … |
| | Hi there, I'm havin a session with value of ID. I need to create a query for GridView to show only values linked with user mentioned in session. So my question is if theres any way how to modify my code which isnt working. [code] <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:DbConnStr … |
| | 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 … |
| | First time posing on this forum. Need some help performing simple math with date functions in C#. Having problem with defining an integers value for search end span markers. i.e. EndSearch = today BeginSearch = (today - 14 ). I have tried using DateTime like this DateTime EndSearch = new … |
| | Hi, I’m going to calculate a ratio between two entities but are having some trouble with the query. The principal is the same to, say a forum, where you say: A user gets points for every new thread. Then, calculate the ratio of points for the number of threads. Example: … |
| | Hello, I am working on a multiuser web page where people log in and do some stuf(database related) What i need is for people to register a username in the same database table that i use, and stay logged in to the page when they use the system, so that … |
| | Hi there, I'm a beginner in ASP.NET with VB and I'm stuck on problem with a SQL query. I'd like to ask you for advice what does my page or config file miss. thats how my form looks like [CODE] <form id="form1" runat="server"> <div style="margin: 0 auto; width: 180px;"> <asp:Label … |
| | I can insert into my table by the bindingnavigator and dragging textboxes straight from the DataSet entering them and saving. But I want to insert into the DataBase via code and in order to do this I have used the below code to connect. I use this code to test …  |
| | mytable1 contains the customers information (phone, address, first name, customer code, last name...) mytable2 contain the flights (charter, date, destination,customer code...) They are joined by the customer code. My goal is to print names of customers that have more than the average number of charters [CODE]SELECT cu.cus_fname, cu.cus_lname, COUNT(ch.char_trip) ch …  |
| | So, I've been trying to get a page to update items in an MS SQL database forever now, trying different methods here and there having nothing working. I finally got one method to work using a datagrid thing, and it's fine for the test table I'm using. But when it … |
| | Hello, i want to know the best practice to 1. read an XML file and store it in SQL data base and 2. modify the data base whenever the XML file modified, i created a table on data base on SQL server with columns has the same names like XML … |
| | Hello I have a rails application where I have to subtract 2 time stamps and display the result on the webpage I have used the following sql statement and I am getting the results. [CODE]select (julianday(resolutions.created_at)-julianday(tickets.created_at))*24 from tickets,resolutions[/CODE] the value of tickets.created_at is 2010-04-05 18:59:02 which is a time stamp … |
| | So my problem is : student([COLOR="red"]STUDENT_ID[/COLOR],name,surname) address([COLOR="red"]STUDENT_ID[/COLOR],city,number,state) additional_info([COLOR="red"]STUDENT_ID[/COLOR],what,why,when) [COLOR="Red"]IF STUDENT_ID IS IDENTITY , THEN THE PROBLEM IS EASILY SOLVED BY DECLARING A NEW VARIABLE WITH THE COMMAND SET SCOPE_IDENTITY , BUT IN MY CASE , ID_STUDENT IS FROM TYPE NVARCHAR, BECAUSE THE FORMAT OF THE ID SHOULD BE xxx/yyyy WHICH … |
| | I want to raise an event in C# when any one user make an insert or an update to a certain table in SQL server via my C# program. As there are multiple users using the execution file in various locations, I can not do it using the C# cord … |
| | hi i want to insert a textbox value into one column of a table. bt wht i m getting error as: Exception Details: System.Data.SqlClient.SqlException: Incorrect syntax near '{'. the code is [CODE]SqlCommand comm = new SqlCommand("insert into Sample {'email_id'} values("+ TextBox1.Text+")", conn);[/CODE] how should i do it if i dont …  |
| | Hey everyone, I friend and I are trying to work our way through this, and right are having some issues in terms of getting vb.net to connect to an online sql server. We have found lots of resources to connect to local sql servers but nothing about connecting to an …  |
| | Hello, can you help me convert MS SQL DateTime to miliseconds since 1970? Thanks, Domen |
| | DOH spelt thread name wrong... should be query! This is surely simple... this is the end of my query [CODE]where CCM0300.dbo.Device.tkModel= '72' AND CCM0300.dbo.NumPlan.DNOrPattern like '31455' OR CCM0300.dbo.NumPlan.DNOrPattern like '38600' OR CCM0300.dbo.NumPlan.DNOrPattern like '36305' OR CCM0300.dbo.NumPlan.DNOrPattern like '36805' OR CCM0300.dbo.NumPlan.DNOrPattern like '38285'[/CODE] what this is meant to do is return … |
| | Dear all, I am very new at SQL programming and are using the Microsoft Query to avoid alot of SQL programming, but I am stuck on one thing when I try to filter some data from the database... I want to show all delayed deliveries to our customers... Our Policy … |
 | Just struggling through my SQL coursework, and already fallen over the first stubling block :( My case study tells me that i need to put a foreign key from my centre table (parent) to my salesman table (child) on a 1-1 relationship. Trying to add my foreign key, which is … |
| | Hi everyone, I'm currently working on a assignment and have to write a short (max 3 lines) definition on some different kinds of queries. I've written a definition to all of them but I'm having a really hard time about one particular query: Scan Query. I've tried to look in … |
| | Hi friends, I am new to SQL.. I have a table with 200 rows and 100 columns.. I want to extract unique rows from this table such that no two row are more than 60% similar.. this 60% is a variable and would be user defined.. I have attached an … |
| | I currently have the following code on my view information page which allows the user to go to a different page to update and delete the information, which can be seen below: - Update: - [CODE]<a href=\"update_line.php?barcode=".$user["barcode"]."\">Edit Line</a>[/CODE] Delete: - [CODE]<a href=\"delete_line.php?barcode=".$user["barcode"]."\">Delete Line</a>[/CODE] I also attached the other related pages …  |
| | Hi everyone, I’m having some difficulties with a query which purpose is to give users with more than one thread (called CS) in current year a 5% point “raise”. My relational schema looks like this: Thread = ([B]threadid[/B], threadname, threadLocation) threadoffering = (threadid, season, year, user) user = ([B]name[/B], points) … |
| | |
| | Hi.I am very new to the vb.net programming. Now I am trying to connect the database that is sql server 2005 to the vb.net code so that I can add the data to my database, which is already in the sql server and retrieve the required data from the database. … |
| | Hi Everybody, Im having a bit of a problem with an assignment..Im trying to write a JDBC servlet which checks the value of a name in the database against the value inputed in a form..USER and PASS are the values inputted to the by user into the form.. The code … |
| | Hi All Can anyone help me with this problem please. I am writing a program in C# and have an access db07. The user should be able to enter a date into a text box then that date is addedd to my sql query and then return all record with … |
The End.