1,694 Topics
| |
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 … | |
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 = … | |
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? | |
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 … | |
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 … | |
I have a website for a painter where the painter uploads a picture. The picture name is added to a mdb (access) database table, the picture is added to the end of a table called galleries, and the file is uploaded. It is also then resized to a small image. … | |
Hi Friends I am new to asp.net, i want to display menu title from database using VB in asp.net, the display should be done in list format while href tag, i am expecting the display as below menu1 menu2 menu3 Please can any one help me to solve this issue. | |
I'm having a problem of displaying all the data of a column in a text file I can display only the first data, so please someone tell me what can I make to display them together in a text file. Connection con = DriverManager.getConnection(host, uname,password); Statement stmt = con.createStatement(); ResultSet … | |
Hoi At the moment I'm learing Databases. this is some code that I'm using. The question that I have is, can I insert a row without ID. I mean that the database increase the ID number itself. Thanks in advance. command = new OleDbCommand(); command.Connection = connect; command.CommandText = "INSERT … | |
Hi Friends i like to know more about the difference between mysql, Phpmyadmin, sql and also which one is more safe and secure for webpage. Can any one help me to know about it. | |
Hi, I am writing a Silverlight Bing Maps based application and I am trying to merge two (and more) polygons. The approach I am using at the moment is the following: The geometry for the polygons is stored in a database, and Im writing and reading from it through a … | |
OMG Optimization.... One of those things that is widely discussed but with no real specifics because everyones setup and situation is different. So I spent all day trying to find ways to accomplish this as our SQL server was maxed out. Let me do a bit of setup explination.... We … | |
Hello all, Correct me if I mis-post or should have posted this somewhere else. This is my first thread here so bear with me. I have had a lot of luck just browsing other issues to get my problems solved in the past, but this time I am stumped. More … | |
Hi all, I'm newbie in asp. I have a problem to delete the record on sql. I have one form for different users to insert data into sql where every user have are unique id, so it's possible to have multiple record with same unique id, then display the data … | |
protected void Button1_Click(object sender, EventArgs e) { try { SqlAddGroup.InsertParameters["mem_email"].DefaultValue = Session["User"].ToString(); SqlAddGroup.InsertParameters["groupname"].DefaultValue = Txtgroup.Text; SqlAddGroup.Insert(); Label1.Text = "Group has been added"; } catch (Exception ex) { Label1.Text = ex.Message; } } <asp:SqlDataSource ID="SqlAddGroup" runat="server" ConflictDetection="CompareAllValues" ConnectionString="<%$ ConnectionStrings:PadmaSMSConnectionString %>" DeleteCommand="DELETE FROM [group] WHERE [sno] = @original_sno AND [mem_email] = @original_mem_email … | |
Eventually i want to load names from a database to textboxes which are created at runtime. Thought i'd try just getting names into a listbox first though as i'm new to using databases in vb and for some reason nothings getting added to the listbox Heres the code iv'e got … |
The End.