6,934 Topics
 | |
| | I'm a beginner on MySQL. I tried to run this statement [CODE]SELECT* FROM address WHERE email=a@abc.com[/CODE] but it shown an error message. What's wrong?  |
| | Hi, I am changing the sql database to database access (.mdb). The problem is when i run my application using sql connection its work well and all the tables are updated but when i use mdb connection it update some of the tables and few other table it does not … |
 | Hi guys, I want to create a use sql membership for my website but am recieving this error when trying to create a database 'Generating user instances in SQL server is disabled'. I have even run the command (exec sp_configure 'user instances enabled') but I still get the error. Please … |
| | I want to develop application using PHP. One module in this application displays attendance of students under particular teacher, between given two dates. The structure of tables in database - 1. student_info(Roll_No, Teacher_Id, First_Name, Last_Name) 2. attendance_info(Teacher_Id,Roll_No,Date,Present) Present stores '1' if student is present on that date and '0' if … |
| | hi. im so lost now. teying to look fro a reason for this error but come up empty. heres me problem, Im using MS access as my DB. and VB.net i have a query in my DB that uses a USER-DEFINE FUNCTION... If i open my query in the ACCESS,, …  |
| | I use following code to get all existing sql servers. [CODE] using Microsoft.SqlServer.Management.Smo; DataTable dt = SmoApplication.EnumAvailableSqlServers(false); if (dt.Rows.Count > 0) { cmb_servers.Items.Clear(); foreach (DataRow dr in dt.Rows) { cmb_servers.Items.Add(dr["Name"]); } }[/CODE] In first attempt it's not loading any servers at all but in second it is. I know it's … |
| | Hi all, I want to display excel data range from '2/1/2011 10:00:00 AM' to '2/4/2011 10:00:00 AM' using ADODB and VB6. The data result then display on the listbox but actually i get data that i don't want (date 10,22 are include). Does somebody can help me..? Here is code …  |
 | hi Everyone, My program is doing good when I suddenly bumped into this problem. I dont know how to do the next functionality that I need to accomplish. I am done with inserting values, showing the gridview etc and it works great. Now my problem is the update command. I … |
 | I have a combo box with a list of my customers, when a user selects a customer i have the customer code populate a label called LBcustomer. here is how i populate my combo box [CODE] Dim connString As String = "Data Source=" & ServerV & ";Initial Catalog=" & databaseV … |
| | Okay, So I'm currently working on my A2 computing project, and I am having slight difficulties updating and saving the data in my database when it is entered on a form in VB. I cannot find any reason why it wouldn't work, but if someone could suggest a better way … |
| | I have declared the datatyp of 'p_date' as datetime I have also used DateTextBox_CalenderExtender on textbox.(from Ajax ToolKit) [CODE] DateTime datetime=new DateTime(); datetime=convert.ToDateTime(DateTextBox.text); InsertIntoMrNo(mrNoTextBox.Text, datetime, postIdTextBox.Text); public void InsertIntoMrNo(string mrno, DateTime mrdate, string postid) { connection =ConfigurationManager.AppSettings["ConnectionString"]; sqlConnectionObj = new SqlConnection(connection); insertQuery = @"INSERT INTO mrno (mr_no,p_date,post_id) VALUES('" + mrno+"', … |
 | Hi there all. This is my first time ever in Dani web. I just began teaching myself PhP by googling. My first question ( Not sure if i am even allowed to ask in here ) is that. * When you create a php registration form in PHP enabled page, … |
| | Hello Can someone please help me with getting a better understanding of dependency theory using Armstrong's Axioms? Thank you |
| | Hi, I am working on a refined search feature and I am having a little problem with the following code. I'm trying to get the "genre" values from the form. Then use them in a query to refine the results from the database. The problem is as follows. I need …  |
| | I'm a beginner PHP programmer, so sorry if I'm asking some silly question. I've set up a MySQL database with a table carrying a list of boolean values. I want the PHP page count the number of 'true' on a column (from the table) and display it as a single … |
 | We have migrated our application from an old system (32bit) to this new 64bit server running Sql Server 2008. The code has not changed but however we are getting an error when we are trying to pull data across from our ERP system. We have upgraded the odbc drivers to … |
| | hi to all, I created following table create table book(id integer, author varchar(20)) In this, each book may have 1 or more authors. My question is that, how can insert more value to author column like as follows. id author 1 pooja merry james 2 robert stephen Thanks & regerds, … |
| | |
| | Hi to all, I created following table and its view. [blue]create table employee(id integer, name varchar(20), age integer) create view Vemployee as select id, name from employee.[/blue] now I want to rename a view, so I wrote a query like [blue]rename view Vemployee to Pemployee[/blue] But, it shows error about … |
| | ai guys need a little help here..i create an interface where user can store their information like name, hobbies, DOB and phone number...the info is stored in sql server..now i want to call back all data that have being stored in sql to excel..when i say all i mean all … |
| | I have a list of values extracted from a datareader in a list. Is it possible for me to run a query to extract another set of values using a datareader and then use the individual values in the list and the values in the datareader to perform some calculation, … |
| | 1.if there is no relation between two table. 2.if relation exist. please help. Thanks all |
| | Hi there. I was wondering if anyone could help me with this issue I am having. I wanted to create a live ajax search based on the value of the select box. The example I have obtained fromo another website and tried to have a player around. The query works … |
 | Hello peeps. I'm trying to update a sql table from mi php Ajax web page, which stores dynamically a table into the page by [icode]table.appendChild(row)[/icode], so that the user can verify the information he is inserting before the actual database update. How do I do this with ajax? |
| | Hi, I am trying to set up transactional replication on a MS SQL 2008 database that has two Schemas, both schemas have some tables with the same names. Schema A A.Customer A.Product A.Invoice Schema B B.Customer B.Product B.Incoive My first problem is actually configuring Replication on the publisher using the … |
 | Problem is based on C#, ADO.NET, using Access Database. I am trying to filter the results from the database and display them in DataGridView on click of 'button1' button. But the datagridview shows empty results when there are actually 3 records with matching conditions. According to what I know, the … |
| | Dear Freinds I face a problem that if i make a datattype in sql server of Integer and then use it in linq to sql query it give error of "specific cast not valid" and when i change datatype into varchar the linq to sql query work fine one more … |
| | I would like to retrieve the previous date (i.e., current date minus 1) and use it in a query through an = operator. I got the following query to retrieve the previous date: [icode]select DATEADD(DD, DATEDIFF(DY, 0, GETDATE()), -1)[/icode] It gives: 2011-03-14 00:00:00.000 I would like to get only: 2011-03-14, … |
| | Hi, this is probably a pretty simple question for you pro's but would appreciate some help as I have ogtten stuck. I have a html form [CODE]<html> <body> <form action="com.php" method="post"> Firstname: <input type="text" name="firstname" /> Lastname: <input type="text" name="lastname" /> Age: <input type="text" name="age" /> <input type="submit" /> </form> …  |
| | Hello, I'm having some trouble with SQL CE. The below code *should* insert a record into the 'maps' table. (table adapters all set up) sometimes it says cannot insert as breaching primary key constraint, which is fine, but it otherwise fails with cannot insert NULL into iMapId. I have checked … |
| | Hello everyone! I'm trying to get a date from SQL without the year. Every code I've seen has included the year. Here is what I have now. [CODE]SELECT * , convert(CHAR, \"date\", 10) AS ndate from dbo.MYDB where 35 > DATEDIFF(d,\"date\", GETDATE())";[/CODE] I would like ndate to be show like … |
| | I have an SQL Server Query: select *from table1 where column in ('list of values') When I execute this, I get all the details, however, when I do this: select *from table1 where column in ('list of values') and date_of_req='2011-03-15' I get an empty table. All the column headings are … |
| | i m facing problem while conencting with sql server mangemnet studio A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. … |
| | I will get an Excel 2003 file everyday via email. This file has 5 columns. The first for columns have static headers and text in them. The 5th column is the date of the report and below that is a list of values in the same column, followed by an … |
| | Hello, How to display list process, when i run sql*loader in c#. I mean when i run sql*loader from cmd windows, i get list process how many row has been inserted. But when i run SQL*Loader from C#, i can't get process SQL*Loader. This is my code: [CODE] string strCmd, … |
 | Good day i would like to ask how to make a login system the password is encrypted with the code below. [CODE]HashBytes('MD5', REVERSE(UPPER(@ID)) + @PW)[/CODE] thanks in advance |
| | Hi everyone, I am having an issue with a query i am doing for an assignment, i have made an attempt but i know i have not done it right. below is the table structures: Customer: CustomerCode,[pk] CustomerName Movie: MovieCode,[pk] Name, Rating Video: VideoCode,[pk] Name, CustomerSoldTo,[fk1] MovieCode,[fk2] What i have … |
| | Afternoon All, hope someone can help as this is really doing my head in. I have a SQL View which has a field called MOP/T which shows the number like so 28.5140299679490 349.893390000000 349.893389892905 I want to format that field so that it only shows the number before the decimal … |
| | Hi, This is a SQL statement query (so may be in the wrong forum). Any help much appreciated! I have 3 tables in an Access DB (I know!): IndexData is main table with title, description, date, fileid Category table has categories (Cat1) associated to fileid in IndexData i.e. a fileid …  |
| | I am doing a servlet program that connects to a MSACCESS database,retrieves data and redirects the user to another page. I find the following error java.sql.SQLException: General error Login.java accesses esql.java which retrieves data from MSACCESS server. PLease help!!! My Servlet code: Login.java [CODE=java] import java.io.*; import java.sql.*; import java.io.*; … |
| | Hey. I need some help with getting a record from a mysql database and compare it with data already stored in a php variable. If they don't match then I want to save the record in the database under another field and then update it. Here is my code: [CODE]$query … |
| | Hi I want to store query result in single variable like if query is "select count(*) from tablename" , and it return suppose 21 records (integer value) then I want to save this value in my database during insertion of record what should i write in place of question mark … |
| | Hi All, I can connect C# to SQL and read SQL table but i am having problem in writing the outcome to text file. I really appreciate if you could assist me. this is the code. [CODE]//====================================== using System; using System.Data; using System.Data.SqlClient; using System.IO; namespace Chapter07 { class OrdinalIndexer … |
| | I have an XLS file. Let's assume that it has 1000 rows in all, with 10 columns. I would like to import rows 5 through 995 (say), and columns 1 though 7 and 10. How can I do this using an SQL query, either though OPENROWSET or BULK INSERT? I …  |
| | Hi frnds, I`ve learned from a site that Microsoft kills LINQ to SQL. URL follows: [url]http://ayende.com/Blog/archive/2008/10/31/microsoft-kills-linq-to-sql.aspx[/url] Actually, I was planning to use LINQ to SQL in my next project. Now I`m confused!. Is it true? Regards Robins |
| | hi , can some one provide me with a tutorial in creating user group in ms sql and assigning users to that group appreciate a lot thanks |
| | i have a database, i want to make it connected in vb.. tell me the coding for editing any record.  |
| | hi guys, I am using Column properties in SQL Server 2005. I was all ready assisted with this in SQL and it works fine. Now I need to get it to work in a Visual Basic 2008 Data-Grid. I don’t necessarily need general help with “Add new data source” => … |
| | Hi, i'm trying to get something to work. I want to do a query with multiples "if not" conditions in a mysql query. This is working : SELECT * FROM table WHERE column!='value' This is not working : SELECT * FROM table WHERE column!='value' OR column2!='value' I've tried all kind … |
| | Dear all, I have using db operations such as insert,update,select,delete in my program .I have perform this operation using the prepared statement. How to avoid the sql injection in my java program.? *)I want to know functions to avoid the escape characters in java ? *)Did any one know what …  |
The End.