6,934 Topics
 | |
 | In sql server 2008, i have a store procedure which has insert statement , now i want to insert multiple records at a time into table via EXEC. MY Store Procedure: insert into tblUser(fullname, email, loginID, password, DOB, question, answers,doc,roleid) values (@fullname,@email,@loginID,HASHBYTES('sha512',@password),@dob,@question, @answers, GETDATE(),@roleid ) Now how to insert multiple … |
| | i have this page in hard form and i need to make a table for it in DataBase (Sql Serber 2008), i tried alot but couldn't find any way to make table for it in data base. + i have also user table in DB, so userid should b also … |
 | Hi daniwebians I have created a table in sql server called "report" and it has 3 columns "reportname","reportfile" and "reportflag". the report flag has only two values 1 and 0,if the value is 1 this means the textbox on the form will be enable. I have managed to dispaly the … |
| | Hi All, I have a samll problem related to a specific query. It creates following error. **Unknown column 'attendance_state.state' in 'field list'** $query="SELECT attendance_state.state,attendance_state.state_id from attendance_state inner join attendance on attendance_state.state_id=attendance.state_id where attendance.admission_no='".$admission_id[$i]."' and attendance.date='$date'"; $result=mysql_query($query) or die (mysql_error()); The table related to the query looks like this. "state_id" is … |
| | Hi guys I'm Indrajeet Roy, and I have a problem with a piece of code I am trying write in VB.net. I am using Visual Studio 2010 as my IDE. The basic idea behind the form and the coding I am trying to do is to create a username, password …  |
| | Hey Everyone, I am using the below query to try and group together values by the month of the date selected. the problem is that sometimes CTE2 will not have the same dates as CTE and those values end up omitted. Is there anyway I can just group these on … |
| |  |
| | I used the upsize wizard in Access 2010 to split my database with the table being on the SQL server. I entered this in the autoexec (was macro, I converted it) Function autoexec() oConn.Open "Driver={SQL Server};Server=JCPLMSQL01;Database=TestingConnection;Trusted_Connection=yes;" DoCmd.OpenForm "Form1", acNormal, "", "", , acNormal autoexec_Exit: Exit Function End Function I don't …  |
| | Hello, I'm sorry I bumped old and solved article, so I'm opening new. The problem is here: http://www.daniweb.com/web-development/php/threads/419063/updating-single-record-in-mysql-table-with-php-using-toggle-button This works fine, except that I have to click button two times the first time to change the status. later itr works fine. Anyone knows how to fix that? Thank You! |
 | Hi there, I've lost my password and username and am trying to log in using sysdba. It doesn't log me in and I would like to retrieve my username and password without re-installing the software. IS there a way of doing that?> |
| | I am fairly new to asp.net, I am trying to connect to a sql (mysql prefferably) database, it must be using C#. I have been searching all of yesterday and today, I cant figure out how. Could someone help me here (if this has been asked, please point me to … |
| | I have read many articles here, but haven't quite found the solution. I have a SQLEXPRESS database that is used by my VB.NET application. I have packaged and deployed the application via an MSI file and everything works great except I cannot figure out how to include my database file … |
 | i have writeen following query in my code. $tquery="SELECT questions.id,questions.date,questions.title,users.user_name,subjects.subject FROM questions INNER JOIN users ON questions.student_id=users.id INNER JOIN topics ON questions.topic_id=topics.id INNER JOIN subjects ON topics.subject_id=subjects.id WHERE subjects.id=".$_SESSION['sub1']." OR subjects.id=".$_SESSION['sub2'].";"; but when i am trying to echoing its result it is not displaying anything. |
| | Hi All, Ever tried to make a change to a SQL database table only to get a message telling you it is unable to carry out the change as it would have to drop and recreate the table? This is one of these things that you encounter once, correct and …  |
| | Friends, I am making Consultantwise patient report application using VB.NET 2005/08, SQL Server 2005/08. this application i am making for reporting purpose only. I have taken 2 datetimepicker(from date & to date) and one listbox to select the consultant name on my .net form. but i am confused where i … |
 | I'm trying to write a simple sqlite query in c++ using visual studio 2010. My problem is that i can't use a c++ variable inside that query. I was not able to find the right syntax. `sqlite3_prepare_v2(handler, "SELECT * FROM grammateas WHERE username==X;", -1, &statement, 0);` where X i would … |
 | I am not new to OOP I am tidying up a very large site of mine and trying to create a much better structure (more in keeping with the whole point of OOP). I have decided to use mysqli (please don't suggest PDO as I have decided againast it) which … |
| | hi! can anyone help me in creating an vb.net code.? i have an textbox, dropdownlist connected to the database and a submit button. my problem is , i don't know how to connect the 3 of them and the output will be seen on my database,.. thanks..  |
 | Hi all, I have a .NET form where I want to connect to a table and then pass each defined (by query) string from the table into a string within the code. I have created a connection to the database already via Data Sources but I'm unsure about the syntax … |
| | I have looked into Cast and Convert, but I cannot find a way to do this. I need to convert four digits into an hour format. For instance, 0800 would become 8:00 or 1530 would become 15:30. I cannot use functions, I'm using a special form of SQL. Any suggestions? … |
| | Hey everyone, I am looking to write a query that I think can be solved a nested select but I am not yet that fluent in MySQL to be able to get the query working correctly. Basically what I want to do is this; SELECT count(*) from Inquiry Inner Join … |
| | Dear experts, I have to contnous transfer data from one sql server to another sql server , but condition is that first sql (database used and inserted by another application) should maintain 3 month data at any time and anohter sql will store all the data transfer from first sql. …  |
 | -->>Hi,I'm having an Access database (.mdb) with Members table and column Date registered just for an Example with datatype as text. -->>Now I have an Interface that I need to use it to get all registered members within the specified range of dates by using the Datepickers (1. Is for … |
| | $pdf->Table('select @N:=@N+1 AS no, A.department as "DEPARTMENT", A.no as "ASSET NUMBER" , A.total as "ASSET TOTAL PRICE" , B.no as "INVENTORY NUMBER" , B.total as "INVENTORY TOTAL PRICE" from (select h.department , coalesce(count(h.id),0) as no,coalesce(sum(h.price),0) as total from asset h where h.department = "'.$department.'" and year(h.date_accepted) = '.$year.' GROUP BY … |
| | hi all .... I have a problem in window application ..... the problem is that i have completed my project on lab management system(LMS) and now i want to create set up of LMS simply i created the set up but its not working for sql server ......So please if … |
| | <?php $con = mysql_connect("localhost","root","12345"); if (!$con) { die('Could not connect: ' . mysql_error()); } echo "connection made"; if(isset($_POST['nw_update'])){ echo("You clicked nw_update!"); } else { echo" dhur"; } ?> <html> <body> <form action="<?php echo $_SERVER(PHP_SELF); ?>" method="POST" > <input type="button" id="nw_update" value="NW_Update"/> </form> </body> </html> In the above code when the … |
 | Dear All ! I have a table titled Customer_DETAIL I want to check and make sure That there are no other records in the table that have The same CustomerID . The CustomerID are FK's From customer table. How can I check for duplicates so they do not create duplicate …  |
| | Hello, I have 3 tables, user, role and userrole. Userrole stores user_id and role_id, so every user is associated with some role(s). So, when i use this query to view all users, and if user has several roles, i can see several rows with identical info and just role column … |
| | i have record saved in access database. with few fields, like item,rate,qty,total, p_date. i need to generate report of system date record only. suggest me that this sql statement will work or not, select*from table1 where p_date=date$;  |
| | i have a signup form on my website for user registeration ....... so i want to make it secure , by secure i mean , Password should be encrypted etc etc.....or any other precautions for security i already used hash functions of MS SQL on password field through queries but … |
| | I have a small program that works when I hit start. I want to add two fields. One being a hard coded username and another taking the timer (after it has stopped) and recording it to a table in SQL. I'll have two tables. One called "username" and another called …  |
| | All, I can't seem to find a good example of how to work with databases in C#. I'm using sqlserver and I can do simple things like insert and retrieve data, but when I am retrieving data I have to refer to the ordinal index values of the columns (reader[0], … |
 | Hi everyone, Trying to do a subquery to select the minimum price from table1, table what holds 15 million rows. I think that my approach is not the most suitable way of doing this. I want to select after oen_norm because oen_norm may have 1-10 rows per entry, but I … |
| | hai I want to know the particular field name using search the full word in mysql database and that field name using we want to retrieve the entire table in mysql database.... Next I want to know can we retrieve the php with mysql database in PDF report in front … |
 | hello,, i have a multithread application.. my application connects to the database can i open 2 connection at the same time? or can i thread the connection also. thanks in advance.  |
| | Hello! This is my first post here, hehe. Seems to be a great site. Anyways, I'm quite new in PHP, but it's fun and I think I'm learning quite fast :) There's appeared a problem for me now though, and I can't see what the problem is...? I have made …  |
| | Hello I am new to T SQL. I tried some project with sql command using C# coding. But now I am willing to consider running T SQL commands like making procedures using C# coding. ie. I want to my program run T SQL query/command. What/ How to do this? Thanks … |
| | Hi, I've been working on getting a GUI connected to a database so I can input data into the database. However when getting to the 'making a save button' I get this problem on line 14: Private da As New SqlDataAdapter("Select Name, Number, Email From Contacts", cs) Private ds As … |
| | Dim sqlconn As SqlConnection = New SqlConnection("data source=MCKAYLA\SQLEXPRESS;Initial Catalog=jhen_reg;Integrated Security=True") Dim sqlda As New SqlDataAdapter Dim sqlcmd As New SqlCommand Dim dt As New DataTable Dim sqlstr As String = "SELECT * FROM reg where Username=@Usernametextbox.text AND Password=@Passwordtextbox.text" With sqlcmd .CommandText = sqlstr .Connection = sqlconn .Parameters.AddWithValue("@Username", UsernameTextBox.Text) .Parameters.AddWithValue("@Password", PasswordTextBox.Text) … |
| | hi, i write a code like this $user_id = $hd_cookie['user_id']; $user_password = $hd_cookie['auth']; $sql = "SELECT * FROM hd_users WHERE user_id='$user_id' AND user_password='$user_password'"; $r_user = mysql_query($sql); $num=mysql_num_rows($r_user); //line 24 it shows Warning Warning: Supplied argument is not a valid MySQL result resource in c:\apache\htdocs\helpdeskfinal\includes\auth.php on line 24 when i print … |
| | Hi all, To perform the delete data from Product table by ProductID of Adventure Works database needs to use delete cascade. Has anyone done this yet? Can provide for me examples to do it? Thanks a lot! |
| | Hi everyone I am trying to copy one table from one database to another database, so can someone tell me how to that.  |
| | CREATE OR REPLACE PROCEDURE transfer( crdtacno IN NUMBER, dbtacno IN NUMBER, amount NUMBER, transno NUMBER ) IS BEGIN INSERT INTO transaction VALUES(transno,amount,SYSDATE); UPDATE account SET accbal=accbal+amount WHERE accno=crdtacno; INSERT INTO entrylist VALUES(transno,crdtacno,'CR'); UPDATE account SET accbal=accbal-amount WHERE accno=dbtacno; INSERT INTO entrylist VALUES(transno,dbtacno,'DB'); END; / |
| | HI GUYS .. im trying to make foreign key relation between whishlist_tbl(foreign) table and account_tbl(primary key) table both are integer data container ## scenario ## i have user deatail table that is account_tbl and whish list table i.e wishlist_tbl i want that when user make a wish book then he … |
| | Here is the code I'm running into an error with: FROM IndexPID INNER JOIN Demographics ON IndexPID.NDoc_Number = Demographics.NDoc_Number, PatientSupply INNER JOIN Demographics ON PatientSupply.NDocNum = Demographics.NDoc_Number I also tried it this way: FROM IndexPID, PatientSupply INNER JOIN Demographics ON IndexPID.NDoc_Number = Demographics.NDoc_Number INNER JOIN Demographics ON PatientSupply.NDocNum = Demographics.NDoc_Number … |
 | I am having trouble with this code: <?php // Username $username = $_POST['name']; $email = $_POST['email']; // MYSQL $con = mysql_connect('host','username','password') or die(); mysql_select_db('db', $con); $var = md5($email); $result = mysql_query("UPDATE `table` SET `imageEs`='$var' WHERE user_username='{$_SESSION['sessid']}'") or die(mysql_error()); echo "Profile image updated. <a href='http://www.awsomechat.comuv.com/update_profile.php'>Go back.</a>"; ?> I am trying to … |
| | I am having trouble with this code: <?php // Username $username = $_POST['name']; $email = $_POST['email']; $default = "default image"; $size = 40; // MYSQL mysql_connect('host','username','password'); mysql_select_db('database'); $grav_url = "www.gravatar.com/avatar/" . md5( strtolower( trim( $email ) ) ) . "?d=" . urlencode( $default ) . "&s=" . $size; $sql = …  |
| | Good day everyone, so here, i have a problem with my repeater control's sql query, what i would really want to happen, is i have a randomized number from 1 to 60, that will tell the database which test question to select, (if it's only one, it's not a problem, …  |
| | I keep getting this error message You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Hits and had 24,000 listener sessions; over 30 days. Get 5 commercials a day' at line 7 <!DOCTYPE … |
| | Hi, guys i m already done with DB part of my project !!! but confused here !!! (Check attached image) Admin will enter all relevant details in applicant-scrutiny table for each user ........but i want that value for each userid (foreign key) should be copied automatically !!! NOTE: USER table … |
The End.