6,934 Topics
 | |
| | We are using SQL Server 2005, and saving Hindi, English, Japaneese, Chiness languages in nText column. This all we are doing using google analytical. However, we don't know how to know which value is Hindi or Englsh as they are encoded. Please suggest how to write a query to know …  |
| | Hi Sir, I was trying hard to get the image on the Crystal report when the user selects the formid from aspx form in .net. Kindly let me know how to save the image in the database by coding so that whenever I select the formid the image should display … |
| | Hey, so I have a form and i want to break down the form into 2 sections when inserting into my database. I have made 2 tables to hold my values. this is my SQL statements. [CODE] $sql_insert1 = "INSERT INTO `agent_users` (`user_name`, `password`, `primary_email`, `secondary_email`, `join_date`, `last_accessed`, `activation_code`, `first_name`, … |
 | hie if you could help me out i'll be forever grateful!! okay i am creating an ordering system but when i try to add a new customer it allos me to add but it doesnt save to the database and i can not also call it up the code i … |
| | Hi, I hava 1 error in accessing database using javabean in jsp(jsp custom actions).The error like this javax.servlet.ServletException: [Microsoft][ODBC SQL Server Driver]Connection is busy with results for another hstmt my source code is given below.Anybody help me?? [code=java]package SQLBean; import java.sql.*; import java.io.*; public class DbBean implements java.io.Serializable{ private String … |
| | So I have a bit of a problem... A la I am posting on this forum. If you will bare with me for a short narrative I can explain the situation. Currently a department in my school is involved in a Weather data collection project which they have asked me … |
| | hello please help me on the sql statement on how to display in descending order example select*from my_table......please help whats the next of it i want to display in descending order....also please give me what are the sql statement so that i can be familiar of it ..hoping for your … |
| | Hi folks, I'm developing an AI system in C# that will pull out information from the internet in various forms and learn from it. The system will consist of a multitude of agents that interact with a very large central database of knowledge. At the moment I'm at the prototyping … |
| | All, I need help in deciding what coding language would be easiest to use for a project (read below): So at work we have a scheduling system that is SQL based. The programmers already have all the code in place to parse the database into an excel sheet with columns … |
| | Beginning development with SQL Server 2008, VB - Visual Studio 2008 on an application that will deploy laptops remotely for 6 months or more. The laptops will have no network or internet connection. There is a requirement to sync DB changes via shipment of USB flash drives. The remote app … |
| | Hey Brother, I have need to create new table into new database from exist table of old database. So how I can copy that much table into other database. I have tried below code. but it give error at "IN". [CODE] SELECT * INTO dbo.pqrnew IN "NewDatabase" FROM dbo.pqr [/CODE] … |
| | OK, this may not be possible in SQL, but here goes. I'm writing an app that allows the end user to select a date range and filter by area code, but I want them to be able to select as many area codes as they want. My question is with …  |
| | i write the procedure for login in this user can give username or emailid for the login. this is my code.... please check is there any change is required for this [code=text] ALTER procedure [dbo].[users_login] (@username varchar(50),@password varchar(50), @emailid varchar(50),@ret int output) as begin select username,password,emailid from users where( username=@username … |
| | Hi everyone , i'm new in asp.. How to Insert an image in sql as binary file ,use classic ASP.. i try googling the whole day but i don't find any tutorial about this.. |
| | Hi, What all are the ways to synchronize two SQL databases? If there is a way to do it via query or code, what is that query/code? Please help. Thank you. |
| | I have a db that has a description column all descriptions are one paragraph except one needs 2 paragraphs and two hyperlinks. Can I input HTML into the one data row? |
 | please help me, give me a step by step procedure how to connect VB 6.0 and sql anywhere9.. |
| | I have a database column defined as int that contains a negative number representing a date in mmddyy format (without the leading zero) so -10209 = 01/02/2009 -122508 = 12/25/2008 How can I convert the data to a datetime so I can compare it to another date in a where … |
| | how to write a code for sql parser to parse select statements in c#. |
| | Hi Guys Could you please provide me with the code that will upload a file using C# and save it in SQL, I have searched through the internet with no luck at all Thanks in Advance |
| | Hi all, How to get tables and columns from existing sql server backup file without connect to SQL Server? Is it possible to get table names and column names form raw file like *.bak ? I would like to display the Tables & columns names which are there in backup … |
| | Split from : [url]http://www.daniweb.com/forums/thread95153.html[/url] hi iam doing leave management system&document managemet system as prjects.so, pls send me the source code and the way to present them in C# and ASP(2005) with sql server 2005. plsssssssss............ |
| | Hi guys, In my application users can search for events that fall with in a particular date range, which works fine. The problem I am having is getting records when I ask for the current months events using the query below. select * From Events Where FromDate >='1/1/2010' And ToDate … |
| | Hi All, Im new to the forum so not sure where to post my question, any help would be greatly appreciated. I have written a program in Delphi 2007 using MS SQL connection, My program runs fine on the development system but as soon as I put it on a … |
| | kindly please tell me how to connect from java to ms access, sql,oracle and so etc . with example  |
| | I am trying to update a sequence of records where the field WebSvc = No Here is the code [code] cn.Open() da = New SqlDataAdapter("SELECT * FROM dbo.DurexBOL", cn) cmdBuilder = New SqlCommandBuilder(da) da.Fill(ds, "DurexBOL") Do While ds.Tables("DurexBOL").Select("WebSvc = 'No'") ds.Tables("DurexBOL").Rows(0)("WebSvc") = "Yes" da.Update(ds, "DurexBOL") Loop Console.WriteLine("City updated successfully") cn.Close() … |
| | I tried below code... it's doesn't work as well... any got solution for this? Thanks. [CODE]using (OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"" + fileName + "\";Extended Properties=Excel 8.0;"))[/CODE] |
| | HI There, I am facing a different kind of issue, which is giving the below error, [COLOR="Red"]Microsoft OLE DB Provider for SQL Server error '80040e21' Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. /CISL/Web/Calls/BNTANT Response Time/BNTResponseTime_Graph.asp, line 246[/COLOR] The stored … |
| | Hello. I am not getting the right idea to the oracle table in the list box so can anyone please tell me how can i list the oracle sql plus table's column in the listbox. Thanks in Advance.  |
 | Yesterday [URL="http://www.daniweb.com/blogs/entry3943.html"]I reported[/URL] how the security vendor Kaspersky had allegedly fallen victim to a SQL Injection attack, with the usa.kaspersky.com website hacked and plenty of data potentially exposed. I said that Kaspersky would no doubt make an official statement sooner rather than later, and it has. Unfortunately it is one … |
| | [INDENT][B][COLOR="Red"]URGENT[/COLOR][/B][/INDENT] Hi FRIENDS, Pls help me with this. I need to display a form/dialog with any grid which contains only checkboxes in the first column and data in the other two columns. And my goal is to retrieve ONLY the data from the columns where the checkboxes are checked. pls …  |
| | I have this sql code which works fine : [CODE]sql = "select count(city) as cx from NY where CITY='New York'" set rs=conn.execute(sql) response.write(rs("cx")) [/CODE] The above counts all records with New York city. I have been trying to put this on a dynamic .asp page and modify line 1 to … |
| | I have a list box in my vb form. The list box is dynamically filled with components from my ms-access table. Now the user can select one, two or many options. For example: The list box has many softwares. 1. If user selects Windows XP and Office 2007 then those … |
| | Hi. I'm new to ASP.net and I'm having a bit of trouble with loading information in from web.config. I've stored my database connection in the web.config and the rest of the code is in my code behind file. Here is the code behind file followed by the web.config extract. The … |
| | Hello All, I apologize for what seems to be a simple thing to solve but I'm not sure why I can't get the correct result below. Here is the code and the problem: I'm using .HTACCESS to password protect a directory. I'm taking the username and storing it in a … |
| | what type of indexes exists in Sql Server ?which one is the fastest and why can we only have one of those per table ?  |
| | Hi, I need to create procedure which takes 1 variable as input. The datas are frm diff tables, I have done it using joins, Now, i need to call them thru just select statements.. is it possible, if yes, wats the way to do so...  |
| | Hello everyone I have a problem using a "search" statement in mysql, using c#, here is my code: [CODE] private void btnBuscar_Click(object sender, EventArgs e) { SearchBook(txtBuscar.Text); } private void SearchBook(string bookID) { String connStr = "Server=localhost; Port=3306; Database=biblioteca;Uid=root;Pwd= -----;"; DataTable dt = new DataTable(); const string query = "SELECT … |
| | hi guys..i had a online library management systm..i used sql DB...now i want to convert that sql to sql inbuilt DB..so that my app could run on inbuilt sql server...as now my app is not running on inbuilt servers..plz help me regarding this |
| | Hello, I've wound up with a strange problem with my php script. The script goes into a SQL DB and checks the values of two different columns to see if they are equal. If the columns are not equal, then I store all of the possible values in column 1 …  |
| | hi all, Im teaching myself webdesign, php and mysql from the fourms here and watching youtube videos. I have come across this error that I cant resolve. Its driving me crazy and i cant find a solution for it. I was hoping someone cant help. Im building a web subscription … |
| | Hey guys, I'm working on an SQLite3 wrapper using C programming. I was wondering if you know how can I set database properties such as mode, headers and echo through the C application. For example when running the SQLite shell and you are connected to the database you can do … |
| | I have an abstract class called student with an abstract method add(). I also have other classes undergraduate, graduate, parttime that extends student. Requirements are that I have to have an abstract class student and the same abstract method add(). This method needs to write to mySQL DB elements entered …  |
 | Hi I need to insert a flat text file into a SQL Server table using C#. The text file lines are 500 characters long and I will need to break it up into columns. Column 1 – 6chars, Column 2 – 1chars, Column 3 – 8chars I’ve managed to read … |
 | Hi, We are designing a windows application where we need to 'Get tables and columns from existing sql server snapshot file or backup file' . Does anybody know how it can be done. Please provide help. Thank you. |
| | hi i have created a page using JSP called Login Page containing Username & Password As its Attributes My problem is that I am not able to connect it with My SQL Database can any body help me regardind connection code  |
| | Since there is no system function for calculating the median value in a data set I was going to make a function to do the trick. I would like this function to be available to me in all my databases without having to redefine it for each. Is there a … |
| | after putting some errorts.. i managed to kick start with my project... a basic project on inventory management.... wer add,del,edit,view.. of inventory stuffs can be done... but now.. i hav sucessfully.. 1.created a table in SQL 2000 ( all the tables tat wer req for my inventory) 2. created rough … |
| | Hi, I searched all over the net for a clear solution but what solutions i have found just leave me with more questions and answered. I have a multi step form using IF statements such as: [CODE] if(isset($_POST['2'])) { echo "step2 data"; }else if(isset($_POST['3'])) { echo "step3 data with text/ … |
| | hi guys lately I've been experiencing LinqToSql + Sql Server Express 2005, and it was a great journey (muddy) anyway .... I'm at the point that I want to make a Backup/Restore for the database backup for SSE is as easy as a simple copy paste of the mdf file, … |
The End.