2,569 Topics
 | |
 | Hey all, This website is a directory and the problem is authenticating users to edit a server, even after they've logged in. The idea is to stop any SQL mix-ups due to my weak code (I'm learning PHP). When they click 'Edit' next to the server after logging in they … |
| | Hey guys I have a mysql database that has an events table. The events table consists of the fields Title, Date, Place and description. I am trying to display the table on the browser using php coding. it should list important events first according to the date. so as follows …  |
| | In my page, there are 3 drop down menu. Dropdown 1 : for storing car model which retrieved from CarTab in database (SQL) Dropdown 2 : for storing username Dropdown 3 : for storing plate num The function of the all drop down menu, there are related to each other. …  |
 | when i use sha 512 on password field then it says k pasword field cannot be empty but when i remove sha512 constraint then it works and with any other hash it also works why ? and plz suggest me some good secrity hash etc to apply on password field |
| | Hi there, I have Page that goes to "sub categorys", but each time I upload a new product the subcategory gets duplicated each time, instead of having one "Vintage" category as I want I have duplicates. My current SQL query string is SELECT DISTINCT Picture, SubCategory, Categorie FROM Table1 WHERE …  |
| | Hi, I have a dynamically generated sql query that is generated in VB6 and then passed on to SQL Server 2005. The query joins(inner join, left join, etc.) multiple tables. If I were to execute that query in Sql Server Management Studio, I would get something like this: TrayID| TrayID … |
 | Hello hi. I am seeing flames with using FILESTREAM in SQL Server 2008! I have a table (Products), in which I wanna store a link to an image stored on disk, under the ProdPicture column. This is what the script looks like: CREATE TABLE PRODUCTS ( ProdID INT PRIMARY KEY, …  |
| | I'm making a B2B portal that can see just loggedin business customers that I add to base, I finished almost all, but there is one problem. When customer add some goods to his cart, goes to checkout and confirm his order he will have a link to invoice.php?ids=156 and that … |
| | I am really in mess as I am unable to solve problem with Smarty Multi Dimension array. Below is the way I want to execute Smarty. First of all I will list all customers. Than I want list of all items purchased by that customer. I have two tables inside … |
| | 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 … |
| | 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 …  |
 | 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 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 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 … |
| | 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 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 … |
| | 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! 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 …  |
| | 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 … |
| | 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.  |
| | 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, …  |
| | 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 … |
| | Hello! I need to write a query that selects TableID (a previously concatenated string) and also selects a substring of TableID as another column. All data in TableID is in the format %System.Variable, %Class.User, etc. I need to select from the % to the '.' to return something like %System … |
| | Hi, I'm just want to ask if it's possible if I want to update multiple record with same condition at the same time. For example, I have a table named *userTable*, it has two field, *year* and *status* fields. On year *field*, it has value of years and on *status* … |
| | i installed .net framework windows installer and then sql server 2008 then sql server management studio 2008 iam using windows xp it shows very less shared features while installation... i want to know why it showed so less features? is it because of poor hardware resources? |
 | hi all, I am new to php and have started some coding.I want to insert values in one table1 and update values of table2. It worked for me last day..but today it doesnt work.I have hardly changed any code.i guess except fr deleting some comments in code..u plz tell me … |
| | Hi, I have this datatable that I need to loop for my excel exporting function. And I have to export data that exceeds the row limit of excel worksheet. now I want to know how to create a query of limit on the datatable.select in such way like in sql. …  |
| | Hello Daniweb. Im currently working on a solution that involves querying a specific user (either by getting the user to 'login' or by detecting who the user is that is logged in to the machine) against the domains active directory structure to determine if they are a member of 1 … |
 | I have a dataset (GrindItems) with 4 datatables successfully populated from dbf files. If I understand the concept of a dataset, I no longer need an open connection to the source db and I should be able to query my dataset. My first question is whether I need a Connection … |
| | I'm trying to make multiplication in web shop that will show real price: **discount * tax * product price * 1 piece= real price** But I just don't know how to do it, I try 1 million things, spend about 48h just to make it, but, without success, no matter … |
| | I need to order these dates in descending order (last should be first) and in fact how they now appear. However they do not necessarily appear like those so I need a SQL Order By clause to order these descending: 2012-01-23 09:53:24.097105 2012-01-20 17:31:57.565458 2012-01-20 17:01:09.154587 2012-01-20 16:28:40.685735 2012-01-16 12:03:54.99954 … |
| | 0 down vote favorite I am trying to write a script that will return the latest values for a unique documentid-physician-patient triplet. I need the script to act similar to a group by statement, except group by only works with one column at a time. I need to date and … |
| | Hello all i have some problem with update query. select query works all right but update qurey doesn't i have tried to to run that query in mysql directly from phpmyadmin and it runs fine ... can you check what i m missing here in code in update query and … |
| | I've had this problem many, many times. And it's always turned out to be a small typo or "" around an integer, but I just cannot find what's wrong with my SQL Statement this time! [CODE]SELECT Card_ID FROM Payment WHERE Customer_ID = 12 AND Card_Number = 1231231231231231[/CODE] The table and … |
The End.