6,934 Topics
 | |
| | hello guys . i am new to mysql and i really dont know anything about it so i need your help in creating a database that contains two places one is the username the the 2nd one is the password .So please tell me how to do it |
| | Hello folks, I'm a little stuck and any help would be appreciated. Basically what I'm trying to do is have the user enter a pin or password, connect to a database and check whether that password is in there, if it is the program will switch to a new form. …  |
| | Can anayone help me how to retrieve the picture in Sql 2005?i need a simple a code plz help huhu,  |
| | does anyone know how to use the vb.net to connect to the SQL server to get the no of rows of a file in the server? I am a beginner of vb.net would u pls tell me the solution in detail. THANK YOU!!! |
| | Hi guys, Im running on PHP 5.3, Apache/2.2.12 (Win32 and SQL server 2008 using the sqlsrv driver 2.0. I have no problems connecting to my db instance using either Windows or server authentication as i Have enabled both. I use Windows auth for the application. I have enabled remote connections. … |
| | I have a table for projects, it has two fields for [B]project_start[/B] and[B] project_end[/B] both have datetime data type. what should i do so that when the user insert dates on both field it will automatically subtract and place the answer on the [B]duration[/B] field... please help.. oh before i … |
| | Hai Everyone.. I am new to this forum & MySQL.. I hava a table like this [code=php] iss_date item_code aa bb cc 2010-06-05 abc 10 15 15 2010-06-10 cca 20 20 20 2010-06-12 abc 12 12 12 2010-06-13 abc 13 13 17 2010-06-15 cca 18 17 24 [/code] I need … |
| | I've got some code working finally that puts the checked items from two different lists, into their respective tables - all within one form. Everything works fine except... On the second set of checkboxes, it's putting the final checked item from the array into the database twice. some kinda loop … |
| | Hi there, I have some questions regarding insert update and select queries in VS 2008. When writing select update and insert queries where should I write them. Is it in a class in visual studio or is it in the database as a stored procedure or something else. At the …  |
| | Hello So, recently I obtained a horrid assignment from lé boss, and I have yet to figure out how to do this. The idea is to select the ID(db_medlem) of all customers that have purchased for over 1000, in the year 2010. (I know its a funny syntax, but its … |
| | I have a list that passes values to an sql statement to show relevant results. I have three options (All, Option One, Option Two) and cannot get the query to work. If I choose option one or option two then the results are fine but I cannot find a way … |
| | Hello I have a Gridview that is updating and inserting information into my tables. I am using the following query to insert: [CODE] Dim InsStr = _ "IF NOT EXISTS" & _ "(SELECT [PRODUCT_NAME] FROM [PRODUCT] WHERE [PRODUCT_NAME] = '" + ProdName + "'" & _ " UNION " & … |
| | I am trying to connect to SQL SERVER 2008 using a JDBC connection. I have read some older posts on this topic(SQL server 2000, SQL server 2005) and I feel there may be some minor variations and so am posting on this forum. I am running win XP with SP … |
 | Hi, I have written a C# dll and I have a SQL Db that has three columns (username, password, role). The role element is a class of user eg admin, user; each role needs a different login completion event. The login form I am using is an ASP.net web page … |
| | Hello, I am creating a page that displays sections of a database based on ClassTypeID, and using the following as my SQL statement: [code]"SELECT * FROM Classes WHERE ClassTypeID=" & request("ClassTypeID") & ""[/code] The user will select a category from the following menu: [code] <p><a href="class.asp?ClassTypeID=1">Care Management</a> </p> <p><a href="class.asp?ClassTypeID=2">Claims/Customer … |
| | I have the following code: [CODE] Private Function BuildDataTable(ByVal fileFullPath As String, ByVal seperator As Char) As DataTable Dim myTable As New DataTable("MyTable") Dim i As Integer = 0 Dim myRow As DataRow = Nothing Dim fieldValues As String() = Nothing 'string FileToRead = Server.MapPath(fileFullPath); Dim myReader As System.IO.StreamReader = … |
| | Hi I have a doubt on creation of my sql database..can anyone please explain me.. I have two dropdownlist named department and semester... In department i have 8 branches and in Semester i have 8 semesters..If i select department and semester details regarding that branch and semester should appear like …  |
| | OK this is what I want to do: [LIST=1] [*]Log the User in by checking with a SQL Database with a table that has user name and password. Also that table is linked to another table with all there personal information [*]After they login, they have to enter information into … |
| | In my code, I loop through 3 random users, and I am trying to add 500 to their total number of credits. The variable $credits isn't being captured correctly, as it shows blank when I try to echo it. The odd part however, is $userid (primary key) is captured into … |
| | i have 3 tables student table roll no name sub table roll no subid subname markstable roll no subid marks 1)select name,subname,marks whose having marks less than 40 2)select sub name,marks whose having avg above 60% 3)select rank of each student can any one tell me the query for that |
| | i have attchhed the error in screen shot..pl guide me wats wrong in that.. thanx.. |
| | |
| | IT NOT WORKING :(( [CODE] $igletuire="INSERT INTO valoare_lucrari (id_ofertant, id_manopera, id_camera Denumire_camera, um, Cantitate, Pret_manopera, Total )VALUES( '" . $row['id_ofertant']. "', '" . $row['id_manopera'] . "', '" . $row['id_camera'] . "', '" . $row['Denumire_camera'] . "', '" . $row['um'] . "', '" . $row['Sgletuire'] . "', '" . $row['Pret_manopera'] . … |
| | Can someone please help with the following problem I am trying to update a sql database through a command builder but I keep getting an sql exception (Additional information: System error.). I dont know where I am going wrong because I thought the command builder should carry out the update … |
| | How to upload file in sql server through asp.net pages using c# can any one help me i have tried lots of method but not succeed?????????????????? |
| | Hello, I am trying to insert an html document into a modal window based on the results of a database query using plone/tal and jquery. What I need is for the "href records/rpc*_url" to be a link to the html document of the same name as the query result. i.e. … |
| | Hi all. I am working on a small credit/debt management tool. I have a table that contains the main record for the debt: id, amount, client info, interest, paid back, etc Then I also have a "history" table where all operations on a debt are stored: when it was first … |
| | hi, I need to update my data in two tables simultaneously,for example if i update product id in one aspx page it should be updated in my sql tables where i use product id in all my pages we can join tables to view data but how to update.. hope … |
| | Question: I just recently had a cut over for a web application using a SQL DB that was previously using xp_sendmail to dispatch messages to the users. In accordance with the cut over, xp_sendmail is no longer usable in Server 2005 and should be replaced with sp_send_dbmail. Previously, the emails … |
| | Does anybody know if MS SQL Server has any built in functionality for preventing injection attacks? I remember I saw someone said SQL Server does have it. But I can't find it in a official source. So, If you know anything, please share it. Thank you very much.(an official link … |
 | hi! please help am still new on ASP and am having trouble deleting from a table please help. the code i used is this: [code=asp] <% set conn=Server.CreateObject("ADODB.Connection") conn.Open "Provider=SQLNCLI;Server=THABO-2A88C6501\SQLEXPRESS;Database=customers;User ID=sa;Password=thabo;" set rs=Server.CreateObject("ADODB.recordset") if request("Delete")="Delete" then sql="DELETE * FROM Details WHERE Cust_ID='4567'" end if%> <center><form method="post" action="Delete.asp"> <input type="submit" name="Delete" … |
| | Yesterday I converted my site over to MS SQL and now I'm having an issue with part of my site. The search box is supposed to check for a part number the user types in, but it doesn't even come close anymore. In Access the column searched was a Number … |
| | I'm hoping someone can help me here. I have 2 tables in a access database. I'm trying to join certain data points from both, simple. I've done a few joins already for this site. But the problem I'm having is this one seems to be destined to annoy me. [code]sql … |
| | I have 3 computers connected to each other, pc1 is the server while pc2 and pc3 are clients. I created a windows application using c# and MS sql server as database at pc2 where in the sql server was installed, anyway, i didn't installed sql at pc1 server coz of … |
| | HELLO ........... i want to do a flash movie that if i select a city it gives book dealers list from my SQL database i have no idea to solve this i can do the flash thing and c# and sql thins i don't know how to connect those things … |
| | Hi, I'm a recent IT graduate, I want to upgrade my skills from what I learnt at college to the SQL Server 2008 platform. I want to also get certified with Microsoft, it seems a lot of companies are asking for this now. If you have gone through the certification … |
| | |
| | Can u pls help me solve this problem iam using vb6.0 and sql 2000. when i insert the currnt date (as Now()) in the dbase with a colunm datatype date/time, it inserts the date 01/01/1900. In MSAccess it works by putting a # b4 and after the date e.g. #25/06/2010# … |
| | Hi, Can anyone please help me in this. i want to retrieve a view in VB.i was able to do with the below script when using tables,but not with view [code] Dim strSQL_revenue As String Set rs_revenue = New ADODB.Recordset strSQL_revenue = " select * from dbo.PLAN_PNL_INTERUNIT_REV" With rs_revenue .Source … |
| | sql 2000 i have this sql stored procedure i want the last coloumn fAcc_Total to be updated when a record is inserted. the value in the [COLOR="Red"]fBill_Amount[/COLOR] should be add to the value of the [COLOR="Red"]fAcc_Total[/COLOR] in the same time the record is inserted if there is a value in … |
| | basically i have a table which has different branch names recorded in the same column as other data. I cannot change how the data comes in so i have to find a way of extracting and matching data from this column. eg +---------+---------------------+------+------------+--------+ | Company | Branch | Tml | … |
 | Yoe guys, need your help.. I want to know on how to setup my client computers and the server so they can connect to sql server 2005 Developer Edition. Client computers are Windows XP. Server is Windows Xp installed with a SQL Server 2005. They are on the same Workgroup. …  |
| | |
| | Hello, my code is below: [CODE] private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'sampleDataSet.contact_Query' table. You can move, or remove it, as needed. //this.contact_QueryTableAdapter.Fill(this.sampleDataSet.contact_Query); OleDbConnection aConnection = new OleDbConnection(dbconnection); OleDbCommand aCommand = new OleDbCommand("select id, name, mobile_num, date_created from contact … |
| | Hello All, Pl help me out, I'm having one web URL when i'm passing some parameters onto that it is returning a XML data file Now i want to save that data into my SQL server 2008 database. Prat |
| | hi can any 1 write code for me to check wether the ur already exists in sql database using c#.net |
| | I have a sqlite database and want to update the sort column in my table. e.g. Col1 - Col2 C - 4 A - 3 B - 5 I want to sort on col1 then update Col2 with new values i.e. 1-3 Don't know if it's possible but doing it … |
| | I'm trying to create login form in C#. I store username and password in SqlServer 2008 express using the stored procedure [CODE]ALTER procedure [dbo].[InsertNewUser] ( @UserName varchar(30), @Password varchar(30) ) as If exists(Select 'True' from Users where UserName = @UserName) begin --This means that the user name is taken select … |
| | Private Sub btnOk_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOk.Click If txtuser.Text = "" Then MsgBox("Please Enter a Username or Password, DOnt leave it blank", MsgBoxStyle.Exclamation, "Access Error") ElseIf txtPass.Text = "" Then MsgBox("Please Enter a Username or Password, DOnt leave it blank", MsgBoxStyle.Exclamation, "Access Error") Else End … |
 | I'm making some sort of mistake in the following code: [CODE]use xPress_CR select * from (SELECT * FROM dbo.T_JOBS WHERE ENDDATEANDTIME = null UNION SELECT * FROM dbo.T_JOBS WHERE STATUS = 'Failed')[/CODE] Any idea what I'm doing wrong? |
The End.